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 FND_MSG_PUB

Line 529: FND_MSG_PUB.ADD;

525: WHERE CUST_ACCOUNT_ID = p_cust_account_rec.cust_account_id;
526:
527: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_DUPLICATE_COLUMN' );
528: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'cust_account_id' );
529: FND_MSG_PUB.ADD;
530: x_return_status := FND_API.G_RET_STS_ERROR;
531: EXCEPTION
532: WHEN NO_DATA_FOUND THEN
533: NULL;

Line 607: FND_MSG_PUB.ADD;

603: IF p_cust_account_rec.account_number IS NOT NULL AND
604: p_cust_account_rec.account_number <> FND_API.G_MISS_CHAR
605: THEN
606: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_ACCOUNT_NUMBER_AUTO_ON' );
607: FND_MSG_PUB.ADD;
608: x_return_status := FND_API.G_RET_STS_ERROR;
609: END IF;
610:
611: -- the account_number will be generated from sequence by table handler.

Line 633: FND_MSG_PUB.ADD;

629: p_cust_account_rec.account_number = FND_API.G_MISS_CHAR
630: THEN
631: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
632: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'account_number' );
633: FND_MSG_PUB.ADD;
634: x_return_status := FND_API.G_RET_STS_ERROR;
635: END IF;
636:
637: /*IF G_DEBUG THEN

Line 720: FND_MSG_PUB.ADD;

716: ( p_create_update_flag = 'U' AND l_rowid <> p_rowid )
717: THEN
718: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_DUPLICATE_COLUMN' );
719: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'account_number' );
720: FND_MSG_PUB.ADD;
721: x_return_status := FND_API.G_RET_STS_ERROR;
722: END IF;
723: EXCEPTION
724: WHEN NO_DATA_FOUND THEN

Line 781: FND_MSG_PUB.ADD;

777: WHERE ORIG_SYSTEM_REFERENCE = p_cust_account_rec.orig_system_reference;
778:
779: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_DUPLICATE_COLUMN' );
780: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'orig_system_reference' );
781: FND_MSG_PUB.ADD;
782: x_return_status := FND_API.G_RET_STS_ERROR;
783: EXCEPTION
784: WHEN NO_DATA_FOUND THEN
785: NULL;

Line 1144: FND_MSG_PUB.ADD;

1140: THEN
1141: FND_MESSAGE.SET_NAME('AR','HZ_API_COLUMN_SHOULD_BE_NULL');
1142: FND_MESSAGE.SET_TOKEN('COLUMN','TAX_CODE');
1143: FND_MESSAGE.SET_TOKEN('TABLE','HZ_CUST_ACCOUNTS');
1144: FND_MSG_PUB.ADD;
1145: x_return_status := FND_API.G_RET_STS_ERROR;
1146: END IF;
1147: */
1148:

Line 1186: FND_MSG_PUB.ADD;

1182: THEN
1183: FND_MESSAGE.SET_NAME('AR','HZ_API_COLUMN_SHOULD_BE_NULL');
1184: FND_MESSAGE.SET_TOKEN('COLUMN','ORDER_TYPE_ID');
1185: FND_MESSAGE.SET_TOKEN('TABLE','HZ_CUST_ACCOUNTS');
1186: FND_MSG_PUB.ADD;
1187: x_return_status := FND_API.G_RET_STS_ERROR;
1188: END IF;
1189:
1190:

Line 1242: FND_MSG_PUB.ADD;

