523: SELECT 'Y' INTO l_dummy
524: FROM HZ_CUST_ACCOUNTS
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
524: FROM HZ_CUST_ACCOUNTS
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
602: IF l_profile = 'Y' THEN
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:
627: THEN
628: IF p_cust_account_rec.account_number IS NULL OR
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;
628: IF p_cust_account_rec.account_number IS NULL OR
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:
714:
715: IF p_create_update_flag = 'C' OR
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;
715: IF p_create_update_flag = 'C' OR
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
775: SELECT 'Y' INTO l_dummy
776: FROM HZ_CUST_ACCOUNTS
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
776: FROM HZ_CUST_ACCOUNTS
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
1137: /*
1138: IF p_cust_account_rec.tax_code IS NOT NULL AND
1139: p_cust_account_rec.tax_code <> FND_API.G_MISS_CHAR
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;
1138: IF p_cust_account_rec.tax_code IS NOT NULL AND
1139: p_cust_account_rec.tax_code <> FND_API.G_MISS_CHAR
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;
1139: p_cust_account_rec.tax_code <> FND_API.G_MISS_CHAR
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: */
1179:
1180: IF p_cust_account_rec.order_type_id IS NOT NULL AND
1181: p_cust_account_rec.order_type_id <> FND_API.G_MISS_NUM
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;
1180: IF p_cust_account_rec.order_type_id IS NOT NULL AND
1181: p_cust_account_rec.order_type_id <> FND_API.G_MISS_NUM
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;
1181: p_cust_account_rec.order_type_id <> FND_API.G_MISS_NUM
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:
1235:
1236: IF p_cust_account_rec.primary_salesrep_id IS NOT NULL AND
1237: p_cust_account_rec.primary_salesrep_id <> FND_API.G_MISS_NUM
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;
1236: IF p_cust_account_rec.primary_salesrep_id IS NOT NULL AND
1237: p_cust_account_rec.primary_salesrep_id <> FND_API.G_MISS_NUM
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;
1237: p_cust_account_rec.primary_salesrep_id <> FND_API.G_MISS_NUM
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:
1889: INTO l_dummy
1890: FROM DUAL;
1891: IF l_dummy <> 'Y'
1892: THEN
1893: FND_MESSAGE.SET_NAME('AR','HZ_API_VAL_DEP_FIELDS');
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');
1890: FROM DUAL;
1891: IF l_dummy <> 'Y'
1892: THEN
1893: FND_MESSAGE.SET_NAME('AR','HZ_API_VAL_DEP_FIELDS');
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;
1891: IF l_dummy <> 'Y'
1892: THEN
1893: FND_MESSAGE.SET_NAME('AR','HZ_API_VAL_DEP_FIELDS');
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;
1892: THEN
1893: FND_MESSAGE.SET_NAME('AR','HZ_API_VAL_DEP_FIELDS');
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;
1893: FND_MESSAGE.SET_NAME('AR','HZ_API_VAL_DEP_FIELDS');
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 ;
1978: INTO l_dummy
1979: FROM DUAL;
1980: IF l_dummy <> 'Y'
1981: THEN
1982: FND_MESSAGE.SET_NAME('AR','HZ_API_VAL_DEP_FIELDS');
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');
1979: FROM DUAL;
1980: IF l_dummy <> 'Y'
1981: THEN
1982: FND_MESSAGE.SET_NAME('AR','HZ_API_VAL_DEP_FIELDS');
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;
1980: IF l_dummy <> 'Y'
1981: THEN
1982: FND_MESSAGE.SET_NAME('AR','HZ_API_VAL_DEP_FIELDS');
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;
1981: THEN
1982: FND_MESSAGE.SET_NAME('AR','HZ_API_VAL_DEP_FIELDS');
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;
1982: FND_MESSAGE.SET_NAME('AR','HZ_API_VAL_DEP_FIELDS');
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 ;
2491: --Bug 2985448
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
2880: SELECT 'Y' INTO l_dummy
2881: FROM HZ_CUSTOMER_PROFILES
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
2881: FROM HZ_CUSTOMER_PROFILES
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
3048: WHERE CUST_ACCOUNT_ID = p_customer_profile_rec.cust_account_id
3049: AND SITE_USE_ID IS NULL
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
3049: AND SITE_USE_ID IS NULL
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
3080: FROM HZ_CUSTOMER_PROFILES
3081: WHERE PARTY_ID = p_customer_profile_rec.party_id
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
3081: WHERE PARTY_ID = p_customer_profile_rec.party_id
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
3333: IF p_customer_profile_rec.profile_class_id IS NOT NULL AND
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
3343: FROM HZ_CUST_PROFILE_CLASSES
3344: WHERE PROFILE_CLASS_ID = p_customer_profile_rec.profile_class_id;
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;
3344: WHERE PROFILE_CLASS_ID = p_customer_profile_rec.profile_class_id;
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
3350: x_return_status := FND_API.G_RET_STS_ERROR;
3351: END IF;
3352: EXCEPTION
3353: WHEN NO_DATA_FOUND THEN
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;
3351: END IF;
3352: EXCEPTION
3353: WHEN NO_DATA_FOUND THEN
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;
3352: EXCEPTION
3353: WHEN NO_DATA_FOUND THEN
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;
3353: WHEN NO_DATA_FOUND THEN
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;
3458: FROM HZ_CUST_ACCT_SITES_ALL
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:
3472: END IF;
3473:
3474: EXCEPTION
3475: WHEN NO_DATA_FOUND THEN
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;
3473:
3474: EXCEPTION
3475: WHEN NO_DATA_FOUND THEN
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;
3474: EXCEPTION
3475: WHEN NO_DATA_FOUND THEN
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;
3475: WHEN NO_DATA_FOUND THEN
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:
3495: WHERE CUST_ACCOUNT_ID = p_customer_profile_rec.cust_account_id
3496: AND SITE_USE_ID = p_customer_profile_rec.site_use_id
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
3496: AND SITE_USE_ID = p_customer_profile_rec.site_use_id
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
3519: p_customer_profile_rec.site_use_id IS NOT NULL AND
3520: p_customer_profile_rec.site_use_id <> FND_API.G_MISS_NUM AND
3521: p_customer_profile_rec.cust_account_id = -1
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;
3520: p_customer_profile_rec.site_use_id <> FND_API.G_MISS_NUM AND
3521: p_customer_profile_rec.cust_account_id = -1
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:
3521: p_customer_profile_rec.cust_account_id = -1
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:
4168: THEN
4169: IF p_customer_profile_rec.tolerance > 100 OR
4170: p_customer_profile_rec.tolerance < -100
4171: THEN
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;
4169: IF p_customer_profile_rec.tolerance > 100 OR
4170: p_customer_profile_rec.tolerance < -100
4171: THEN
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;
4170: p_customer_profile_rec.tolerance < -100
4171: THEN
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
4171: THEN
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 .' ||
4204: THEN
4205: IF p_customer_profile_rec.percent_collectable > 100 OR
4206: p_customer_profile_rec.percent_collectable < 0
4207: THEN
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;
4205: IF p_customer_profile_rec.percent_collectable > 100 OR
4206: p_customer_profile_rec.percent_collectable < 0
4207: THEN
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;
4206: p_customer_profile_rec.percent_collectable < 0
4207: THEN
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:
4207: THEN
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
4505: p_msg_level=>fnd_log.level_statement);
4506: END IF; */
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;
4506: END IF; */
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:
4730: THEN
4731: IF v_customer_profile_rec.discount_grace_days >= 0 AND
4732: v_customer_profile_rec.discount_grace_days <> FND_API.G_MISS_NUM
4733: THEN
4734: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_VAL_DEP_FIELDS' );
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' );
4731: IF v_customer_profile_rec.discount_grace_days >= 0 AND
4732: v_customer_profile_rec.discount_grace_days <> FND_API.G_MISS_NUM
4733: THEN
4734: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_VAL_DEP_FIELDS' );
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;
4732: v_customer_profile_rec.discount_grace_days <> FND_API.G_MISS_NUM
4733: THEN
4734: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_VAL_DEP_FIELDS' );
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;
4733: THEN
4734: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_VAL_DEP_FIELDS' );
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:
4734: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_VAL_DEP_FIELDS' );
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
4798: THEN
4799: IF v_customer_profile_rec.dunning_letter_set_id = FND_API.G_MISS_NUM OR
4800: v_customer_profile_rec.dunning_letter_set_id IS NULL
4801: THEN
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;
4799: IF v_customer_profile_rec.dunning_letter_set_id = FND_API.G_MISS_NUM OR
4800: v_customer_profile_rec.dunning_letter_set_id IS NULL
4801: THEN
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;
4800: v_customer_profile_rec.dunning_letter_set_id IS NULL
4801: THEN
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:
4801: THEN
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
4821: THEN
4822: IF v_customer_profile_rec.dunning_letter_set_id >= 0 AND
4823: v_customer_profile_rec.dunning_letter_set_id <> FND_API.G_MISS_NUM
4824: THEN
4825: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_VAL_DEP_FIELDS' );
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');
4822: IF v_customer_profile_rec.dunning_letter_set_id >= 0 AND
4823: v_customer_profile_rec.dunning_letter_set_id <> FND_API.G_MISS_NUM
4824: THEN
4825: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_VAL_DEP_FIELDS' );
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;
4823: v_customer_profile_rec.dunning_letter_set_id <> FND_API.G_MISS_NUM
4824: THEN
4825: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_VAL_DEP_FIELDS' );
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;
4824: THEN
4825: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_VAL_DEP_FIELDS' );
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:
4825: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_VAL_DEP_FIELDS' );
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
4899: IF v_customer_profile_rec.send_statements = 'Y' THEN
4900: IF v_customer_profile_rec.statement_cycle_id = FND_API.G_MISS_NUM OR
4901: v_customer_profile_rec.statement_cycle_id IS NULL
4902: THEN
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;
4900: IF v_customer_profile_rec.statement_cycle_id = FND_API.G_MISS_NUM OR
4901: v_customer_profile_rec.statement_cycle_id IS NULL
4902: THEN
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;
4901: v_customer_profile_rec.statement_cycle_id IS NULL
4902: THEN
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:
4902: THEN
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
4915: END IF;
4916:
4917: END IF;
4918: IF v_customer_profile_rec.credit_balance_statements IS NULL THEN
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;
4916:
4917: END IF;
4918: IF v_customer_profile_rec.credit_balance_statements IS NULL THEN
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;
4917: END IF;
4918: IF v_customer_profile_rec.credit_balance_statements IS NULL THEN
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:
4918: IF v_customer_profile_rec.credit_balance_statements IS NULL THEN
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
4939: THEN
4940: IF v_customer_profile_rec.statement_cycle_id >= 0 AND
4941: v_customer_profile_rec.statement_cycle_id <> FND_API.G_MISS_NUM
4942: THEN
4943: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_VAL_DEP_FIELDS' );
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');
4940: IF v_customer_profile_rec.statement_cycle_id >= 0 AND
4941: v_customer_profile_rec.statement_cycle_id <> FND_API.G_MISS_NUM
4942: THEN
4943: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_VAL_DEP_FIELDS' );
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;
4941: v_customer_profile_rec.statement_cycle_id <> FND_API.G_MISS_NUM
4942: THEN
4943: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_VAL_DEP_FIELDS' );
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;
4942: THEN
4943: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_VAL_DEP_FIELDS' );
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:
4943: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_VAL_DEP_FIELDS' );
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
4958: END IF;
4959: IF v_customer_profile_rec.credit_balance_statements <> 'N' AND
4960: v_customer_profile_rec.credit_balance_statements IS NOT NULL
4961: THEN
4962: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_VAL_DEP_FIELDS' );
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');
4959: IF v_customer_profile_rec.credit_balance_statements <> 'N' AND
4960: v_customer_profile_rec.credit_balance_statements IS NOT NULL
4961: THEN
4962: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_VAL_DEP_FIELDS' );
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;
4960: v_customer_profile_rec.credit_balance_statements IS NOT NULL
4961: THEN
4962: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_VAL_DEP_FIELDS' );
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;
4961: THEN
4962: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_VAL_DEP_FIELDS' );
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:
4962: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_VAL_DEP_FIELDS' );
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
5048: ('LATE', 'OVERDUE_LATE', 'OVERDUE') THEN
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,
5084: THEN
5085: IF v_customer_profile_rec.interest_period_days >= 0 AND
5086: v_customer_profile_rec.interest_period_days <> FND_API.G_MISS_NUM
5087: THEN
5088: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_VAL_DEP_FIELDS' );
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');
5085: IF v_customer_profile_rec.interest_period_days >= 0 AND
5086: v_customer_profile_rec.interest_period_days <> FND_API.G_MISS_NUM
5087: THEN
5088: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_VAL_DEP_FIELDS' );
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;
5086: v_customer_profile_rec.interest_period_days <> FND_API.G_MISS_NUM
5087: THEN
5088: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_VAL_DEP_FIELDS' );
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;
5087: THEN
5088: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_VAL_DEP_FIELDS' );
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:
5088: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_VAL_DEP_FIELDS' );
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
5102:
5103: END IF;
5104: IF v_customer_profile_rec.charge_on_finance_charge_flag = 'Y'
5105: THEN
5106: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_VAL_DEP_FIELDS' );
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');
5103: END IF;
5104: IF v_customer_profile_rec.charge_on_finance_charge_flag = 'Y'
5105: THEN
5106: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_VAL_DEP_FIELDS' );
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;
5104: IF v_customer_profile_rec.charge_on_finance_charge_flag = 'Y'
5105: THEN
5106: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_VAL_DEP_FIELDS' );
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;
5105: THEN
5106: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_VAL_DEP_FIELDS' );
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:
5106: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_VAL_DEP_FIELDS' );
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
5413: ((p_customer_profile_rec.late_charge_type = 'ADJ') AND
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:
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
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:
5632: SELECT 'Y' INTO l_dummy
5633: FROM HZ_CUST_PROFILE_AMTS
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
5633: FROM HZ_CUST_PROFILE_AMTS
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
5728: WHERE CUST_ACCOUNT_PROFILE_ID = p_cust_profile_amt_rec.cust_account_profile_id;
5729:
5730: EXCEPTION
5731: WHEN NO_DATA_FOUND THEN
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;
5729:
5730: EXCEPTION
5731: WHEN NO_DATA_FOUND THEN
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;
5730: EXCEPTION
5731: WHEN NO_DATA_FOUND THEN
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;
5731: WHEN NO_DATA_FOUND THEN
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:
5826:
5827: -- cross reference checking
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;
5827: -- cross reference checking
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:
5925: WHERE CUST_ACCOUNT_PROFILE_ID = p_cust_profile_amt_rec.cust_account_profile_id
5926: AND CURRENCY_CODE = p_cust_profile_amt_rec.currency_code
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
5926: AND CURRENCY_CODE = p_cust_profile_amt_rec.currency_code
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
6005: ( ( p_cust_profile_amt_rec.site_use_id IS NULL OR
6006: p_cust_profile_amt_rec.site_use_id = FND_API.G_MISS_NUM ) AND
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;
6006: p_cust_profile_amt_rec.site_use_id = FND_API.G_MISS_NUM ) AND
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:
6081: )
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
6322:
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
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
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 (
6348: END IF;
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;
6403:
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
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
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 (
6429: END IF;
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;
6492: IF v_cust_profile_amt_rec.interest_type = 'FIXED_RATE' THEN
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 (
6512: ELSIF v_cust_profile_amt_rec.interest_type = 'FIXED_AMOUNT' THEN
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
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 (
6541: ELSE
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;
6604: IF v_cust_profile_amt_rec.penalty_type = 'FIXED_RATE' THEN
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 (
6624: ELSIF v_cust_profile_amt_rec.penalty_type = 'FIXED_AMOUNT' THEN
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
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 (
6653: ELSE
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;
6774: SELECT 'Y' INTO l_dummy
6775: FROM HZ_CUST_ACCT_SITES_ALL -- Bug 3456489
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
6775: FROM HZ_CUST_ACCT_SITES_ALL -- Bug 3456489
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
6967: AND CONTENT_SOURCE_TYPE = HZ_PARTY_V2PUB.G_MISS_CONTENT_SOURCE_TYPE;
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:
6992: AND PARTY_SITE_ID = p_cust_acct_site_rec.party_site_id
6993: AND ORG_ID = p_cust_acct_site_rec.org_id -- Bug 3456489
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
6993: AND ORG_ID = p_cust_acct_site_rec.org_id -- Bug 3456489
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
7041: FROM HZ_CUST_ACCT_SITES_ALL
7042: WHERE ORIG_SYSTEM_REFERENCE = p_cust_acct_site_rec.orig_system_reference
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
7042: WHERE ORIG_SYSTEM_REFERENCE = p_cust_acct_site_rec.orig_system_reference
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
7147:
7148: IF p_create_update_flag = 'C' OR
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;
7148: IF p_create_update_flag = 'C' OR
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
7275: AND INSTALLED_FLAG IN ('B', 'I')
7276: AND ROWNUM = 1;
7277: EXCEPTION
7278: WHEN NO_DATA_FOUND THEN
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;
7276: AND ROWNUM = 1;
7277: EXCEPTION
7278: WHEN NO_DATA_FOUND THEN
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;
7277: EXCEPTION
7278: WHEN NO_DATA_FOUND THEN
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;
7278: WHEN NO_DATA_FOUND THEN
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:
7399: and addr.ece_tp_location_code = p_cust_acct_site_rec.ece_tp_location_code
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;
7418: and addr.cust_acct_site_id <> p_cust_acct_site_rec.cust_acct_site_id
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;
7599: SELECT 'Y' INTO l_dummy
7600: FROM HZ_CUST_SITE_USES_ALL
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
7600: FROM HZ_CUST_SITE_USES_ALL
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
7857: AND su.org_id = p_cust_site_use_rec.org_id -- Bug 3456489
7858: AND ROWNUM = 1;
7859:
7860: IF l_site_use_code = 'DUN' THEN
7861: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_ONE_ACTIVE_DUN_SITE' );
7862: ELSIF l_site_use_code = 'LEGAL' THEN
7863: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_ONE_ACTIVE_LEGAL_SITE' );
7864: ELSIF l_site_use_code = 'STMTS' THEN
7865: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_ONE_ACTIVE_STMTS_SITE' );
7859:
7860: IF l_site_use_code = 'DUN' THEN
7861: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_ONE_ACTIVE_DUN_SITE' );
7862: ELSIF l_site_use_code = 'LEGAL' THEN
7863: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_ONE_ACTIVE_LEGAL_SITE' );
7864: ELSIF l_site_use_code = 'STMTS' THEN
7865: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_ONE_ACTIVE_STMTS_SITE' );
7866: END IF;
7867:
7861: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_ONE_ACTIVE_DUN_SITE' );
7862: ELSIF l_site_use_code = 'LEGAL' THEN
7863: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_ONE_ACTIVE_LEGAL_SITE' );
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;
7894: AND STATUS = 'A'
7895: AND ORG_ID = p_cust_site_use_rec.org_id -- Bug 3456489
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
7895: AND ORG_ID = p_cust_site_use_rec.org_id -- Bug 3456489
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
7945: IF p_cust_site_use_rec.location IS NULL OR
7946: p_cust_site_use_rec.location = FND_API.G_MISS_CHAR
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;
7946: p_cust_site_use_rec.location = FND_API.G_MISS_CHAR
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:
8001: AND su.org_id = p_cust_site_use_rec.org_id -- Bug 3456489
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
8079: WHERE RELATED_CUST_ACCOUNT_ID = l_cust_account_id
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:
8092: p_msg_level=>fnd_log.level_statement);
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;
8118: AND hsu.status = 'A'
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
8302: AND ( p_create_update_flag = 'C' OR
8303: (p_create_update_flag = 'U' AND su.ROWID <> p_rowid ))
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:
8303: (p_create_update_flag = 'U' AND su.ROWID <> p_rowid ))
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
8356: END IF;
8357: END IF;
8358:
8359: IF l_error THEN
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;
8357: END IF;
8358:
8359: IF l_error THEN
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;
8358:
8359: IF l_error THEN
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.
8359: IF l_error THEN
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;
8457: INTO l_dummy
8458: FROM DUAL;
8459: IF l_dummy <> 'Y'
8460: THEN
8461: FND_MESSAGE.SET_NAME('AR','HZ_API_VAL_DEP_FIELDS');
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');
8458: FROM DUAL;
8459: IF l_dummy <> 'Y'
8460: THEN
8461: FND_MESSAGE.SET_NAME('AR','HZ_API_VAL_DEP_FIELDS');
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;
8459: IF l_dummy <> 'Y'
8460: THEN
8461: FND_MESSAGE.SET_NAME('AR','HZ_API_VAL_DEP_FIELDS');
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;
8460: THEN
8461: FND_MESSAGE.SET_NAME('AR','HZ_API_VAL_DEP_FIELDS');
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;
8461: FND_MESSAGE.SET_NAME('AR','HZ_API_VAL_DEP_FIELDS');
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 ;
8526: INTO l_dummy
8527: FROM DUAL;
8528: IF l_dummy <> 'Y'
8529: THEN
8530: FND_MESSAGE.SET_NAME('AR','HZ_API_VAL_DEP_FIELDS');
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');
8527: FROM DUAL;
8528: IF l_dummy <> 'Y'
8529: THEN
8530: FND_MESSAGE.SET_NAME('AR','HZ_API_VAL_DEP_FIELDS');
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;
8528: IF l_dummy <> 'Y'
8529: THEN
8530: FND_MESSAGE.SET_NAME('AR','HZ_API_VAL_DEP_FIELDS');
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;
8529: THEN
8530: FND_MESSAGE.SET_NAME('AR','HZ_API_VAL_DEP_FIELDS');
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;
8530: FND_MESSAGE.SET_NAME('AR','HZ_API_VAL_DEP_FIELDS');
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 ;
9043: p_cust_site_use_rec.gl_id_unbilled <> FND_API.G_MISS_NUM ) OR
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:
9071: p_cust_site_use_rec.gl_id_remittance <> FND_API.G_MISS_NUM ) OR
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:
9094: THEN
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:
9529: SELECT 'Y' INTO l_dummy
9530: FROM HZ_CUST_ACCOUNT_ROLES
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
9530: FROM HZ_CUST_ACCOUNT_ROLES
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
9762: x_return_status := FND_API.G_RET_STS_ERROR;
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:
9769: END IF;
9770:
9771: EXCEPTION
9772: WHEN NO_DATA_FOUND THEN
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;
9770:
9771: EXCEPTION
9772: WHEN NO_DATA_FOUND THEN
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;
9771: EXCEPTION
9772: WHEN NO_DATA_FOUND THEN
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;
9772: WHEN NO_DATA_FOUND THEN
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:
9879: AND ROLE_TYPE = p_cust_account_role_rec.role_type
9880: AND STATUS='A' -- Bug 4624292
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
9880: AND STATUS='A' -- Bug 4624292
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
9905: AND ROLE_TYPE = p_cust_account_role_rec.role_type
9906: AND STATUS='A' -- Bug 4624292
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
9906: AND STATUS='A' -- Bug 4624292
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
9940: AND STATUS='A'
9941: AND ROWID<>p_rowid
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
9941: AND ROWID<>p_rowid
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
9969: AND STATUS='A'
9970: AND ROWID<>p_rowid
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
9970: AND ROWID<>p_rowid
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
10103: AND ( p_create_update_flag = 'C' OR
10104: p_create_update_flag = 'U' AND ROWID <> p_rowid )
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
10104: p_create_update_flag = 'U' AND ROWID <> p_rowid )
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
10130: AND ( p_create_update_flag = 'C' OR
10131: p_create_update_flag = 'U' AND ROWID <> p_rowid )
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
10131: p_create_update_flag = 'U' AND ROWID <> p_rowid )
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
10333: SELECT 'Y' INTO l_dummy
10334: FROM HZ_ROLE_RESPONSIBILITY
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
10334: FROM HZ_ROLE_RESPONSIBILITY
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
10504: AND ( p_create_update_flag = 'C' OR
10505: ( p_create_update_flag = 'U' AND ROWID <> p_rowid ) )
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
10505: ( p_create_update_flag = 'U' AND ROWID <> p_rowid ) )
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
10601: AND ( p_create_update_flag = 'C' OR
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
10682: END IF;
10683:
10684: EXCEPTION
10685: WHEN NO_DATA_FOUND THEN
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;
10683:
10684: EXCEPTION
10685: WHEN NO_DATA_FOUND THEN
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;
10684: EXCEPTION
10685: WHEN NO_DATA_FOUND THEN
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:
10685: WHEN NO_DATA_FOUND THEN
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;
10709: AND ORG_ID = p_org_id; -- Bug 3456489
10710:
10711: EXCEPTION
10712: WHEN NO_DATA_FOUND THEN
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;
10710:
10711: EXCEPTION
10712: WHEN NO_DATA_FOUND THEN
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;
10711: EXCEPTION
10712: WHEN NO_DATA_FOUND THEN
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:
10712: WHEN NO_DATA_FOUND THEN
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;
10743: END;
10744:
10745: EXCEPTION
10746: WHEN NO_DATA_FOUND THEN
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;
10744:
10745: EXCEPTION
10746: WHEN NO_DATA_FOUND THEN
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;
10745: EXCEPTION
10746: WHEN NO_DATA_FOUND THEN
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:
10746: WHEN NO_DATA_FOUND THEN
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;
10767: AND CUST_ACCOUNT_ID = p_customer_id;
10768:
10769: EXCEPTION
10770: WHEN NO_DATA_FOUND THEN
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;
10768:
10769: EXCEPTION
10770: WHEN NO_DATA_FOUND THEN
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;
10769: EXCEPTION
10770: WHEN NO_DATA_FOUND THEN
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:
10770: WHEN NO_DATA_FOUND THEN
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;
10791: WHERE CUST_ACCOUNT_ROLE_ID = p_column_value;
10792:
10793: EXCEPTION
10794: WHEN NO_DATA_FOUND THEN
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;
10792:
10793: EXCEPTION
10794: WHEN NO_DATA_FOUND THEN
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;
10793: EXCEPTION
10794: WHEN NO_DATA_FOUND THEN
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:
10794: WHEN NO_DATA_FOUND THEN
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;
10824: AND ROWNUM = 1;
10825:
10826: EXCEPTION
10827: WHEN NO_DATA_FOUND THEN
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;
10825:
10826: EXCEPTION
10827: WHEN NO_DATA_FOUND THEN
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;
10826: EXCEPTION
10827: WHEN NO_DATA_FOUND THEN
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:
10827: WHEN NO_DATA_FOUND THEN
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;
10849: WHERE COLLECTOR_ID = p_column_value;
10850:
10851: EXCEPTION
10852: WHEN NO_DATA_FOUND THEN
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;
10850:
10851: EXCEPTION
10852: WHEN NO_DATA_FOUND THEN
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;
10851: EXCEPTION
10852: WHEN NO_DATA_FOUND THEN
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:
10852: WHEN NO_DATA_FOUND THEN
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;
10874: WHERE PARTY_ID = p_column_value;
10875:
10876: EXCEPTION
10877: WHEN NO_DATA_FOUND THEN
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;
10875:
10876: EXCEPTION
10877: WHEN NO_DATA_FOUND THEN
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;
10876: EXCEPTION
10877: WHEN NO_DATA_FOUND THEN
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:
10877: WHEN NO_DATA_FOUND THEN
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;
10899: FROM HZ_PARTY_SITES
10900: WHERE PARTY_SITE_ID = p_column_value;
10901: EXCEPTION
10902: WHEN NO_DATA_FOUND THEN
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;
10900: WHERE PARTY_SITE_ID = p_column_value;
10901: EXCEPTION
10902: WHEN NO_DATA_FOUND THEN
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;
10901: EXCEPTION
10902: WHEN NO_DATA_FOUND THEN
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;
10902: WHEN NO_DATA_FOUND THEN
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:
10929: AND TRUNC(NVL(END_DATE_ACTIVE,SYSDATE));
10930:
10931: EXCEPTION
10932: WHEN NO_DATA_FOUND THEN
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;
10930:
10931: EXCEPTION
10932: WHEN NO_DATA_FOUND THEN
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;
10931: EXCEPTION
10932: WHEN NO_DATA_FOUND THEN
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:
10932: WHEN NO_DATA_FOUND THEN
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;
10958: SELECT MIN(ORG_ID) INTO l_org_id
10959: FROM AR_SYSTEM_PARAMETERS;
10960:
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;
10959: FROM AR_SYSTEM_PARAMETERS;
10960:
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:
10960:
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;
10970:
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;
11012: AND trunc(sysdate) between START_DATE_ACTIVE and nvl(END_DATE_ACTIVE,trunc(sysdate));
11013: */
11014: EXCEPTION
11015: WHEN NO_DATA_FOUND THEN
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;
11013: */
11014: EXCEPTION
11015: WHEN NO_DATA_FOUND THEN
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;
11014: EXCEPTION
11015: WHEN NO_DATA_FOUND THEN
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;
11015: WHEN NO_DATA_FOUND THEN
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:
11046: EXCEPTION
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
11064: EXCEPTION
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;
11090: and trunc(sysdate) between
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;
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;
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;
11100: END check_message_text_id_fk;
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:
11116: and conversion_type = p_column_value;
11117:
11118: EXCEPTION
11119: WHEN NO_DATA_FOUND THEN
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;
11117:
11118: EXCEPTION
11119: WHEN NO_DATA_FOUND THEN
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;
11118: EXCEPTION
11119: WHEN NO_DATA_FOUND THEN
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;
11119: WHEN NO_DATA_FOUND THEN
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:
11141: where schedule_id = p_column_value;
11142:
11143: EXCEPTION
11144: WHEN NO_DATA_FOUND THEN
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;
11142:
11143: EXCEPTION
11144: WHEN NO_DATA_FOUND THEN
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;
11143: EXCEPTION
11144: WHEN NO_DATA_FOUND THEN
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;
11144: WHEN NO_DATA_FOUND THEN
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:
11164: AND status = 'A'
11165: AND art.org_id = p_org_id; -- Bug 3456489
11166: EXCEPTION
11167: WHEN NO_DATA_FOUND THEN
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;
11165: AND art.org_id = p_org_id; -- Bug 3456489
11166: EXCEPTION
11167: WHEN NO_DATA_FOUND THEN
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;
11166: EXCEPTION
11167: WHEN NO_DATA_FOUND THEN
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;
11167: WHEN NO_DATA_FOUND THEN
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:
11196: AND (sysdate between nvl(lh.start_date_active,sysdate) and nvl(lh.end_date_active,sysdate)
11197: AND nvl(active_flag, 'N') = 'Y');
11198: EXCEPTION
11199: WHEN NO_DATA_FOUND THEN
11200: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
11201: FND_MESSAGE.SET_TOKEN( 'FK', 'price_list_id' );
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' );
11197: AND nvl(active_flag, 'N') = 'Y');
11198: EXCEPTION
11199: WHEN NO_DATA_FOUND THEN
11200: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
11201: FND_MESSAGE.SET_TOKEN( 'FK', 'price_list_id' );
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:
11198: EXCEPTION
11199: WHEN NO_DATA_FOUND THEN
11200: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
11201: FND_MESSAGE.SET_TOKEN( 'FK', 'price_list_id' );
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;
11199: WHEN NO_DATA_FOUND THEN
11200: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
11201: FND_MESSAGE.SET_TOKEN( 'FK', 'price_list_id' );
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;
11200: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
11201: FND_MESSAGE.SET_TOKEN( 'FK', 'price_list_id' );
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;
11218: FROM MTL_CROSS_REFERENCE_TYPES mtl
11219: WHERE mtl.cross_reference_type = p_column_value;
11220: EXCEPTION
11221: WHEN NO_DATA_FOUND THEN
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;
11219: WHERE mtl.cross_reference_type = p_column_value;
11220: EXCEPTION
11221: WHEN NO_DATA_FOUND THEN
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;
11220: EXCEPTION
11221: WHEN NO_DATA_FOUND THEN
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;
11221: WHEN NO_DATA_FOUND THEN
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:
11275: AND avt.org_id = p_org_id;
11276: */
11277: EXCEPTION
11278: WHEN NO_DATA_FOUND THEN
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;
11276: */
11277: EXCEPTION
11278: WHEN NO_DATA_FOUND THEN
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;
11277: EXCEPTION
11278: WHEN NO_DATA_FOUND THEN
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;
11278: WHEN NO_DATA_FOUND THEN
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:
11296: WHERE org.organization_id = p_column_value
11297: AND trunc(sysdate) <= nvl(trunc(org.disable_date),trunc(sysdate));
11298: EXCEPTION
11299: WHEN NO_DATA_FOUND THEN
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;
11297: AND trunc(sysdate) <= nvl(trunc(org.disable_date),trunc(sysdate));
11298: EXCEPTION
11299: WHEN NO_DATA_FOUND THEN
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;
11298: EXCEPTION
11299: WHEN NO_DATA_FOUND THEN
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;
11299: WHEN NO_DATA_FOUND THEN
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:
11326: AND nvl(status, 'A') = 'A'
11327: AND salesrep_id NOT IN( -1,-2);
11328: EXCEPTION
11329: WHEN NO_DATA_FOUND THEN
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;
11327: AND salesrep_id NOT IN( -1,-2);
11328: EXCEPTION
11329: WHEN NO_DATA_FOUND THEN
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;
11328: EXCEPTION
11329: WHEN NO_DATA_FOUND THEN
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: */
11329: WHEN NO_DATA_FOUND THEN
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;
11365: and nvl(ot.end_date_active,sysdate);
11366:
11367: EXCEPTION
11368: WHEN NO_DATA_FOUND THEN
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;
11366:
11367: EXCEPTION
11368: WHEN NO_DATA_FOUND THEN
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;
11367: EXCEPTION
11368: WHEN NO_DATA_FOUND THEN
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: */
11368: WHEN NO_DATA_FOUND THEN
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;
11384:
11385: BEGIN
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;
11385: BEGIN
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:
11401:
11402: BEGIN
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;
11402: BEGIN
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:
11429: -- structure_number => ARP_GLOBAL.chart_of_accounts_id,
11430: structure_number => p_coa_id,
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;
11455: AND h.autocash_hierarchy_id =
11456: p_column_value;
11457: EXCEPTION
11458: WHEN NO_DATA_FOUND THEN
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;
11456: p_column_value;
11457: EXCEPTION
11458: WHEN NO_DATA_FOUND THEN
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;
11457: EXCEPTION
11458: WHEN NO_DATA_FOUND THEN
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:
11458: WHEN NO_DATA_FOUND THEN
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;
11480: AND sc.statement_cycle_id =
11481: p_column_value;
11482: EXCEPTION
11483: WHEN NO_DATA_FOUND THEN
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;
11481: p_column_value;
11482: EXCEPTION
11483: WHEN NO_DATA_FOUND THEN
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;
11482: EXCEPTION
11483: WHEN NO_DATA_FOUND THEN
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:
11483: WHEN NO_DATA_FOUND THEN
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;
11505: AND dls.dunning_letter_set_id =
11506: p_column_value;
11507: EXCEPTION
11508: WHEN NO_DATA_FOUND THEN
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;
11506: p_column_value;
11507: EXCEPTION
11508: WHEN NO_DATA_FOUND THEN
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;
11507: EXCEPTION
11508: WHEN NO_DATA_FOUND THEN
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:
11508: WHEN NO_DATA_FOUND THEN
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;
11547: Now we will look for any valid term_id if BFB is not enabled.
11548: -- If Balance Forward Billing is enabled for the site but disabled for the
11549: -- account. Pass a payment term without a balance forward billing cycle associated.
11550: if p_ckeck_acc_bfb_enabled = 'Y' then
11551: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_ACCT_BAL_FWD_DISABLED' );
11552: -- Balance forward billing has not been enabled.
11553: -- Pass a payment term without a balance forward billing cycle associated.
11554: else
11555: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_BAL_FWD_BILL_DISABLED' );
11551: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_ACCT_BAL_FWD_DISABLED' );
11552: -- Balance forward billing has not been enabled.
11553: -- Pass a payment term without a balance forward billing cycle associated.
11554: else
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' );
11554: else
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;
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;
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;
11564: end;
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;
11564: end;
11565: elsif p_cons_inv_flag = 'Y' then
11575: EXCEPTION
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;
11591: AND t.term_id =
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;
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;
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;
11601: */
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;
11601: */
11602: END check_standard_terms_fk;
11618: AND gr.grouping_rule_id =
11619: p_column_value;
11620: EXCEPTION
11621: WHEN NO_DATA_FOUND THEN
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;
11619: p_column_value;
11620: EXCEPTION
11621: WHEN NO_DATA_FOUND THEN
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;
11620: EXCEPTION
11621: WHEN NO_DATA_FOUND THEN
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:
11621: WHEN NO_DATA_FOUND THEN
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;
11635: ) IS
11636:
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;
11636:
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:
11651: ) IS
11652:
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;
11652:
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:
11667: ) IS
11668:
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;
11668:
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:
12038: END IF;
12039: END IF;
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;
12039: END IF;
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:
12076: END IF;
12077: END IF;
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;
12077: END IF;
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:
12114: END IF;
12115: END IF;
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;
12115: END IF;
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:
12156: END IF;
12157: END IF;
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;
12157: END IF;
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:
12198: END IF;
12199: END IF;
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;
12199: END IF;
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:
12240: END IF;
12241: END IF;
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;
12241: END IF;
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:
12293: ( l_start_date IS NULL OR
12294: l_start_date = FND_API.G_MISS_DATE OR
12295: l_start_date > l_end_date )
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;
12294: l_start_date = FND_API.G_MISS_DATE OR
12295: l_start_date > l_end_date )
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;
12295: l_start_date > l_end_date )
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:
12311:
12312: BEGIN
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;
12312: BEGIN
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:
12328:
12329: BEGIN
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;
12329: BEGIN
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:
12345:
12346: BEGIN
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;
12346: BEGIN
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:
12382: END IF;
12383: END IF;
12384:
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;
12383: END IF;
12384:
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;
12384:
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;
12575: -- If Balance Forward billing is enabled,
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
12589: AND TRUNC(SYSDATE) BETWEEN NVL(start_date_active,SYSDATE) AND NVL(end_date_active, SYSDATE+1)
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;
12608: AND enabled_flag = 'Y'
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.
12623: AND TRUNC(SYSDATE) BETWEEN NVL(start_date_active,SYSDATE) AND NVL(end_date_active, SYSDATE+1)
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;