DBA Data[Home] [Help]

APPS.HZ_PAYMENT_METHOD_PUB dependencies on HZ_CUST_ACCOUNTS

Line 410: from HZ_CUST_ACCOUNTS

406: l_dummy VARCHAR2(1);
407:
408: CURSOR check_cust_acct_id(l_ca_id NUMBER) IS
409: select 'X'
410: from HZ_CUST_ACCOUNTS
411: where cust_account_id = l_ca_id;
412:
413: CURSOR check_site_use_id(l_ca_id NUMBER, l_casu_id NUMBER) IS
414: SELECT 'X'

Line 464: FND_MESSAGE.SET_TOKEN('TABLE','HZ_CUST_ACCOUNTS');

460: CLOSE check_cust_acct_id;
461: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
462: FND_MESSAGE.SET_TOKEN('FK','CUSTOMER_ID');
463: FND_MESSAGE.SET_TOKEN('COLUMN','CUST_ACCOUNT_ID');
464: FND_MESSAGE.SET_TOKEN('TABLE','HZ_CUST_ACCOUNTS');
465: FND_MSG_PUB.ADD;
466: RAISE FND_API.G_EXC_ERROR;
467: END IF;
468: CLOSE check_cust_acct_id;