1238: THEN
1239: FND_MESSAGE.SET_NAME('AR','HZ_API_COLUMN_SHOULD_BE_NULL');
1240: FND_MESSAGE.SET_TOKEN('COLUMN','PRIMARY_SALESREP_ID');
1241: FND_MESSAGE.SET_TOKEN('TABLE','HZ_CUST_ACCOUNTS');
1242: FND_MSG_PUB.ADD;
1243: x_return_status := FND_API.G_RET_STS_ERROR;
1244: END IF;
1245:
1246: /*

Line 1898: FND_MSG_PUB.ADD;

1894: FND_MESSAGE.SET_TOKEN('COLUMN1','ship_sets_include_lines_flag');
1895: FND_MESSAGE.SET_TOKEN('VALUE1','Y');
1896: FND_MESSAGE.SET_TOKEN('COLUMN2','arrivalsets_include_lines_flag');
1897: FND_MESSAGE.SET_TOKEN('VALUE2','N');
1898: FND_MSG_PUB.ADD;
1899: x_return_status := FND_API.G_RET_STS_ERROR;
1900: END IF;
1901: END ;
1902: END IF;

Line 1987: FND_MSG_PUB.ADD;

1983: FND_MESSAGE.SET_TOKEN('COLUMN1','arrivalsets_include_lines_flag');
1984: FND_MESSAGE.SET_TOKEN('VALUE1','Y');
1985: FND_MESSAGE.SET_TOKEN('COLUMN2','ship_sets_include_lines_flag');
1986: FND_MESSAGE.SET_TOKEN('VALUE2','N');
1987: FND_MSG_PUB.ADD;
1988: x_return_status := FND_API.G_RET_STS_ERROR;
1989: END IF;
1990: END ;
1991: END IF;

Line 2496: FND_MSG_PUB.ADD;

2492: AND STATUS='A'
2493: AND ORG_ID = p_cust_acct_relate_rec.org_id; -- Bug 3456489
2494:
2495: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_REL_ALREADY_EXISTS' );
2496: FND_MSG_PUB.ADD;
2497: x_return_status := FND_API.G_RET_STS_ERROR;
2498:
2499: EXCEPTION
2500: WHEN NO_DATA_FOUND THEN

Line 2886: FND_MSG_PUB.ADD;

2882: WHERE CUST_ACCOUNT_PROFILE_ID = p_customer_profile_rec.cust_account_profile_id;
2883:
2884: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_DUPLICATE_COLUMN' );
2885: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'cust_account_profile_id' );
2886: FND_MSG_PUB.ADD;
2887: x_return_status := FND_API.G_RET_STS_ERROR;
2888: EXCEPTION
2889: WHEN NO_DATA_FOUND THEN
2890: NULL;

Line 3054: FND_MSG_PUB.ADD;

3050: AND ROWNUM = 1;
3051:
3052: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_DUPLICATE_COLUMN' );
3053: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'cust_account_id' );
3054: FND_MSG_PUB.ADD;
3055: x_return_status := FND_API.G_RET_STS_ERROR;
3056: EXCEPTION
3057: WHEN NO_DATA_FOUND THEN
3058: NULL;

Line 3086: FND_MSG_PUB.ADD;

3082: AND CUST_ACCOUNT_ID = -1;
3083:
3084: FND_MESSAGE.SET_NAME( 'AR', 'HZ_ONLY_ONE_PROF_AT_PARTY_LEV' );
3085: FND_MESSAGE.SET_TOKEN( 'PARTY_ID', p_customer_profile_rec.party_id );
3086: FND_MSG_PUB.ADD;
3087: x_return_status := FND_API.G_RET_STS_ERROR;
3088: EXCEPTION
3089: WHEN NO_DATA_FOUND THEN
3090: NULL;

Line 3338: FND_MSG_PUB.ADD;

3334: p_customer_profile_rec.profile_class_id <> FND_API.G_MISS_NUM
3335: THEN
3336: IF p_customer_profile_rec.profile_class_id < 0 THEN
3337: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NEGATIVE_PROFILE_CLASS' );
3338: FND_MSG_PUB.ADD;
3339: x_return_status := FND_API.G_RET_STS_ERROR;
3340: ELSE
3341: BEGIN
3342: SELECT STATUS, NAME INTO l_class_status, l_profile_class_name

Line 3349: FND_MSG_PUB.ADD;

3345:
3346: IF l_class_status <> 'A' THEN
3347: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INACTIVE_PROFILE_CLASS' );
3348: FND_MESSAGE.SET_TOKEN( 'NAME', l_profile_class_name );
3349: FND_MSG_PUB.ADD;
3350: x_return_status := FND_API.G_RET_STS_ERROR;
3351: END IF;
3352: EXCEPTION
3353: WHEN NO_DATA_FOUND THEN

Line 3358: FND_MSG_PUB.ADD;

3354: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
3355: FND_MESSAGE.SET_TOKEN( 'FK', 'profile_class_id' );
3356: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'profile_class_id' );
3357: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_cust_profile_classes');
3358: FND_MSG_PUB.ADD;
3359: x_return_status := FND_API.G_RET_STS_ERROR;
3360: END;
3361: END IF;
3362:

Line 3463: FND_MSG_PUB.ADD;

3459: WHERE CUST_ACCT_SITE_ID = l_cust_acct_site_id;
3460:
3461: IF l_cust_account_id <> p_customer_profile_rec.cust_account_id THEN
3462: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_ACCT_SITEUSE_MISMATCH' );
3463: FND_MSG_PUB.ADD;
3464: x_return_status := FND_API.G_RET_STS_ERROR;
3465: END IF;
3466:
3467: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 3480: FND_MSG_PUB.ADD;

3476: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
3477: FND_MESSAGE.SET_TOKEN( 'FK', 'site_use_id' );
3478: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'site_use_id' );
3479: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_cust_site_uses' );
3480: FND_MSG_PUB.ADD;
3481: x_return_status := FND_API.G_RET_STS_ERROR;
3482: END;
3483:
3484: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 3501: FND_MSG_PUB.ADD;

3497: AND ROWNUM = 1;
3498:
3499: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_DUPLICATE_COLUMN' );
3500: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'cust_account_id' );
3501: FND_MSG_PUB.ADD;
3502: x_return_status := FND_API.G_RET_STS_ERROR;
3503: EXCEPTION
3504: WHEN NO_DATA_FOUND THEN
3505: NULL;

Line 3526: FND_MSG_PUB.ADD;

3522: THEN
3523: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_SITE_PROF_AT_PTY_LEV' );
3524: FND_MESSAGE.SET_TOKEN( 'PARTY_ID', p_customer_profile_rec.party_id );
3525: FND_MESSAGE.SET_TOKEN( 'SITE_USE_ID', p_customer_profile_rec.site_use_id );
3526: FND_MSG_PUB.ADD;
3527: x_return_status := FND_API.G_RET_STS_ERROR;
3528:
3529:
3530: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 4176: FND_MSG_PUB.ADD;

4172: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_VALUE_BETWEEN' );
4173: FND_MESSAGE.SET_TOKEN( 'COLUMN','tolerance');
4174: FND_MESSAGE.SET_TOKEN( 'VALUE1', '-100' );
4175: FND_MESSAGE.SET_TOKEN( 'VALUE2', '100' );
4176: FND_MSG_PUB.ADD;
4177: x_return_status := FND_API.G_RET_STS_ERROR;
4178: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4179: hz_utility_v2pub.debug(p_message=>'Tolerance should be between -100 and 100 .' ||
4180: 'x_return_status = ' || x_return_status,

Line 4212: FND_MSG_PUB.ADD;

4208: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_VALUE_BETWEEN' );
4209: FND_MESSAGE.SET_TOKEN( 'COLUMN','percent_collectable');
4210: FND_MESSAGE.SET_TOKEN( 'VALUE1', '0' );
4211: FND_MESSAGE.SET_TOKEN( 'VALUE2', '100' );
4212: FND_MSG_PUB.ADD;
4213: x_return_status := FND_API.G_RET_STS_ERROR;
4214:
4215: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4216: hz_utility_v2pub.debug(p_message=>'Percent_Collectable should be between 0 and 100 .' ||

Line 4511: FND_MSG_PUB.ADD;

4507: IF fnd_profile.value('HZ_API_ERR_ON_OBSOLETE_COLUMN')='Y'
4508: THEN
4509: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OBSOLETE_COLUMN');
4510: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'dunning_letter_set_id' );
4511: FND_MSG_PUB.ADD;
4512: x_return_status := FND_API.G_RET_STS_ERROR;
4513: END IF;
4514:
4515: END IF;

Line 4739: FND_MSG_PUB.ADD;

4735: FND_MESSAGE.SET_TOKEN( 'COLUMN1', 'discount_terms' );
4736: FND_MESSAGE.SET_TOKEN( 'VALUE1', 'N' );
4737: FND_MESSAGE.SET_TOKEN( 'COLUMN2', 'discount_grace_days');
4738: FND_MESSAGE.SET_TOKEN( 'VALUE2', 'NULL' );
4739: FND_MSG_PUB.ADD;
4740: x_return_status := FND_API.G_RET_STS_ERROR;
4741:
4742: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4743: hz_utility_v2pub.debug(p_message=>'discount_grace_days should be null when discount_terms is N.' ||

Line 4806: FND_MSG_PUB.ADD;

4802: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MAND_DEP_FIELDS' );
4803: FND_MESSAGE.SET_TOKEN('COLUMN1', 'dunning_letters');
4804: FND_MESSAGE.SET_TOKEN('VALUE1', 'Y');
4805: FND_MESSAGE.SET_TOKEN('COLUMN2','dunning_letter_set_id');
4806: FND_MSG_PUB.ADD;
4807: x_return_status := FND_API.G_RET_STS_ERROR;
4808:
4809: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4810: hz_utility_v2pub.debug(p_message=>'dunning_letter_set_id cannot be NULL when dunning_letters is Y.' ||

Line 4830: FND_MSG_PUB.ADD;

4826: FND_MESSAGE.SET_TOKEN('COLUMN1','dunning_letters');
4827: FND_MESSAGE.SET_TOKEN('VALUE1','N');
4828: FND_MESSAGE.SET_TOKEN('COLUMN2','dunning_letter_set_id');
4829: FND_MESSAGE.SET_TOKEN('VALUE2','NULL');
4830: FND_MSG_PUB.ADD;
4831: x_return_status := FND_API.G_RET_STS_ERROR;
4832:
4833: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4834: hz_utility_v2pub.debug(p_message=>'dunning_letter_set_id should be NULL when dunning_letters is N.' ||

Line 4907: FND_MSG_PUB.ADD;

4903: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MAND_DEP_FIELDS' );
4904: FND_MESSAGE.SET_TOKEN( 'COLUMN1','send_statements');
4905: FND_MESSAGE.SET_TOKEN( 'VALUE1','Y');
4906: FND_MESSAGE.SET_TOKEN( 'COLUMN2','statement_cycle_id');
4907: FND_MSG_PUB.ADD;
4908: x_return_status := FND_API.G_RET_STS_ERROR;
4909:
4910: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4911: hz_utility_v2pub.debug(p_message=>'statement_cycle_id cannot be NULL when send_statements

Line 4923: FND_MSG_PUB.ADD;

4919: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MAND_DEP_FIELDS' );
4920: FND_MESSAGE.SET_TOKEN( 'COLUMN1','send_statements');
4921: FND_MESSAGE.SET_TOKEN( 'VALUE1','Y');
4922: FND_MESSAGE.SET_TOKEN( 'COLUMN2','credit_balance_statements');
4923: FND_MSG_PUB.ADD;
4924: x_return_status := FND_API.G_RET_STS_ERROR;
4925:
4926: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4927: hz_utility_v2pub.debug(p_message=>'credit_balance_statements cannot be NULL when

Line 4948: FND_MSG_PUB.ADD;

4944: FND_MESSAGE.SET_TOKEN('COLUMN1', 'send_statements');
4945: FND_MESSAGE.SET_TOKEN('VALUE1', 'N');
4946: FND_MESSAGE.SET_TOKEN('COLUMN2','statement_cycle_id');
4947: FND_MESSAGE.SET_TOKEN('VALUE2', 'NULL');
4948: FND_MSG_PUB.ADD;
4949: x_return_status := FND_API.G_RET_STS_ERROR;
4950:
4951: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4952: hz_utility_v2pub.debug(p_message=>'statement_cycle_id should be NULL when send_statements

Line 4967: FND_MSG_PUB.ADD;

4963: FND_MESSAGE.SET_TOKEN('COLUMN1','send_statements');
4964: FND_MESSAGE.SET_TOKEN('VALUE1','N');
4965: FND_MESSAGE.SET_TOKEN('COLUMN2','credit_balance_statements');
4966: FND_MESSAGE.SET_TOKEN('VALUE2','N');
4967: FND_MSG_PUB.ADD;
4968: x_return_status := FND_API.G_RET_STS_ERROR;
4969:
4970: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4971: hz_utility_v2pub.debug(p_message=>'credit_balance_statements should be N when send_statements

Line 5053: FND_MSG_PUB.ADD;

5049: IF v_customer_profile_rec.interest_period_days = FND_API.G_MISS_NUM OR
5050: v_customer_profile_rec.interest_period_days IS NULL
5051: THEN
5052: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_VAL_INT_CHARGES_Y' );
5053: FND_MSG_PUB.ADD;
5054: x_return_status := FND_API.G_RET_STS_ERROR;
5055: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5056: hz_utility_v2pub.debug(p_message=>'interest_period_days cannot be NULL when interest_charges is Y.' || 'x_return_status = ' || x_return_status,
5057: p_prefix =>l_debug_prefix,

Line 5093: FND_MSG_PUB.ADD;

5089: FND_MESSAGE.SET_TOKEN( 'COLUMN1','interest_charges');
5090: FND_MESSAGE.SET_TOKEN( 'VALUE1','N');
5091: FND_MESSAGE.SET_TOKEN( 'COLUMN2','interest_period_days');
5092: FND_MESSAGE.SET_TOKEN( 'VALUE2','NULL');
5093: FND_MSG_PUB.ADD;
5094: x_return_status := FND_API.G_RET_STS_ERROR;
5095:
5096: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5097: hz_utility_v2pub.debug(p_message=>'Interest_period_days should be NULL when interest_charges

Line 5111: FND_MSG_PUB.ADD;

5107: FND_MESSAGE.SET_TOKEN( 'COLUMN1','interest_charges');
5108: FND_MESSAGE.SET_TOKEN( 'VALUE1','N');
5109: FND_MESSAGE.SET_TOKEN( 'COLUMN2','charge_on_finance_charge_flag');
5110: FND_MESSAGE.SET_TOKEN( 'VALUE2','N');
5111: FND_MSG_PUB.ADD;
5112: x_return_status := FND_API.G_RET_STS_ERROR;
5113:
5114: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5115: hz_utility_v2pub.debug(p_message=>'charge_on_finance_charge_flag cannot be Y when

Line 5418: FND_MSG_PUB.ADD;

5414: (p_customer_profile_rec.late_charge_term_id IS NOT NULL AND p_customer_profile_rec.late_charge_term_id <> FND_API.G_MISS_NUM))) THEN
5415: -- Late charge payment term is required when
5416: -- late charge type is debit memo or interest invoice
5417: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_LC_PAY_TERM' );
5418: FND_MSG_PUB.ADD;
5419: x_return_status := FND_API.G_RET_STS_ERROR;
5420: END IF;
5421:
5422: IF p_customer_profile_rec.late_charge_term_id is NOT NULL AND

Line 5461: FND_MSG_PUB.ADD;

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
5458: -- Message text can be entered only when
5459: -- late charge type is debit memo or interest invoice
5460: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_MSG_FOR_LC_TYPE' );
5461: FND_MSG_PUB.ADD;
5462: x_return_status := FND_API.G_RET_STS_ERROR;
5463: END IF;
5464:
5465: IF p_customer_profile_rec.message_text_id is NOT NULL AND

Line 5638: FND_MSG_PUB.ADD;

5634: WHERE CUST_ACCT_PROFILE_AMT_ID = p_cust_profile_amt_rec.cust_acct_profile_amt_id;
5635:
5636: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_DUPLICATE_COLUMN' );
5637: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'cust_acct_profile_amt_id' );
5638: FND_MSG_PUB.ADD;
5639: x_return_status := FND_API.G_RET_STS_ERROR;
5640: EXCEPTION
5641: WHEN NO_DATA_FOUND THEN
5642: NULL;

Line 5736: FND_MSG_PUB.ADD;

5732: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
5733: FND_MESSAGE.SET_TOKEN( 'FK', 'cust_account_profile_id' );
5734: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'cust_account_profile_id' );
5735: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_customer_profiles' );
5736: FND_MSG_PUB.ADD;
5737: x_return_status := FND_API.G_RET_STS_ERROR;
5738: END;
5739:
5740: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 5832: FND_MSG_PUB.ADD;

5828:
5829: IF p_cust_profile_amt_rec.cust_account_id <> l_cust_account_id THEN
5830: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_PROF_AMT_IDS_MISMATCH' );
5831: FND_MESSAGE.SET_TOKEN( 'ENTITY', 'customer' );
5832: FND_MSG_PUB.ADD;
5833: x_return_status := FND_API.G_RET_STS_ERROR;
5834: END IF;
5835:
5836: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 5931: FND_MSG_PUB.ADD;

5927: AND ROWNUM = 1;
5928:
5929: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_DUPLICATE_COLUMN' );
5930: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'cust_account_profile_id - currency_code' );
5931: FND_MSG_PUB.ADD;
5932: x_return_status := FND_API.G_RET_STS_ERROR;
5933: EXCEPTION
5934: WHEN NO_DATA_FOUND THEN
5935: NULL;

Line 6011: FND_MSG_PUB.ADD;

6007: l_site_use_id IS NOT NULL )
6008: THEN
6009: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_PROF_AMT_IDS_MISMATCH' );
6010: FND_MESSAGE.SET_TOKEN( 'ENTITY', 'site use' );
6011: FND_MSG_PUB.ADD;
6012: x_return_status := FND_API.G_RET_STS_ERROR;
6013: END IF;
6014:
6015: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 6086: FND_MSG_PUB.ADD;

6082: THEN
6083: IF p_cust_profile_amt_rec.overall_credit_limit < p_cust_profile_amt_rec.trx_credit_limit
6084: THEN
6085: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_VAL_OVERALL_CREDIT' );
6086: FND_MSG_PUB.ADD;
6087: x_return_status := FND_API.G_RET_STS_ERROR;
6088:
6089: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
6090: hz_utility_v2pub.debug(p_message=>'overall_credit_limit should be greater than the trx_credit_limit. ' ||

Line 6327: FND_MSG_PUB.ADD;

6323: IF v_cust_profile_amt_rec.min_fc_invoice_overdue_type = 'AMOUNT' THEN
6324: IF (v_cust_profile_amt_rec.min_fc_invoice_amount IS NULL OR
6325: v_cust_profile_amt_rec.min_fc_invoice_percent IS NOT NULL) THEN
6326: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_LC_INVALID_PERCENT' );
6327: FND_MSG_PUB.ADD;
6328: x_return_status := FND_API.G_RET_STS_ERROR;
6329: END IF;
6330: ELSIF v_cust_profile_amt_rec.min_fc_invoice_overdue_type = 'PERCENT' THEN
6331: IF (v_cust_profile_amt_rec.min_fc_invoice_amount IS NOT NULL OR

Line 6334: FND_MSG_PUB.ADD;

6330: ELSIF v_cust_profile_amt_rec.min_fc_invoice_overdue_type = 'PERCENT' THEN
6331: IF (v_cust_profile_amt_rec.min_fc_invoice_amount IS NOT NULL OR
6332: v_cust_profile_amt_rec.min_fc_invoice_percent IS NULL) THEN
6333: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_LC_INVALID_PERCENT' );
6334: FND_MSG_PUB.ADD;
6335: x_return_status := FND_API.G_RET_STS_ERROR;
6336: ELSE
6337: check_less_than_100 (
6338: p_column => 'min_fc_invoice_percent',

Line 6353: FND_MSG_PUB.ADD;

6349: ELSE
6350: IF (v_cust_profile_amt_rec.min_fc_invoice_amount IS NOT NULL OR
6351: v_cust_profile_amt_rec.min_fc_invoice_percent IS NOT NULL) THEN
6352: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_LC_INVALID_PERCENT' );
6353: FND_MSG_PUB.ADD;
6354: x_return_status := FND_API.G_RET_STS_ERROR;
6355: END IF;
6356: END IF;
6357:

Line 6408: FND_MSG_PUB.ADD;

6404: IF v_cust_profile_amt_rec.min_fc_balance_overdue_type = 'AMOUNT' THEN
6405: IF (v_cust_profile_amt_rec.min_fc_balance_amount IS NULL OR
6406: v_cust_profile_amt_rec.min_fc_balance_percent IS NOT NULL) THEN
6407: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_LC_INVALID_BAL_AMT' );
6408: FND_MSG_PUB.ADD;
6409: x_return_status := FND_API.G_RET_STS_ERROR;
6410: END IF;
6411: ELSIF v_cust_profile_amt_rec.min_fc_balance_overdue_type = 'PERCENT' THEN
6412: IF (v_cust_profile_amt_rec.min_fc_balance_amount IS NOT NULL OR

Line 6415: FND_MSG_PUB.ADD;

6411: ELSIF v_cust_profile_amt_rec.min_fc_balance_overdue_type = 'PERCENT' THEN
6412: IF (v_cust_profile_amt_rec.min_fc_balance_amount IS NOT NULL OR
6413: v_cust_profile_amt_rec.min_fc_balance_percent IS NULL) THEN
6414: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_LC_INVALID_BAL_AMT' );
6415: FND_MSG_PUB.ADD;
6416: x_return_status := FND_API.G_RET_STS_ERROR;
6417: ELSE
6418: check_less_than_100 (
6419: p_column => 'min_fc_balance_percent',

Line 6434: FND_MSG_PUB.ADD;

6430: ELSE
6431: IF (v_cust_profile_amt_rec.min_fc_balance_amount IS NOT NULL OR
6432: v_cust_profile_amt_rec.min_fc_balance_percent IS NOT NULL) THEN
6433: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_LC_INVALID_BAL_AMT' );
6434: FND_MSG_PUB.ADD;
6435: x_return_status := FND_API.G_RET_STS_ERROR;
6436: END IF;
6437: END IF;
6438:

Line 6497: FND_MSG_PUB.ADD;

6493: IF (v_cust_profile_amt_rec.interest_rate IS NULL OR
6494: v_cust_profile_amt_rec.interest_fixed_amount IS NOT NULL OR
6495: v_cust_profile_amt_rec.interest_schedule_id IS NOT NULL) THEN
6496: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_LC_INVALID_INT_RATE' );
6497: FND_MSG_PUB.ADD;
6498: x_return_status := FND_API.G_RET_STS_ERROR;
6499: ELSE
6500: check_less_than_100 (
6501: p_column => 'interest_rate',

Line 6517: FND_MSG_PUB.ADD;

6513: IF (v_cust_profile_amt_rec.interest_rate IS NOT NULL OR
6514: v_cust_profile_amt_rec.interest_fixed_amount IS NULL OR
6515: v_cust_profile_amt_rec.interest_schedule_id IS NOT NULL) THEN
6516: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_LC_INVALID_INT_RATE' );
6517: FND_MSG_PUB.ADD;
6518: x_return_status := FND_API.G_RET_STS_ERROR;
6519: END IF;
6520: /*6469663 Late charge enhacement handling case oftier basis calculation*/
6521: ELSIF v_cust_profile_amt_rec.interest_type IN ( 'CHARGES_SCHEDULE','CHARGE_PER_TIER') THEN

