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_ORG_INFO_VALIDATE dependencies on HZ_PARTIES

Line 98: -- validate foreign key: party_id to hz_parties,

94: END;
95:
96: END IF;
97:
98: -- validate foreign key: party_id to hz_parties,
99: -- stock_exchange_id to hz_stock_markets,
100: -- security_currency_code to fnd_currencies.
101:
102:

Line 107: FROM hz_parties

103: IF p_security_issued_rec.party_id is NOT NULL AND
104: p_security_issued_rec.party_id <> FND_API.G_MISS_NUM THEN
105:
106: SELECT COUNT(*) INTO l_count
107: FROM hz_parties
108: where party_id = p_security_issued_rec.party_id;
109:
110: IF l_count = 0 THEN
111: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');

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

110: IF l_count = 0 THEN
111: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
112: FND_MESSAGE.SET_TOKEN('FK', 'party_id');
113: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_id');
114: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_parties');
115: FND_MSG_PUB.ADD;
116: x_return_status := FND_API.G_RET_STS_ERROR;
117:
118: END IF;

Line 277: -- foreign keys: party_id to HZ_PARTIES table

273: END;
274:
275: END IF;
276:
277: -- foreign keys: party_id to HZ_PARTIES table
278:
279: IF p_financial_reports_rec.party_id is NOT NULL AND
280: p_financial_reports_rec.party_id <> FND_API.G_MISS_NUM THEN
281:

Line 283: FROM hz_parties

279: IF p_financial_reports_rec.party_id is NOT NULL AND
280: p_financial_reports_rec.party_id <> FND_API.G_MISS_NUM THEN
281:
282: SELECT COUNT(*) INTO l_count
283: FROM hz_parties
284: where party_id = p_financial_reports_rec.party_id;
285:
286: IF l_count = 0 THEN
287: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');

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

286: IF l_count = 0 THEN
287: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
288: FND_MESSAGE.SET_TOKEN('FK', 'party_id');
289: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_id');
290: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_parties');
291: FND_MSG_PUB.ADD;
292: x_return_status := FND_API.G_RET_STS_ERROR;
293:
294: END IF;

Line 592: -- check foreign key : party_id to hz_parties.

588: end if;
589:
590: END IF;
591:
592: -- check foreign key : party_id to hz_parties.
593:
594: IF p_certifications_rec.party_id is NOT NULL AND
595: p_certifications_rec.party_id <> FND_API.G_MISS_NUM THEN
596:

Line 599: FROM HZ_PARTIES

595: p_certifications_rec.party_id <> FND_API.G_MISS_NUM THEN
596:
597: SELECT count(*)
598: INTO l_count
599: FROM HZ_PARTIES
600: WHERE party_id = p_certifications_rec.party_id;
601:
602: if l_count = 0 then
603: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');

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

602: if l_count = 0 then
603: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
604: FND_MESSAGE.SET_TOKEN('FK', 'party_id');
605: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_id');
606: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_parties');
607: FND_MSG_PUB.ADD;
608: x_return_status := FND_API.G_RET_STS_ERROR;
609:
610: END IF;

Line 674: -- check foreign key : party_id to hz_parties.

670:
671: end if;
672: END IF;
673:
674: -- check foreign key : party_id to hz_parties.
675:
676: IF p_industrial_reference_rec.party_id is NOT NULL AND
677: p_industrial_reference_rec.party_id <> FND_API.G_MISS_NUM THEN
678:

Line 681: FROM HZ_PARTIES

677: p_industrial_reference_rec.party_id <> FND_API.G_MISS_NUM THEN
678:
679: SELECT count(*)
680: INTO l_count
681: FROM HZ_PARTIES
682: WHERE party_id = p_industrial_reference_rec.party_id;
683:
684: if l_count = 0 then
685: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');

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

684: if l_count = 0 then
685: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
686: FND_MESSAGE.SET_TOKEN('FK', 'party_id');
687: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_id');
688: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_parties');
689: FND_MSG_PUB.ADD;
690: x_return_status := FND_API.G_RET_STS_ERROR;
691:
692: END IF;

Line 818: -- foreign keys: party_id to HZ_PARTIES table.

814: END IF;
815:
816:
817:
818: -- foreign keys: party_id to HZ_PARTIES table.
819: -- industrial_class_id to hz_industrial_class_app
820:
821: IF p_industrial_class_app_rec.party_id is NOT NULL AND
822: p_industrial_class_app_rec.party_id <> FND_API.G_MISS_NUM THEN

Line 825: FROM hz_parties

821: IF p_industrial_class_app_rec.party_id is NOT NULL AND
822: p_industrial_class_app_rec.party_id <> FND_API.G_MISS_NUM THEN
823:
824: SELECT COUNT(*) INTO l_count
825: FROM hz_parties
826: where party_id = p_industrial_class_app_rec.party_id;
827:
828: IF l_count = 0 THEN
829: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');

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

828: IF l_count = 0 THEN
829: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
830: FND_MESSAGE.SET_TOKEN('FK', 'party_id');
831: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_id');
832: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_parties');
833: FND_MSG_PUB.ADD;
834: x_return_status := FND_API.G_RET_STS_ERROR;
835:
836: END IF;