1207: BEGIN
1208:
1209: ----------------------------- DEBUG INFORMATION ------------------------------
1210: IF PG_DEBUG = 'Y' THEN
1211: arp_util_tax.debug('ar_business_rules: ' || 'Check ar business rules');
1212: END IF;
1213: ------------------------------------------------------------------------------
1214:
1215: ------------------------------------------------------------------------------
1345: p_current_record_status := l_current_record_status;
1346: EXCEPTION
1347: WHEN OTHERS THEN
1348: IF PG_DEBUG = 'Y' THEN
1349: arp_util_tax.debug('Exception in JL_INTERFACE_VAL.AR_BUSINESS_RULES()');
1350: arp_util_tax.debug('ar_business_rules: ' || SQLERRM);
1351: ELSE
1352: NULL;
1353: END IF;
1346: EXCEPTION
1347: WHEN OTHERS THEN
1348: IF PG_DEBUG = 'Y' THEN
1349: arp_util_tax.debug('Exception in JL_INTERFACE_VAL.AR_BUSINESS_RULES()');
1350: arp_util_tax.debug('ar_business_rules: ' || SQLERRM);
1351: ELSE
1352: NULL;
1353: END IF;
1354: END ar_business_rules;
1374: l_current_record_status := 'S';
1375: PG_DEBUG := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
1376: ----------------------------- DEBUG INFORMATION ------------------------------
1377: IF PG_DEBUG = 'Y' THEN
1378: arp_util_tax.debug('ar_business_rules: ' || 'Check ar business rules');
1379: END IF;
1380: ------------------------------------------------------------------------------
1381:
1382: -- Call to validate the address gdfs
1462:
1463: EXCEPTION
1464: WHEN OTHERS THEN
1465: IF PG_DEBUG = 'Y' THEN
1466: arp_util_tax.debug('Exception in JL_INTERFACE_VAL.AR_BUSINESS_RULES()');
1467: arp_util_tax.debug('ar_business_rules: ' || SQLERRM);
1468: ELSE
1469: NULL;
1470: END IF;
1463: EXCEPTION
1464: WHEN OTHERS THEN
1465: IF PG_DEBUG = 'Y' THEN
1466: arp_util_tax.debug('Exception in JL_INTERFACE_VAL.AR_BUSINESS_RULES()');
1467: arp_util_tax.debug('ar_business_rules: ' || SQLERRM);
1468: ELSE
1469: NULL;
1470: END IF;
1471: END ar_business_rules;
2085:
2086: EXCEPTION
2087: WHEN NO_DATA_FOUND THEN
2088: IF PG_DEBUG = 'Y' THEN
2089: arp_util_tax.debug('jl_zz_taxid_customers: ' || 'No data found in hz_cust_accounts table for Update');
2090: ELSE
2091: NULL;
2092: END IF;
2093: WHEN OTHERS THEN
2091: NULL;
2092: END IF;
2093: WHEN OTHERS THEN
2094: IF PG_DEBUG = 'Y' THEN
2095: arp_util_tax.debug('Exception in JL_INTERFACE_VAL.JL_ZZ_TAXID_CUSTOMERS()');
2096: arp_util_tax.debug('jl_zz_taxid_customers: ' || SQLERRM);
2097: ELSE
2098: NULL;
2099: END IF;
2092: END IF;
2093: WHEN OTHERS THEN
2094: IF PG_DEBUG = 'Y' THEN
2095: arp_util_tax.debug('Exception in JL_INTERFACE_VAL.JL_ZZ_TAXID_CUSTOMERS()');
2096: arp_util_tax.debug('jl_zz_taxid_customers: ' || SQLERRM);
2097: ELSE
2098: NULL;
2099: END IF;
2100: END;
2318:
2319: IF p_taxid_record_status IS NULL THEN
2320:
2321: IF PG_DEBUG = 'Y' THEN
2322: arp_util_tax.debug('jl_zz_taxid_customers: ' || 'In if record status is null p_taxid_record_status: '||p_taxid_record_status);
2323: END IF;
2324: p_taxid_record_status:='S';
2325:
2326: END IF;