Line 6526: FND_MSG_PUB.ADD;

6522: IF (v_cust_profile_amt_rec.interest_rate IS NOT NULL OR
6523: v_cust_profile_amt_rec.interest_fixed_amount IS NOT NULL OR
6524: v_cust_profile_amt_rec.interest_schedule_id IS NULL) THEN
6525: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_LC_INVALID_INT_RATE' );
6526: FND_MSG_PUB.ADD;
6527: x_return_status := FND_API.G_RET_STS_ERROR;
6528: ELSE
6529: check_charge_schedule_id_fk (
6530: p_column => 'interest_schedule_id',

Line 6546: FND_MSG_PUB.ADD;

6542: IF (v_cust_profile_amt_rec.interest_rate IS NOT NULL OR
6543: v_cust_profile_amt_rec.interest_fixed_amount IS NOT NULL OR
6544: v_cust_profile_amt_rec.interest_schedule_id IS NOT NULL) THEN
6545: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_LC_INVALID_INT_RATE' );
6546: FND_MSG_PUB.ADD;
6547: x_return_status := FND_API.G_RET_STS_ERROR;
6548: END IF;
6549: END IF;
6550:

Line 6609: FND_MSG_PUB.ADD;

6605: IF (v_cust_profile_amt_rec.penalty_rate IS NULL OR
6606: v_cust_profile_amt_rec.penalty_fixed_amount IS NOT NULL OR
6607: v_cust_profile_amt_rec.penalty_schedule_id IS NOT NULL) THEN
6608: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_LC_INVALID_PEN_RATE' );
6609: FND_MSG_PUB.ADD;
6610: x_return_status := FND_API.G_RET_STS_ERROR;
6611: ELSE
6612: check_less_than_100 (
6613: p_column => 'penalty_rate',

Line 6629: FND_MSG_PUB.ADD;

6625: IF (v_cust_profile_amt_rec.penalty_rate IS NOT NULL OR
6626: v_cust_profile_amt_rec.penalty_fixed_amount IS NULL OR
6627: v_cust_profile_amt_rec.penalty_schedule_id IS NOT NULL) THEN
6628: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_LC_INVALID_PEN_RATE' );
6629: FND_MSG_PUB.ADD;
6630: x_return_status := FND_API.G_RET_STS_ERROR;
6631: END IF;
6632: /*6469663 Late charge enhacement handling case oftier basis calculation*/
6633: ELSIF v_cust_profile_amt_rec.penalty_type IN ('CHARGES_SCHEDULE','CHARGE_PER_TIER') THEN

Line 6638: FND_MSG_PUB.ADD;

6634: IF (v_cust_profile_amt_rec.penalty_rate IS NOT NULL OR
6635: v_cust_profile_amt_rec.penalty_fixed_amount IS NOT NULL OR
6636: v_cust_profile_amt_rec.penalty_schedule_id IS NULL) THEN
6637: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_LC_INVALID_PEN_RATE' );
6638: FND_MSG_PUB.ADD;
6639: x_return_status := FND_API.G_RET_STS_ERROR;
6640: ELSE
6641: check_charge_schedule_id_fk (
6642: p_column => 'penalty_schedule_id',

Line 6658: FND_MSG_PUB.ADD;

6654: IF (v_cust_profile_amt_rec.penalty_rate IS NOT NULL OR
6655: v_cust_profile_amt_rec.penalty_fixed_amount IS NOT NULL OR
6656: v_cust_profile_amt_rec.penalty_schedule_id IS NOT NULL) THEN
6657: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_LC_INVALID_PEN_RATE' );
6658: FND_MSG_PUB.ADD;
6659: x_return_status := FND_API.G_RET_STS_ERROR;
6660: END IF;
6661: END IF;
6662:

Line 6780: FND_MSG_PUB.ADD;

6776: WHERE CUST_ACCT_SITE_ID = p_cust_acct_site_rec.cust_acct_site_id;
6777:
6778: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_DUPLICATE_COLUMN' );
6779: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'cust_acct_site_id' );
6780: FND_MSG_PUB.ADD;
6781: x_return_status := FND_API.G_RET_STS_ERROR;
6782: EXCEPTION
6783: WHEN NO_DATA_FOUND THEN
6784: NULL;

Line 6972: FND_MSG_PUB.ADD;

6968:
6969: EXCEPTION
6970: WHEN NO_DATA_FOUND THEN
6971: FND_MESSAGE.SET_NAME( 'AR', 'HZ_LOC_CONTENT_INVALID' );
6972: FND_MSG_PUB.ADD;
6973: x_return_status := FND_API.G_RET_STS_ERROR;
6974: END;
6975:
6976: -- Debug info.

Line 6998: FND_MSG_PUB.ADD;

6994: AND ROWNUM = 1;
6995:
6996: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_DUPLICATE_COLUMN' );
6997: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'cust_account_id - party_site_id' );
6998: FND_MSG_PUB.ADD;
6999: x_return_status := FND_API.G_RET_STS_ERROR;
7000: EXCEPTION
7001: WHEN NO_DATA_FOUND THEN
7002: NULL;

Line 7047: FND_MSG_PUB.ADD;

7043: AND ORG_ID = p_cust_acct_site_rec.org_id;
7044:
7045: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_DUPLICATE_COLUMN' );
7046: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'orig_system_reference' );
7047: FND_MSG_PUB.ADD;
7048: x_return_status := FND_API.G_RET_STS_ERROR;
7049: EXCEPTION
7050: WHEN NO_DATA_FOUND THEN
7051: NULL;

