eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_ACCOUNT_VALIDATE_V2PUB dependencies on FV_TP_TREASURY_SYMBOLS

Line 13078: -- Verify FK value from FV_TP_TREASURY_SYMBOLS table

13074: THEN
13075: FND_MESSAGE.SET_NAME('AR', 'HZ_TPAI_IS_NULL');
13076: FND_MSG_PUB.ADD;
13077: x_return_status := FND_API.G_RET_STS_ERROR;
13078: -- Verify FK value from FV_TP_TREASURY_SYMBOLS table
13079: ELSIF p_cust_account_rec.trading_partner_agency_id IS NOT NULL AND p_cust_account_rec.trading_partner_agency_id <> FND_API.G_MISS_CHAR THEN
13080: BEGIN
13081: SELECT 'Y'
13082: into l_temp

Line 13083: FROM fv_tp_treasury_symbols

13079: ELSIF p_cust_account_rec.trading_partner_agency_id IS NOT NULL AND p_cust_account_rec.trading_partner_agency_id <> FND_API.G_MISS_CHAR THEN
13080: BEGIN
13081: SELECT 'Y'
13082: into l_temp
13083: FROM fv_tp_treasury_symbols
13084: WHERE agency_id = p_cust_account_rec.trading_partner_agency_id
13085: AND ROWNUM = 1;
13086:
13087: EXCEPTION

Line 13092: FND_MESSAGE.SET_TOKEN( 'TABLE', 'FV_TP_TREASURY_SYMBOLS');

13088: WHEN NO_DATA_FOUND THEN
13089: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
13090: FND_MESSAGE.SET_TOKEN( 'FK', 'Trading Partner Agency Id' );
13091: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'agency_id' );
13092: FND_MESSAGE.SET_TOKEN( 'TABLE', 'FV_TP_TREASURY_SYMBOLS');
13093: FND_MSG_PUB.ADD;
13094: x_return_status := FND_API.G_RET_STS_ERROR;
13095: END;
13096: