APPS.HZ_PARTY_INFO_VAL dependencies on HZ_PARTIES

Line 303: -- foreign key : party_id to hz_parties

299: END;
300:
301: END IF;
302:
303: -- foreign key : party_id to hz_parties
304:
305: IF (p_credit_ratings_rec.party_id is NOT NULL AND
306: p_credit_ratings_rec.party_id <> FND_API.G_MISS_NUM) THEN
307:

Line 310: FROM hz_parties

306: p_credit_ratings_rec.party_id <> FND_API.G_MISS_NUM) THEN
307:
308: SELECT count(*)
309: INTO l_count
310: FROM hz_parties
311: WHERE party_id = p_credit_ratings_rec.party_id;
312:
313: IF l_count = 0 THEN
314: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');

Line 317: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_parties');

313: IF l_count = 0 THEN
314: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
315: FND_MESSAGE.SET_TOKEN('FK', 'party_id');
316: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_id');
317: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_parties');
318: FND_MSG_PUB.ADD;
319: x_return_status := FND_API.G_RET_STS_ERROR;
320: END IF;
321:

Line 1324: l_party_type HZ_PARTIES.PARTY_TYPE%TYPE;

1320: p_create_update_flag IN VARCHAR2,
1321: x_return_status IN OUT NOCOPY VARCHAR2
1322: ) IS
1323: l_party_id NUMBER;
1324: l_party_type HZ_PARTIES.PARTY_TYPE%TYPE;
1325:
1326: BEGIN
1327: -- mandatory fields: party_id
1328: IF (p_create_update_flag = 'C' AND

Line 1362: -- foreign key : party_id to hz_parties

1358: end if;
1359:
1360: END IF;
1361:
1362: -- foreign key : party_id to hz_parties
1363:
1364: IF (p_financial_profile_rec.party_id is NOT NULL AND
1365: p_financial_profile_rec.party_id <> FND_API.G_MISS_NUM) THEN
1366:

Line 1371: FROM hz_parties

1367: -- Bug 4461511.
1368: BEGIN
1369: SELECT party_type
1370: INTO l_party_type
1371: FROM hz_parties
1372: WHERE party_id = p_financial_profile_rec.party_id;
1373:
1374: IF p_create_update_flag = 'C'
1375: AND l_party_type <> 'PERSON'

Line 1390: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_parties');

1386: WHEN NO_DATA_FOUND THEN
1387: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
1388: FND_MESSAGE.SET_TOKEN('FK', 'party_id');
1389: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_id');
1390: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_parties');
1391: FND_MSG_PUB.ADD;
1392: x_return_status := FND_API.G_RET_STS_ERROR;
1393: END;
1394: END IF;