Line 7153: FND_MSG_PUB.ADD;

7149: ( p_create_update_flag = 'U' AND l_rowid <> p_rowid )
7150: THEN
7151: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_DUPLICATE_COLUMN' );
7152: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'tp_header_id' );
7153: FND_MSG_PUB.ADD;
7154: x_return_status := FND_API.G_RET_STS_ERROR;
7155: END IF;
7156: EXCEPTION
7157: WHEN NO_DATA_FOUND THEN

Line 7283: FND_MSG_PUB.ADD;

7279: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
7280: FND_MESSAGE.SET_TOKEN( 'FK', 'language' );
7281: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'language_code' );
7282: FND_MESSAGE.SET_TOKEN( 'TABLE', 'fnd_languages(installed)' );
7283: FND_MSG_PUB.ADD;
7284: x_return_status := FND_API.G_RET_STS_ERROR;
7285: END;
7286:
7287: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 7404: FND_MSG_PUB.ADD;

7400: and org_id = p_cust_acct_site_rec.org_id; -- Bug 3456489
7401:
7402: IF l_count > 0 THEN
7403: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_ADDR_EDI_LOC_EXISTS' );
7404: FND_MSG_PUB.ADD;
7405: x_return_status := FND_API.G_RET_STS_ERROR;
7406: END IF;
7407: END IF;
7408: END IF;

Line 7423: FND_MSG_PUB.ADD;

7419: and org_id = p_cust_acct_site_rec.org_id; -- Bug 3456489
7420:
7421: IF l_count > 0 THEN
7422: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_ADDR_EDI_LOC_EXISTS' );
7423: FND_MSG_PUB.ADD;
7424: x_return_status := FND_API.G_RET_STS_ERROR;
7425: END IF;
7426: END IF;
7427: END IF;

Line 7605: FND_MSG_PUB.ADD;

7601: WHERE SITE_USE_ID = p_cust_site_use_rec.site_use_id;
7602:
7603: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_DUPLICATE_COLUMN' );
7604: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'cust_site_use_id' );
7605: FND_MSG_PUB.ADD;
7606: x_return_status := FND_API.G_RET_STS_ERROR;
7607: EXCEPTION
7608: WHEN NO_DATA_FOUND THEN
7609: NULL;

Line 7868: FND_MSG_PUB.ADD;

7864: ELSIF l_site_use_code = 'STMTS' THEN
7865: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_ONE_ACTIVE_STMTS_SITE' );
7866: END IF;
7867:
7868: FND_MSG_PUB.ADD;
7869: x_return_status := FND_API.G_RET_STS_ERROR;
7870:
7871: EXCEPTION
7872: WHEN NO_DATA_FOUND THEN

Line 7900: FND_MSG_PUB.ADD;

7896: AND ROWNUM = 1;
7897:
7898: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_DUPLICATE_COLUMN' );
7899: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'cust_acct_site_id - site_use_code' );
7900: FND_MSG_PUB.ADD;
7901: x_return_status := FND_API.G_RET_STS_ERROR;
7902: EXCEPTION
7903: WHEN NO_DATA_FOUND THEN
7904: NULL;

Line 7951: FND_MSG_PUB.ADD;

7947: THEN
7948: IF l_profile = 'N' THEN
7949: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
7950: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'location' );
7951: FND_MSG_PUB.ADD;
7952: x_return_status := FND_API.G_RET_STS_ERROR;
7953: END IF;
7954:
7955: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 8006: FND_MSG_PUB.ADD;

8002: AND ROWNUM = 1;
8003:
8004:
8005: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_DUP_CODE_LOCATION' );
8006: FND_MSG_PUB.ADD;
8007: x_return_status := FND_API.G_RET_STS_ERROR;
8008:
8009: EXCEPTION
8010: WHEN NO_DATA_FOUND THEN

Line 8084: FND_MSG_PUB.ADD;

8080: AND BILL_TO_FLAG = 'Y' );
8081: EXCEPTION
8082: WHEN NO_DATA_FOUND THEN
8083: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_BILL_TO_SITE_USE_F' );
8084: FND_MSG_PUB.ADD;
8085: x_return_status := FND_API.G_RET_STS_ERROR;
8086: END;
8087:
8088: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 8097: FND_MSG_PUB.ADD;

8093: END IF;
8094:
8095: ELSE
8096: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_BILL_TO_SITE_USE_S' );
8097: FND_MSG_PUB.ADD;
8098: x_return_status := FND_API.G_RET_STS_ERROR;
8099: END IF;
8100: END IF;
8101:

Line 8123: FND_MSG_PUB.ADD;

8119: AND hsu.bill_to_site_use_id = p_cust_site_use_rec.site_use_id
8120: AND rownum = 1;
8121:
8122: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_SHIP_TO_SITES_EXIST' );
8123: FND_MSG_PUB.ADD;
8124: x_return_status := FND_API.G_RET_STS_ERROR;
8125:
8126: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
8127: hz_utility_v2pub.debug(p_message=>'For BILL_TO site use, inactivation not allowed if a SHIP_TO address uses this BILL_TO address ' ||

Line 8308: FND_MSG_PUB.ADD;

8304: AND ROWNUM = 1;
8305:
8306: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_ONE_PRIMARY_SU' );
8307: FND_MESSAGE.SET_TOKEN( 'SITE_CODE', l_site_use_code );
8308: FND_MSG_PUB.ADD;
8309: x_return_status := FND_API.G_RET_STS_ERROR;
8310:
8311: EXCEPTION
8312: WHEN NO_DATA_FOUND THEN

Line 8364: fnd_msg_pub.add;

8360: fnd_message.set_name('AR', 'HZ_API_INACTIVE_CANNOT_PRIM');
8361: fnd_message.set_token('ENTITY', 'Site Use');
8362: -- fnd_message.set_token('COLUMN1', 'primary_flag');
8363: -- fnd_message.set_token('COLUMN2', 'status');
8364: fnd_msg_pub.add;
8365: x_return_status := FND_API.G_RET_STS_ERROR;
8366: -- reset l_error for later use.
8367: l_error := FALSE;
8368: END IF;

Line 8466: FND_MSG_PUB.ADD;

8462: FND_MESSAGE.SET_TOKEN('COLUMN1','ship_sets_include_lines_flag');
8463: FND_MESSAGE.SET_TOKEN('VALUE1','Y');
8464: FND_MESSAGE.SET_TOKEN('COLUMN2','arrivalsets_include_lines_flag');
8465: FND_MESSAGE.SET_TOKEN('VALUE2','N');
8466: FND_MSG_PUB.ADD;
8467: x_return_status := FND_API.G_RET_STS_ERROR;
8468: END IF;
8469: END ;
8470: END IF;

Line 8535: FND_MSG_PUB.ADD;

8531: FND_MESSAGE.SET_TOKEN('COLUMN1','arrivalsets_include_lines_flag');
8532: FND_MESSAGE.SET_TOKEN('VALUE1','Y');
8533: FND_MESSAGE.SET_TOKEN('COLUMN2','ship_sets_include_lines_flag');
8534: FND_MESSAGE.SET_TOKEN('VALUE2','N');
8535: FND_MSG_PUB.ADD;
8536: x_return_status := FND_API.G_RET_STS_ERROR;
8537: END IF;
8538: END ;
8539: END IF;

Line 9048: FND_MSG_PUB.ADD;

9044: ( p_cust_site_use_rec.gl_id_unearned IS NOT NULL AND
9045: p_cust_site_use_rec.gl_id_unearned <> FND_API.G_MISS_NUM )
9046: THEN
9047: FND_MESSAGE.SET_NAME( 'AR', 'AR_AUTO_CCID_INVALID' );
9048: FND_MSG_PUB.ADD;
9049: x_return_status := FND_API.G_RET_STS_ERROR;
9050: END IF;
9051:
9052: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 9076: FND_MSG_PUB.ADD;

9072: ( p_cust_site_use_rec.gl_id_factor IS NOT NULL AND
9073: p_cust_site_use_rec.gl_id_factor <> FND_API.G_MISS_NUM )
9074: THEN
9075: FND_MESSAGE.SET_NAME( 'AR', 'AR_AUTO_CCID_INVALID' );
9076: FND_MSG_PUB.ADD;
9077: x_return_status := FND_API.G_RET_STS_ERROR;
9078: END IF;
9079:
9080: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 9099: FND_MSG_PUB.ADD;

9095: IF ( p_cust_site_use_rec.gl_id_rec IS NOT NULL AND
9096: p_cust_site_use_rec.gl_id_rec <> FND_API.G_MISS_NUM )
9097: THEN
9098: FND_MESSAGE.SET_NAME( 'AR', 'AR_AUTO_CCID_INVALID' );
9099: FND_MSG_PUB.ADD;
9100: x_return_status := FND_API.G_RET_STS_ERROR;
9101: END IF;
9102:
9103: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 9535: FND_MSG_PUB.ADD;

9531: WHERE CUST_ACCOUNT_ROLE_ID = p_cust_account_role_rec.cust_account_role_id;
9532:
9533: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_DUPLICATE_COLUMN' );
9534: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'cust_account_role_id' );
9535: FND_MSG_PUB.ADD;
9536: x_return_status := FND_API.G_RET_STS_ERROR;
9537: EXCEPTION
9538: WHEN NO_DATA_FOUND THEN
9539: NULL;

Line 9767: FND_MSG_PUB.ADD;

9763: END;
9764:
9765: IF l_cust_account_id <> p_cust_account_role_rec.cust_account_id THEN
9766: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_ACCT_SITE_MISSMATCH' );
9767: FND_MSG_PUB.ADD;
9768: x_return_status := FND_API.G_RET_STS_ERROR;
9769: END IF;
9770:
9771: EXCEPTION

Line 9777: FND_MSG_PUB.ADD;

9773: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
9774: FND_MESSAGE.SET_TOKEN( 'FK', 'cust_acct_site_id' );
9775: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'cust_acct_site_id' );
9776: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_cust_acct_sites' );
9777: FND_MSG_PUB.ADD;
9778: x_return_status := FND_API.G_RET_STS_ERROR;
9779: END;
9780:
9781: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 9885: FND_MSG_PUB.ADD;

9881: AND ROWNUM = 1;
9882:
9883: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_DUPLICATE_COLUMN' );
9884: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'cust_account_id - party_id - role_type' );
9885: FND_MSG_PUB.ADD;
9886: x_return_status := FND_API.G_RET_STS_ERROR;
9887: EXCEPTION
9888: WHEN NO_DATA_FOUND THEN
9889: NULL;

Line 9911: FND_MSG_PUB.ADD;

9907: AND ROWNUM = 1;
9908:
9909: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_DUPLICATE_COLUMN' );
9910: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'cust_acct_site_id - party_id - role_type' );
9911: FND_MSG_PUB.ADD;
9912: x_return_status := FND_API.G_RET_STS_ERROR;
9913: EXCEPTION
9914: WHEN NO_DATA_FOUND THEN
9915: NULL;

Line 9946: FND_MSG_PUB.ADD;

9942: AND ROWNUM = 1;
9943:
9944: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_DUPLICATE_COLUMN' );
9945: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'cust_acct_site_id - party_id - role_type' );
9946: FND_MSG_PUB.ADD;
9947: x_return_status := FND_API.G_RET_STS_ERROR;
9948: EXCEPTION
9949: WHEN NO_DATA_FOUND THEN
9950: NULL;

Line 9975: FND_MSG_PUB.ADD;

9971: AND ROWNUM = 1;
9972:
9973: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_DUPLICATE_COLUMN' );
9974: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'cust_account_id - party_id - role_type' );
9975: FND_MSG_PUB.ADD;
9976: x_return_status := FND_API.G_RET_STS_ERROR;
9977: EXCEPTION
9978: WHEN NO_DATA_FOUND THEN
9979: NULL;

Line 10109: FND_MSG_PUB.ADD;

10105: AND ROWNUM = 1;
10106:
10107: FND_MESSAGE.SET_NAME( 'AR', 'HZ_CUST_ACCT_ROLE_PRIMARY' );
10108: FND_MESSAGE.SET_TOKEN( 'ENTITY', 'account' );
10109: FND_MSG_PUB.ADD;
10110: x_return_status := FND_API.G_RET_STS_ERROR;
10111: EXCEPTION
10112: WHEN NO_DATA_FOUND THEN
10113: NULL;

Line 10136: FND_MSG_PUB.ADD;

10132: AND ROWNUM = 1;
10133:
10134: FND_MESSAGE.SET_NAME( 'AR', 'HZ_CUST_ACCT_ROLE_PRIMARY' );
10135: FND_MESSAGE.SET_TOKEN( 'ENTITY', 'account site' );
10136: FND_MSG_PUB.ADD;
10137: x_return_status := FND_API.G_RET_STS_ERROR;
10138: EXCEPTION
10139: WHEN NO_DATA_FOUND THEN
10140: NULL;

Line 10339: FND_MSG_PUB.ADD;

10335: WHERE RESPONSIBILITY_ID = p_role_responsibility_rec.responsibility_id;
10336:
10337: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_DUPLICATE_COLUMN' );
10338: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'responsibility_id' );
10339: FND_MSG_PUB.ADD;
10340: x_return_status := FND_API.G_RET_STS_ERROR;
10341: EXCEPTION
10342: WHEN NO_DATA_FOUND THEN
10343: NULL;

Line 10510: FND_MSG_PUB.ADD;

10506: AND ROWNUM = 1;
10507:
10508: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_DUPLICATE_COLUMN' );
10509: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'cust_account_role_id - responsibility_type' );
10510: FND_MSG_PUB.ADD;
10511: x_return_status := FND_API.G_RET_STS_ERROR;
10512: EXCEPTION
10513: WHEN NO_DATA_FOUND THEN
10514: NULL;

Line 10606: FND_MSG_PUB.ADD;

10602: p_create_update_flag = 'U' AND ROWID <> p_rowid )
10603: AND ROWNUM = 1;
10604:
10605: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_ROLE_PRIMARY' );
10606: FND_MSG_PUB.ADD;
10607: x_return_status := FND_API.G_RET_STS_ERROR;
10608: EXCEPTION
10609: WHEN NO_DATA_FOUND THEN
10610: NULL;

Line 10690: FND_MSG_PUB.ADD;

10686: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
10687: FND_MESSAGE.SET_TOKEN( 'FK', 'cust_account_id' );
10688: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
10689: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_cust_accounts' );
10690: FND_MSG_PUB.ADD;
10691: x_return_status := FND_API.G_RET_STS_ERROR;
10692:
10693: END check_cust_account_fk;
10694:

Line 10717: FND_MSG_PUB.ADD;

10713: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
10714: FND_MESSAGE.SET_TOKEN( 'FK', 'cust_acct_site_id' );
10715: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
10716: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_cust_acct_sites' );
10717: FND_MSG_PUB.ADD;
10718: x_return_status := FND_API.G_RET_STS_ERROR;
10719:
10720: END check_cust_acct_site_fk;
10721:

Line 10751: FND_MSG_PUB.ADD;

10747: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
10748: FND_MESSAGE.SET_TOKEN( 'FK', 'site_use_id' );
10749: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
10750: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_cust_site_uses' );
10751: FND_MSG_PUB.ADD;
10752: x_return_status := FND_API.G_RET_STS_ERROR;
10753:
10754: END check_cust_site_use_fk;
10755: PROCEDURE check_cust_site_use_cont_fk(

Line 10775: FND_MSG_PUB.ADD;

10771: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
10772: FND_MESSAGE.SET_TOKEN( 'FK', 'contact_id' );
10773: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
10774: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_cust_account_roles' );
10775: FND_MSG_PUB.ADD;
10776: x_return_status := FND_API.G_RET_STS_ERROR;
10777:
10778: END check_cust_site_use_cont_fk;
10779:

Line 10799: FND_MSG_PUB.ADD;

10795: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
10796: FND_MESSAGE.SET_TOKEN( 'FK', 'cust_account_role_id' );
10797: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
10798: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_cust_account_roles' );
10799: FND_MSG_PUB.ADD;
10800: x_return_status := FND_API.G_RET_STS_ERROR;
10801:
10802: END check_cust_account_role_fk;
10803:

Line 10832: FND_MSG_PUB.ADD;

10828: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
10829: FND_MESSAGE.SET_TOKEN( 'FK', 'person_id' );
10830: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
10831: FND_MESSAGE.SET_TOKEN( 'TABLE', 'per_all_people_f' );
10832: FND_MSG_PUB.ADD;
10833: x_return_status := FND_API.G_RET_STS_ERROR;
10834:
10835: END check_per_all_people_f_fk;
10836:

Line 10857: FND_MSG_PUB.ADD;

10853: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
10854: FND_MESSAGE.SET_TOKEN( 'FK', 'collector_id' );
10855: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
10856: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ar_collectors');
10857: FND_MSG_PUB.ADD;
10858: x_return_status := FND_API.G_RET_STS_ERROR;
10859:
10860: END check_collector_fk;
10861:

Line 10882: FND_MSG_PUB.ADD;

10878: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
10879: FND_MESSAGE.SET_TOKEN( 'FK', 'party_id' );
10880: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
10881: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_parties' );
10882: FND_MSG_PUB.ADD;
10883: x_return_status := FND_API.G_RET_STS_ERROR;
10884:
10885: END check_party_fk;
10886:

Line 10907: FND_MSG_PUB.ADD;

10903: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
10904: FND_MESSAGE.SET_TOKEN( 'FK', 'party_site_id' );
10905: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
10906: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_party_sites' );
10907: FND_MSG_PUB.ADD;
10908: x_return_status := FND_API.G_RET_STS_ERROR;
10909: END;
10910:
10911: END check_party_site_fk;

Line 10937: FND_MSG_PUB.ADD;

10933: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
10934: FND_MESSAGE.SET_TOKEN( 'FK', 'currency_code' );
10935: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
10936: FND_MESSAGE.SET_TOKEN( 'TABLE', 'fnd_currencies' );
10937: FND_MSG_PUB.ADD;
10938: x_return_status := FND_API.G_RET_STS_ERROR;
10939:
10940: END check_currency_fk;
10941:

Line 10965: FND_MSG_PUB.ADD;

10961: IF l_org_id IS NOT NULL THEN
10962: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_COLUMN_SHOULD_BE_NULL' );
10963: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
10964: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_cust_accounts' );
10965: FND_MSG_PUB.ADD;
10966: x_return_status := FND_API.G_RET_STS_ERROR;
10967:
10968: RETURN;
10969: END IF;

Line 10975: FND_MSG_PUB.ADD;

10971: --Bug Fix 2183072 Handled the exception
10972: EXCEPTION
10973: WHEN NO_DATA_FOUND THEN
10974: FND_MESSAGE.SET_NAME( 'AR', 'AR_NO_ROW_IN_SYSTEM_PARAMETERS');
10975: FND_MSG_PUB.ADD;
10976: x_return_status := FND_API.G_RET_STS_ERROR;
10977: END ;
10978: END IF;
10979: **************************************************************************/

Line 11020: FND_MSG_PUB.ADD;

11016: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
11017: FND_MESSAGE.SET_TOKEN( 'FK', 'payment_term_id' );
11018: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
11019: FND_MESSAGE.SET_TOKEN( 'TABLE', 'RA_TERMS' );
11020: FND_MSG_PUB.ADD;
11021: x_return_status := FND_API.G_RET_STS_ERROR;
11022: END check_payterm_id_fk;
11023:
11024: PROCEDURE check_late_charge_term_id_fk (

Line 11051: FND_MSG_PUB.ADD;

11047: WHEN NO_DATA_FOUND THEN
11048: -- Balance forward billing has not been enabled.
11049: -- Pass a late charge payment term that does not have a balance forward billing cycle.
11050: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_LC_PAY_TERM_DISABLED' );
11051: FND_MSG_PUB.ADD;
11052: x_return_status := FND_API.G_RET_STS_ERROR;
11053: end;
11054: elsif p_cons_inv_flag = 'Y' then
11055: begin

Line 11069: FND_MSG_PUB.ADD;

11065: WHEN NO_DATA_FOUND THEN
11066: -- Balance forward billing has been enabled.
11067: -- Pass a late charge payment term that has a balance forward billing cycle.
11068: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_LC_PAY_TERM_ENABLED' );
11069: FND_MSG_PUB.ADD;
11070: x_return_status := FND_API.G_RET_STS_ERROR;
11071: end;
11072: end if;
11073:

Line 11098: FND_MSG_PUB.ADD;

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:
11102: PROCEDURE check_exchange_rate_type_fk (

Line 11124: FND_MSG_PUB.ADD;

11120: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
11121: FND_MESSAGE.SET_TOKEN( 'FK', 'conversion_type' );
11122: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
11123: FND_MESSAGE.SET_TOKEN( 'TABLE', 'gl_daily_conversion_types' );
11124: FND_MSG_PUB.ADD;
11125: x_return_status := FND_API.G_RET_STS_ERROR;
11126: END check_exchange_rate_type_fk;
11127:
11128: PROCEDURE check_charge_schedule_id_fk (

Line 11149: FND_MSG_PUB.ADD;

11145: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
11146: FND_MESSAGE.SET_TOKEN( 'FK', 'schedule_id' );
11147: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
11148: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ar_charge_schedules' );
11149: FND_MSG_PUB.ADD;
11150: x_return_status := FND_API.G_RET_STS_ERROR;
11151: END check_charge_schedule_id_fk;
11152:
11153: PROCEDURE check_finchrg_trx_fk (

Line 11172: FND_MSG_PUB.ADD;

11168: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
11169: FND_MESSAGE.SET_TOKEN( 'FK', 'finchrg_receivables_trx_id' );
11170: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
11171: FND_MESSAGE.SET_TOKEN( 'TABLE', 'AR_RECEIVABLES_TRX' );
11172: FND_MSG_PUB.ADD;
11173: x_return_status := FND_API.G_RET_STS_ERROR;
11174: END check_finchrg_trx_fk;
11175:
11176: PROCEDURE check_price_list_fk (

Line 11206: FND_MSG_PUB.ADD;

11202: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
11203: -- Bug 3591694 FND_MESSAGE.SET_TOKEN( 'TABLE', 'SO_PRICE_LISTS' );
11204: FND_MESSAGE.SET_TOKEN( 'TABLE', 'QP_LIST_HEADERS_B' );
11205:
11206: FND_MSG_PUB.ADD;
11207: x_return_status := FND_API.G_RET_STS_ERROR;
11208: END check_price_list_fk;
11209:
11210: PROCEDURE check_item_cross_ref(

Line 11226: FND_MSG_PUB.ADD;

11222: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
11223: FND_MESSAGE.SET_TOKEN( 'FK', 'item_cross_ref_pref' );
11224: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
11225: FND_MESSAGE.SET_TOKEN( 'TABLE', 'mtl_cross_reference_types' );
11226: FND_MSG_PUB.ADD;
11227: x_return_status := FND_API.G_RET_STS_ERROR;
11228: END check_item_cross_ref;
11229:
11230: PROCEDURE check_tax_code(

Line 11283: FND_MSG_PUB.ADD;

11279: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
11280: FND_MESSAGE.SET_TOKEN( 'FK', 'tax_code' );
11281: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
11282: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ZX_OUTPUT_CLASSIFICATIONS_V' );
11283: FND_MSG_PUB.ADD;
11284: x_return_status := FND_API.G_RET_STS_ERROR;
11285: END check_tax_code;
11286:
11287: PROCEDURE check_warehouse(

Line 11304: FND_MSG_PUB.ADD;

11300: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
11301: FND_MESSAGE.SET_TOKEN( 'FK', 'warehouse_id' );
11302: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
11303: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ORG_ORGANIZATION_DEFINITIONS' );
11304: FND_MSG_PUB.ADD;
11305: x_return_status := FND_API.G_RET_STS_ERROR;
11306: END check_warehouse;
11307:
11308: PROCEDURE check_prim_salesrep(

Line 11334: FND_MSG_PUB.ADD;

11330: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
11331: FND_MESSAGE.SET_TOKEN( 'FK', 'primary_salesrep_id' );
11332: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
11333: FND_MESSAGE.SET_TOKEN( 'TABLE', 'JTF_RS_SALESREPS' );
11334: FND_MSG_PUB.ADD;
11335: x_return_status := FND_API.G_RET_STS_ERROR;
11336: */
11337: x_return_status := FND_API.G_RET_STS_SUCCESS;
11338: END check_prim_salesrep;

Line 11373: FND_MSG_PUB.ADD;

11369: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
11370: FND_MESSAGE.SET_TOKEN( 'FK', 'order_type_id' );
11371: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
11372: FND_MESSAGE.SET_TOKEN( 'TABLE', 'OE_TRANSACTIONS_TYPES_VL' );
11373: FND_MSG_PUB.ADD;
11374: x_return_status := FND_API.G_RET_STS_ERROR;
11375: */
11376: x_return_status := FND_API.G_RET_STS_SUCCESS;
11377: END check_ord_type;

Line 11390: FND_MSG_PUB.ADD;

11386:
11387: IF p_column_value = FND_API.G_MISS_NUM THEN
11388: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
11389: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
11390: FND_MSG_PUB.ADD;
11391: x_return_status := FND_API.G_RET_STS_ERROR;
11392: END IF;
11393:
11394: END check_partial_mandatory_column;

Line 11407: FND_MSG_PUB.ADD;

11403:
11404: IF p_column_value = FND_API.G_MISS_CHAR THEN
11405: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
11406: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
11407: FND_MSG_PUB.ADD;
11408: x_return_status := FND_API.G_RET_STS_ERROR;
11409: END IF;
11410:
11411: END check_partial_mandatory_column;

Line 11435: FND_MSG_PUB.ADD;

11431: combination_id => p_column_value )
11432: THEN
11433: FND_MESSAGE.SET_NAME( 'AR', 'AR_AUTO_' ||
11434: UPPER( p_gl_name ) || '_CCID_INVALID' );
11435: FND_MSG_PUB.ADD;
11436: x_return_status := FND_API.G_RET_STS_ERROR;
11437: END IF;
11438: END IF;
11439:

Line 11463: FND_MSG_PUB.ADD;

11459: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
11460: FND_MESSAGE.SET_TOKEN( 'FK', p_column );
11461: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
11462: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ar_autocash_hierarchies');
11463: FND_MSG_PUB.ADD;
11464: x_return_status := FND_API.G_RET_STS_ERROR;
11465:
11466: END check_auto_hierid_fk;
11467:

Line 11488: FND_MSG_PUB.ADD;

11484: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
11485: FND_MESSAGE.SET_TOKEN( 'FK', 'statement_cycle_id' );
11486: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
11487: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ar_statement_cycles');
11488: FND_MSG_PUB.ADD;
11489: x_return_status := FND_API.G_RET_STS_ERROR;
11490:
11491: END check_stat_cycid_fk;
11492:

Line 11513: FND_MSG_PUB.ADD;

11509: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
11510: FND_MESSAGE.SET_TOKEN( 'FK', 'dunning_letter_set_id' );
11511: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
11512: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ar_dunning_letter_sets');
11513: FND_MSG_PUB.ADD;
11514: x_return_status := FND_API.G_RET_STS_ERROR;
11515:
11516: END check_dunning_letid_fk;
11517:

Line 11562: FND_MSG_PUB.ADD;

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;
11564: end;
11565: elsif p_cons_inv_flag = 'Y' then
11566: begin

Line 11580: FND_MSG_PUB.ADD;

11576: WHEN NO_DATA_FOUND THEN
11577: -- Balance forward billing has been enabled. Pass a payment term
11578: -- with a balance forward billing cycle associated.
11579: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_BAL_FWD_BILL_ENABLED' );
11580: FND_MSG_PUB.ADD;
11581: x_return_status := FND_API.G_RET_STS_ERROR;
11582: end;
11583: end if;
11584:

Line 11599: FND_MSG_PUB.ADD;

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;
11601: */
11602: END check_standard_terms_fk;
11603:

Line 11626: FND_MSG_PUB.ADD;

11622: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
11623: FND_MESSAGE.SET_TOKEN( 'FK', 'grouping_rule_id' );
11624: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
11625: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ra_grouping_rules');
11626: FND_MSG_PUB.ADD;
11627: x_return_status := FND_API.G_RET_STS_ERROR;
11628:
11629: END check_grouping_ruleid_fk;
11630:

Line 11641: FND_MSG_PUB.ADD;

11637: BEGIN
11638: IF p_column_value < 0 THEN
11639: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_LESS_THAN_ZERO' );
11640: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
11641: FND_MSG_PUB.ADD;
11642: x_return_status := FND_API.G_RET_STS_ERROR;
11643: END IF;
11644:
11645: END check_positive_value;

Line 11657: FND_MSG_PUB.ADD;

11653: BEGIN
11654: IF p_column_value <= 0 THEN
11655: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_GREATER_THAN_ZERO' );
11656: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
11657: FND_MSG_PUB.ADD;
11658: x_return_status := FND_API.G_RET_STS_ERROR;
11659: END IF;
11660:
11661: END check_greater_than_zero;

Line 11673: FND_MSG_PUB.ADD;

11669: BEGIN
11670: IF p_column_value > 100 THEN
11671: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_GREATER_THAN_100' );
11672: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
11673: FND_MSG_PUB.ADD;
11674: x_return_status := FND_API.G_RET_STS_ERROR;
11675: END IF;
11676:
11677: END check_less_than_100;

Line 12044: FND_MSG_PUB.ADD;

12040:
12041: IF l_error THEN
12042: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
12043: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
12044: FND_MSG_PUB.ADD;
12045: x_return_status := FND_API.G_RET_STS_ERROR;
12046: END IF;
12047:
12048: END validate_mandatory;

Line 12082: FND_MSG_PUB.ADD;

12078:
12079: IF l_error THEN
12080: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
12081: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
12082: FND_MSG_PUB.ADD;
12083: x_return_status := FND_API.G_RET_STS_ERROR;
12084: END IF;
12085:
12086: END validate_mandatory;

Line 12120: FND_MSG_PUB.ADD;

12116:
12117: IF l_error THEN
12118: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
12119: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
12120: FND_MSG_PUB.ADD;
12121: x_return_status := FND_API.G_RET_STS_ERROR;
12122: END IF;
12123:
12124: END validate_mandatory;

Line 12162: FND_MSG_PUB.ADD;

12158:
12159: IF l_error THEN
12160: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NONUPDATEABLE_COLUMN' );
12161: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
12162: FND_MSG_PUB.ADD;
12163: x_return_status := FND_API.G_RET_STS_ERROR;
12164: END IF;
12165:
12166: END validate_nonupdateable;

Line 12204: FND_MSG_PUB.ADD;

12200:
12201: IF l_error THEN
12202: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NONUPDATEABLE_COLUMN' );
12203: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
12204: FND_MSG_PUB.ADD;
12205: x_return_status := FND_API.G_RET_STS_ERROR;
12206: END IF;
12207:
12208: END validate_nonupdateable;

Line 12246: FND_MSG_PUB.ADD;

12242:
12243: IF l_error THEN
12244: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NONUPDATEABLE_COLUMN' );
12245: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
12246: FND_MSG_PUB.ADD;
12247: x_return_status := FND_API.G_RET_STS_ERROR;
12248: END IF;
12249:
12250: END validate_nonupdateable;

Line 12300: FND_MSG_PUB.ADD;

12296: THEN
12297: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_DATE_GREATER' );
12298: FND_MESSAGE.SET_TOKEN( 'DATE2', p_end_date_column_name );
12299: FND_MESSAGE.SET_TOKEN( 'DATE1', p_start_date_column_name );
12300: FND_MSG_PUB.ADD;
12301: x_return_status := FND_API.G_RET_STS_ERROR;
12302: END IF;
12303:
12304: END validate_start_end_date;

Line 12317: FND_MSG_PUB.ADD;

12313:
12314: IF p_column_value = FND_API.G_MISS_CHAR THEN
12315: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NONUPDATEABLE_TO_NULL' );
12316: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
12317: FND_MSG_PUB.ADD;
12318: x_return_status := FND_API.G_RET_STS_ERROR;
12319: END IF;
12320:
12321: END validate_cannot_update_to_null;

Line 12334: FND_MSG_PUB.ADD;

12330:
12331: IF p_column_value = FND_API.G_MISS_NUM THEN
12332: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NONUPDATEABLE_TO_NULL' );
12333: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
12334: FND_MSG_PUB.ADD;
12335: x_return_status := FND_API.G_RET_STS_ERROR;
12336: END IF;
12337:
12338: END validate_cannot_update_to_null;

Line 12351: FND_MSG_PUB.ADD;

12347:
12348: IF p_column_value = FND_API.G_MISS_DATE THEN
12349: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NONUPDATEABLE_TO_NULL' );
12350: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
12351: FND_MSG_PUB.ADD;
12352: x_return_status := FND_API.G_RET_STS_ERROR;
12353: END IF;
12354:
12355: END validate_cannot_update_to_null;

Line 12389: FND_MSG_PUB.ADD;

12385: IF l_error THEN
12386: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_LOOKUP' );
12387: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
12388: FND_MESSAGE.SET_TOKEN( 'LOOKUP_TYPE', p_lookup_type );
12389: FND_MSG_PUB.ADD;
12390: x_return_status := FND_API.G_RET_STS_ERROR;
12391: END IF;
12392: END IF;
12393:

Line 12580: FND_MSG_PUB.ADD;

12576: -- Bill Level and Type should have valid not null values
12577: if (p_customer_profile_rec.cons_bill_level IS NULL
12578: OR p_customer_profile_rec.cons_inv_type IS NULL) then
12579: FND_MESSAGE.SET_NAME('AR', 'HZ_API_BILL_LVL_TYPE_INVALID');
12580: FND_MSG_PUB.ADD;
12581: x_return_status := FND_API.G_RET_STS_ERROR;
12582: else
12583: if p_customer_profile_rec.cons_bill_level IS NOT NULL then
12584: SELECT COUNT(*)

Line 12594: FND_MSG_PUB.ADD;

12590: AND enabled_flag = 'Y';
12591:
12592: IF (l_bill_level_count = 0) THEN
12593: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_BILL_LEVEL');
12594: FND_MSG_PUB.ADD;
12595: x_return_status := FND_API.G_RET_STS_ERROR;
12596: END IF;
12597: end if;
12598: end if;

Line 12613: FND_MSG_PUB.ADD;

12609: AND lookup_code <> 'IMPORTED';
12610:
12611: IF (l_bill_TYPE_count = 0) THEN
12612: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ACCT_BILL_TYPE');
12613: FND_MSG_PUB.ADD;
12614: x_return_status := FND_API.G_RET_STS_ERROR;
12615: END IF;
12616: -- For Site use bill level, use Summary, Detail, or Imported as bill type.
12617: else

Line 12628: FND_MSG_PUB.ADD;

12624: AND enabled_flag = 'Y';
12625:
12626: IF (l_bill_TYPE_count = 0) THEN
12627: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ACCT_BILL_TYPE');
12628: FND_MSG_PUB.ADD;
12629: x_return_status := FND_API.G_RET_STS_ERROR;
12630: END IF;
12631: end if;
12632: end if;