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_PARTY_SITE_V2PUB dependencies on FND_MESSAGE

Line 252: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');

248: INTO l_dummy
249: FROM HZ_PARTY_SITES
250: WHERE PARTY_SITE_ID = l_party_site_id;
251:
252: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
253: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_site_id');
254: FND_MSG_PUB.ADD;
255: RAISE FND_API.G_EXC_ERROR;
256:

Line 253: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_site_id');

249: FROM HZ_PARTY_SITES
250: WHERE PARTY_SITE_ID = l_party_site_id;
251:
252: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
253: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_site_id');
254: FND_MSG_PUB.ADD;
255: RAISE FND_API.G_EXC_ERROR;
256:
257: EXCEPTION

Line 275: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');

271: IF l_party_site_number = FND_API.G_MISS_CHAR
272: OR
273: l_party_site_number IS NULL
274: THEN
275: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
276: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_site_number');
277: FND_MSG_PUB.ADD;
278: RAISE FND_API.G_EXC_ERROR;
279: END IF;

Line 276: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_site_number');

272: OR
273: l_party_site_number IS NULL
274: THEN
275: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
276: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_site_number');
277: FND_MSG_PUB.ADD;
278: RAISE FND_API.G_EXC_ERROR;
279: END IF;
280:

Line 287: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');

283: INTO l_dummy
284: FROM HZ_PARTY_SITES
285: WHERE PARTY_SITE_NUMBER = l_party_site_number;
286:
287: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
288: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_site_number');
289: FND_MSG_PUB.ADD;
290: RAISE FND_API.G_EXC_ERROR;
291:

Line 288: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_site_number');

284: FROM HZ_PARTY_SITES
285: WHERE PARTY_SITE_NUMBER = l_party_site_number;
286:
287: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
288: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_site_number');
289: FND_MSG_PUB.ADD;
290: RAISE FND_API.G_EXC_ERROR;
291:
292: EXCEPTION

Line 306: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PARTY_SITE_NUM_AUTO_ON');

302: IF l_party_site_number <> FND_API.G_MISS_CHAR
303: AND
304: l_party_site_number IS NOT NULL
305: THEN
306: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PARTY_SITE_NUM_AUTO_ON');
307: FND_MSG_PUB.ADD;
308: RAISE FND_API.G_EXC_ERROR;
309: END IF;
310:

Line 695: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');

691: p_object_version_number = l_object_version_number
692: )
693: )
694: THEN
695: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
696: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_party_sites');
697: FND_MSG_PUB.ADD;
698: RAISE FND_API.G_EXC_ERROR;
699: END IF;

Line 696: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_party_sites');

692: )
693: )
694: THEN
695: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
696: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_party_sites');
697: FND_MSG_PUB.ADD;
698: RAISE FND_API.G_EXC_ERROR;
699: END IF;
700:

Line 704: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');

700:
701: p_object_version_number := nvl(l_object_version_number, 1) + 1;
702:
703: EXCEPTION WHEN NO_DATA_FOUND THEN
704: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
705: FND_MESSAGE.SET_TOKEN('RECORD', 'party site');
706: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_party_site_rec.party_site_id), 'null'));
707: FND_MSG_PUB.ADD;
708: RAISE FND_API.G_EXC_ERROR;

Line 705: FND_MESSAGE.SET_TOKEN('RECORD', 'party site');

701: p_object_version_number := nvl(l_object_version_number, 1) + 1;
702:
703: EXCEPTION WHEN NO_DATA_FOUND THEN
704: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
705: FND_MESSAGE.SET_TOKEN('RECORD', 'party site');
706: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_party_site_rec.party_site_id), 'null'));
707: FND_MSG_PUB.ADD;
708: RAISE FND_API.G_EXC_ERROR;
709: END;

Line 706: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_party_site_rec.party_site_id), 'null'));

702:
703: EXCEPTION WHEN NO_DATA_FOUND THEN
704: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
705: FND_MESSAGE.SET_TOKEN('RECORD', 'party site');
706: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_party_site_rec.party_site_id), 'null'));
707: FND_MSG_PUB.ADD;
708: RAISE FND_API.G_EXC_ERROR;
709: END;
710:

Line 937: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');

933: AND application_id = 222
934: AND rownum =1;
935: EXCEPTION
936: WHEN NO_DATA_FOUND THEN
937: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
938: FND_MESSAGE.SET_TOKEN('RECORD', 'Message Name');
939: --FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_party_site_use_rec.party_site_id), 'null'));
940: FND_MSG_PUB.ADD;
941: RAISE FND_API.G_EXC_ERROR;

Line 938: FND_MESSAGE.SET_TOKEN('RECORD', 'Message Name');

934: AND rownum =1;
935: EXCEPTION
936: WHEN NO_DATA_FOUND THEN
937: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
938: FND_MESSAGE.SET_TOKEN('RECORD', 'Message Name');
939: --FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_party_site_use_rec.party_site_id), 'null'));
940: FND_MSG_PUB.ADD;
941: RAISE FND_API.G_EXC_ERROR;
942: END;

Line 939: --FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_party_site_use_rec.party_site_id), 'null'));

935: EXCEPTION
936: WHEN NO_DATA_FOUND THEN
937: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
938: FND_MESSAGE.SET_TOKEN('RECORD', 'Message Name');
939: --FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_party_site_use_rec.party_site_id), 'null'));
940: FND_MSG_PUB.ADD;
941: RAISE FND_API.G_EXC_ERROR;
942: END;
943: END IF;

Line 1033: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');

1029: INTO l_dummy
1030: FROM HZ_PARTY_SITE_USES
1031: WHERE PARTY_SITE_USE_ID = l_party_site_use_id;
1032:
1033: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
1034: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_site_use_id');
1035: FND_MSG_PUB.ADD;
1036: RAISE FND_API.G_EXC_ERROR;
1037:

Line 1034: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_site_use_id');

1030: FROM HZ_PARTY_SITE_USES
1031: WHERE PARTY_SITE_USE_ID = l_party_site_use_id;
1032:
1033: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
1034: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_site_use_id');
1035: FND_MSG_PUB.ADD;
1036: RAISE FND_API.G_EXC_ERROR;
1037:
1038: EXCEPTION

Line 1217: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');

1213: p_object_version_number = l_object_version_number
1214: )
1215: )
1216: THEN
1217: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1218: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_PARTY_SITE_USES');
1219: FND_MSG_PUB.ADD;
1220: RAISE FND_API.G_EXC_ERROR;
1221: END IF;

Line 1218: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_PARTY_SITE_USES');

1214: )
1215: )
1216: THEN
1217: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1218: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_PARTY_SITE_USES');
1219: FND_MSG_PUB.ADD;
1220: RAISE FND_API.G_EXC_ERROR;
1221: END IF;
1222:

Line 1226: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');

1222:
1223: p_object_version_number := nvl(l_object_version_number, 1) + 1;
1224:
1225: EXCEPTION WHEN NO_DATA_FOUND THEN
1226: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
1227: FND_MESSAGE.SET_TOKEN('RECORD', 'party site use');
1228: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_party_site_use_rec.party_site_use_id), 'null'));
1229: FND_MSG_PUB.ADD;
1230: RAISE FND_API.G_EXC_ERROR;

Line 1227: FND_MESSAGE.SET_TOKEN('RECORD', 'party site use');

1223: p_object_version_number := nvl(l_object_version_number, 1) + 1;
1224:
1225: EXCEPTION WHEN NO_DATA_FOUND THEN
1226: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
1227: FND_MESSAGE.SET_TOKEN('RECORD', 'party site use');
1228: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_party_site_use_rec.party_site_use_id), 'null'));
1229: FND_MSG_PUB.ADD;
1230: RAISE FND_API.G_EXC_ERROR;
1231: END;

Line 1228: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_party_site_use_rec.party_site_use_id), 'null'));

1224:
1225: EXCEPTION WHEN NO_DATA_FOUND THEN
1226: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
1227: FND_MESSAGE.SET_TOKEN('RECORD', 'party site use');
1228: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_party_site_use_rec.party_site_use_id), 'null'));
1229: FND_MSG_PUB.ADD;
1230: RAISE FND_API.G_EXC_ERROR;
1231: END;
1232:

Line 1312: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');

1308: END IF;
1309:
1310: EXCEPTION
1311: WHEN NO_DATA_FOUND THEN
1312: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
1313: FND_MESSAGE.SET_TOKEN('FK', 'party site id');
1314: FND_MESSAGE.SET_TOKEN('COLUMN', 'party site id');
1315: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_party_sites');
1316: FND_MSG_PUB.ADD;

Line 1313: FND_MESSAGE.SET_TOKEN('FK', 'party site id');

1309:
1310: EXCEPTION
1311: WHEN NO_DATA_FOUND THEN
1312: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
1313: FND_MESSAGE.SET_TOKEN('FK', 'party site id');
1314: FND_MESSAGE.SET_TOKEN('COLUMN', 'party site id');
1315: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_party_sites');
1316: FND_MSG_PUB.ADD;
1317: RAISE FND_API.G_EXC_ERROR;

Line 1314: FND_MESSAGE.SET_TOKEN('COLUMN', 'party site id');

1310: EXCEPTION
1311: WHEN NO_DATA_FOUND THEN
1312: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
1313: FND_MESSAGE.SET_TOKEN('FK', 'party site id');
1314: FND_MESSAGE.SET_TOKEN('COLUMN', 'party site id');
1315: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_party_sites');
1316: FND_MSG_PUB.ADD;
1317: RAISE FND_API.G_EXC_ERROR;
1318: END;

Line 1315: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_party_sites');

1311: WHEN NO_DATA_FOUND THEN
1312: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
1313: FND_MESSAGE.SET_TOKEN('FK', 'party site id');
1314: FND_MESSAGE.SET_TOKEN('COLUMN', 'party site id');
1315: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_party_sites');
1316: FND_MSG_PUB.ADD;
1317: RAISE FND_API.G_EXC_ERROR;
1318: END;
1319:

Line 1425: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');

1421: FETCH c_party INTO l_exists;
1422: CLOSE c_party;
1423: EXCEPTION
1424: WHEN OTHERS THEN
1425: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1426: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_PARTIES');
1427: FND_MSG_PUB.ADD;
1428: RAISE FND_API.G_EXC_ERROR;
1429: END;

Line 1426: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_PARTIES');

1422: CLOSE c_party;
1423: EXCEPTION
1424: WHEN OTHERS THEN
1425: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1426: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_PARTIES');
1427: FND_MSG_PUB.ADD;
1428: RAISE FND_API.G_EXC_ERROR;
1429: END;
1430:

Line 1547: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');

1543: FETCH c_party_sites INTO l_rowid, l_party_site_id;
1544: CLOSE c_party_sites;
1545: EXCEPTION
1546: WHEN OTHERS THEN
1547: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1548: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_PARTY_SITES');
1549: FND_MSG_PUB.ADD;
1550: RAISE FND_API.G_EXC_ERROR;
1551: END;

Line 1548: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_PARTY_SITES');

1544: CLOSE c_party_sites;
1545: EXCEPTION
1546: WHEN OTHERS THEN
1547: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1548: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_PARTY_SITES');
1549: FND_MSG_PUB.ADD;
1550: RAISE FND_API.G_EXC_ERROR;
1551: END;
1552:

Line 1643: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');

1639: FETCH c_party_site_uses INTO l_rowid, l_party_site_use_id;
1640: CLOSE c_party_site_uses;
1641: EXCEPTION
1642: WHEN OTHERS THEN
1643: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1644: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_PARTY_SITE_USES');
1645: FND_MSG_PUB.ADD;
1646: RAISE FND_API.G_EXC_ERROR;
1647: END;

Line 1644: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_PARTY_SITE_USES');

1640: CLOSE c_party_site_uses;
1641: EXCEPTION
1642: WHEN OTHERS THEN
1643: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1644: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_PARTY_SITE_USES');
1645: FND_MSG_PUB.ADD;
1646: RAISE FND_API.G_EXC_ERROR;
1647: END;
1648:

Line 1813: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_INSERT_PRIVILEGE');

1809: if (l_test_security <> 'T' OR l_test_security <> FND_API.G_TRUE) then
1810: --
1811: -- Bug 3835601: replaced the dss message with a more user friendly message
1812: --
1813: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_INSERT_PRIVILEGE');
1814: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
1815: fnd_message.get_string('AR', 'HZ_DSS_PARTY_ADDRESSES'));
1816: FND_MSG_PUB.ADD;
1817: RAISE FND_API.G_EXC_ERROR;

Line 1814: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',

1810: --
1811: -- Bug 3835601: replaced the dss message with a more user friendly message
1812: --
1813: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_INSERT_PRIVILEGE');
1814: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
1815: fnd_message.get_string('AR', 'HZ_DSS_PARTY_ADDRESSES'));
1816: FND_MSG_PUB.ADD;
1817: RAISE FND_API.G_EXC_ERROR;
1818: end if;

Line 1815: fnd_message.get_string('AR', 'HZ_DSS_PARTY_ADDRESSES'));

1811: -- Bug 3835601: replaced the dss message with a more user friendly message
1812: --
1813: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_INSERT_PRIVILEGE');
1814: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
1815: fnd_message.get_string('AR', 'HZ_DSS_PARTY_ADDRESSES'));
1816: FND_MSG_PUB.ADD;
1817: RAISE FND_API.G_EXC_ERROR;
1818: end if;
1819: END IF;

Line 1925: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

1921:
1922: WHEN OTHERS THEN
1923: ROLLBACK TO create_party_site;
1924: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1925: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1926: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1927: FND_MSG_PUB.ADD;
1928: FND_MSG_PUB.Count_And_Get(
1929: p_encoded => FND_API.G_FALSE,

Line 1926: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

1922: WHEN OTHERS THEN
1923: ROLLBACK TO create_party_site;
1924: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1925: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1926: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1927: FND_MSG_PUB.ADD;
1928: FND_MSG_PUB.Count_And_Get(
1929: p_encoded => FND_API.G_FALSE,
1930: p_count => x_msg_count,

Line 2082: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_UPDATE_PRIVILEGE');

2078: if (l_test_security <> 'T' OR l_test_security <> FND_API.G_TRUE) then
2079: --
2080: -- Bug 3835601: replaced the dss message with a more user friendly message
2081: --
2082: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_UPDATE_PRIVILEGE');
2083: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
2084: fnd_message.get_string('AR', 'HZ_DSS_PARTY_ADDRESSES'));
2085: FND_MSG_PUB.ADD;
2086: RAISE FND_API.G_EXC_ERROR;

Line 2083: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',

2079: --
2080: -- Bug 3835601: replaced the dss message with a more user friendly message
2081: --
2082: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_UPDATE_PRIVILEGE');
2083: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
2084: fnd_message.get_string('AR', 'HZ_DSS_PARTY_ADDRESSES'));
2085: FND_MSG_PUB.ADD;
2086: RAISE FND_API.G_EXC_ERROR;
2087: end if;

Line 2084: fnd_message.get_string('AR', 'HZ_DSS_PARTY_ADDRESSES'));

2080: -- Bug 3835601: replaced the dss message with a more user friendly message
2081: --
2082: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_UPDATE_PRIVILEGE');
2083: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
2084: fnd_message.get_string('AR', 'HZ_DSS_PARTY_ADDRESSES'));
2085: FND_MSG_PUB.ADD;
2086: RAISE FND_API.G_EXC_ERROR;
2087: end if;
2088: END IF;

Line 2171: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');

2167: AND application_id = 222
2168: AND rownum =1;
2169: EXCEPTION
2170: WHEN NO_DATA_FOUND THEN
2171: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
2172: FND_MESSAGE.SET_TOKEN('RECORD', 'Message Name');
2173: --FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_party_site_use_rec.party_site_id), 'null'));
2174: FND_MSG_PUB.ADD;
2175: RAISE FND_API.G_EXC_ERROR;

Line 2172: FND_MESSAGE.SET_TOKEN('RECORD', 'Message Name');

2168: AND rownum =1;
2169: EXCEPTION
2170: WHEN NO_DATA_FOUND THEN
2171: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
2172: FND_MESSAGE.SET_TOKEN('RECORD', 'Message Name');
2173: --FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_party_site_use_rec.party_site_id), 'null'));
2174: FND_MSG_PUB.ADD;
2175: RAISE FND_API.G_EXC_ERROR;
2176: END;

Line 2173: --FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_party_site_use_rec.party_site_id), 'null'));

2169: EXCEPTION
2170: WHEN NO_DATA_FOUND THEN
2171: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
2172: FND_MESSAGE.SET_TOKEN('RECORD', 'Message Name');
2173: --FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_party_site_use_rec.party_site_id), 'null'));
2174: FND_MSG_PUB.ADD;
2175: RAISE FND_API.G_EXC_ERROR;
2176: END;
2177: END IF;

Line 2267: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

2263:
2264: WHEN OTHERS THEN
2265: ROLLBACK TO update_party_site;
2266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2267: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2268: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2269: FND_MSG_PUB.ADD;
2270: FND_MSG_PUB.Count_And_Get(
2271: p_encoded => FND_API.G_FALSE,

Line 2268: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

2264: WHEN OTHERS THEN
2265: ROLLBACK TO update_party_site;
2266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2267: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2268: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2269: FND_MSG_PUB.ADD;
2270: FND_MSG_PUB.Count_And_Get(
2271: p_encoded => FND_API.G_FALSE,
2272: p_count => x_msg_count,

Line 2457: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

2453:
2454: WHEN OTHERS THEN
2455: ROLLBACK TO create_party_site_use;
2456: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2457: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2458: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2459: FND_MSG_PUB.ADD;
2460: FND_MSG_PUB.Count_And_Get(
2461: p_encoded => FND_API.G_FALSE,

Line 2458: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

2454: WHEN OTHERS THEN
2455: ROLLBACK TO create_party_site_use;
2456: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2457: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2458: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2459: FND_MSG_PUB.ADD;
2460: FND_MSG_PUB.Count_And_Get(
2461: p_encoded => FND_API.G_FALSE,
2462: p_count => x_msg_count,

Line 2659: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

2655:
2656: WHEN OTHERS THEN
2657: ROLLBACK TO update_party_site_use;
2658: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2659: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2660: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2661: FND_MSG_PUB.ADD;
2662: FND_MSG_PUB.Count_And_Get(
2663: p_encoded => FND_API.G_FALSE,

Line 2660: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

2656: WHEN OTHERS THEN
2657: ROLLBACK TO update_party_site_use;
2658: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2659: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2660: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2661: FND_MSG_PUB.ADD;
2662: FND_MSG_PUB.Count_And_Get(
2663: p_encoded => FND_API.G_FALSE,
2664: p_count => x_msg_count,

Line 2742: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );

2738:
2739: --Check whether primary key has been passed in.
2740: IF p_party_site_id IS NULL OR
2741: p_party_site_id = FND_API.G_MISS_NUM THEN
2742: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
2743: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'party_site_id' );
2744: FND_MSG_PUB.ADD;
2745: RAISE FND_API.G_EXC_ERROR;
2746: END IF;

Line 2743: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'party_site_id' );

2739: --Check whether primary key has been passed in.
2740: IF p_party_site_id IS NULL OR
2741: p_party_site_id = FND_API.G_MISS_NUM THEN
2742: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
2743: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'party_site_id' );
2744: FND_MSG_PUB.ADD;
2745: RAISE FND_API.G_EXC_ERROR;
2746: END IF;
2747:

Line 2815: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );

2811: p_data => x_msg_data );
2812:
2813: WHEN OTHERS THEN
2814: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2815: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2816: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2817: FND_MSG_PUB.ADD;
2818: FND_MSG_PUB.Count_And_Get(
2819: p_encoded => FND_API.G_FALSE,

Line 2816: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );

2812:
2813: WHEN OTHERS THEN
2814: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2815: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2816: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2817: FND_MSG_PUB.ADD;
2818: FND_MSG_PUB.Count_And_Get(
2819: p_encoded => FND_API.G_FALSE,
2820: p_count => x_msg_count,

Line 2880: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );

2876:
2877: --Check whether primary key has been passed in.
2878: IF p_party_site_use_id IS NULL OR
2879: p_party_site_use_id = FND_API.G_MISS_NUM THEN
2880: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
2881: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'p_party_site_use_id' );
2882: FND_MSG_PUB.ADD;
2883: RAISE FND_API.G_EXC_ERROR;
2884: END IF;

Line 2881: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'p_party_site_use_id' );

2877: --Check whether primary key has been passed in.
2878: IF p_party_site_use_id IS NULL OR
2879: p_party_site_use_id = FND_API.G_MISS_NUM THEN
2880: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
2881: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'p_party_site_use_id' );
2882: FND_MSG_PUB.ADD;
2883: RAISE FND_API.G_EXC_ERROR;
2884: END IF;
2885:

Line 2924: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );

2920: p_data => x_msg_data );
2921:
2922: WHEN OTHERS THEN
2923: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2924: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2925: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2926: FND_MSG_PUB.ADD;
2927: FND_MSG_PUB.Count_And_Get(
2928: p_encoded => FND_API.G_FALSE,

Line 2925: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );

2921:
2922: WHEN OTHERS THEN
2923: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2924: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2925: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2926: FND_MSG_PUB.ADD;
2927: FND_MSG_PUB.Count_And_Get(
2928: p_encoded => FND_API.G_FALSE,
2929: p_count => x_msg_count,

Line 3002: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');

2998: WHERE PARTY_SITE_ID = p_party_site_id;
2999:
3000: EXCEPTION WHEN NO_DATA_FOUND THEN
3001: x_return_status := FND_API.G_RET_STS_ERROR;
3002: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
3003: FND_MESSAGE.SET_TOKEN('RECORD', 'Account sites');
3004: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_party_site_id), 'null'));
3005: FND_MSG_PUB.ADD;
3006: RAISE FND_API.G_EXC_ERROR;

Line 3003: FND_MESSAGE.SET_TOKEN('RECORD', 'Account sites');

2999:
3000: EXCEPTION WHEN NO_DATA_FOUND THEN
3001: x_return_status := FND_API.G_RET_STS_ERROR;
3002: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
3003: FND_MESSAGE.SET_TOKEN('RECORD', 'Account sites');
3004: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_party_site_id), 'null'));
3005: FND_MSG_PUB.ADD;
3006: RAISE FND_API.G_EXC_ERROR;
3007: END;

Line 3004: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_party_site_id), 'null'));

3000: EXCEPTION WHEN NO_DATA_FOUND THEN
3001: x_return_status := FND_API.G_RET_STS_ERROR;
3002: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
3003: FND_MESSAGE.SET_TOKEN('RECORD', 'Account sites');
3004: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_party_site_id), 'null'));
3005: FND_MSG_PUB.ADD;
3006: RAISE FND_API.G_EXC_ERROR;
3007: END;
3008:

Line 3109: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');

3105: WHERE PARTY_SITE_ID = p_party_site_id;*/
3106:
3107: EXCEPTION WHEN NO_DATA_FOUND THEN
3108: x_return_status := FND_API.G_RET_STS_ERROR;
3109: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
3110: FND_MESSAGE.SET_TOKEN('RECORD', 'party site use');
3111: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_party_site_id), 'null'));
3112: FND_MSG_PUB.ADD;
3113: RAISE FND_API.G_EXC_ERROR;

Line 3110: FND_MESSAGE.SET_TOKEN('RECORD', 'party site use');

3106:
3107: EXCEPTION WHEN NO_DATA_FOUND THEN
3108: x_return_status := FND_API.G_RET_STS_ERROR;
3109: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
3110: FND_MESSAGE.SET_TOKEN('RECORD', 'party site use');
3111: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_party_site_id), 'null'));
3112: FND_MSG_PUB.ADD;
3113: RAISE FND_API.G_EXC_ERROR;
3114: END;

Line 3111: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_party_site_id), 'null'));

3107: EXCEPTION WHEN NO_DATA_FOUND THEN
3108: x_return_status := FND_API.G_RET_STS_ERROR;
3109: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
3110: FND_MESSAGE.SET_TOKEN('RECORD', 'party site use');
3111: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_party_site_id), 'null'));
3112: FND_MSG_PUB.ADD;
3113: RAISE FND_API.G_EXC_ERROR;
3114: END;
3115:

Line 3322: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');

3318: END LOOP;
3319: CLOSE c_prim;
3320:
3321: EXCEPTION WHEN NO_DATA_FOUND THEN
3322: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
3323: FND_MESSAGE.SET_TOKEN('RECORD', 'Party site use');
3324: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_party_site_id), 'null'));
3325: FND_MSG_PUB.ADD;
3326: RAISE FND_API.G_EXC_ERROR;

Line 3323: FND_MESSAGE.SET_TOKEN('RECORD', 'Party site use');

3319: CLOSE c_prim;
3320:
3321: EXCEPTION WHEN NO_DATA_FOUND THEN
3322: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
3323: FND_MESSAGE.SET_TOKEN('RECORD', 'Party site use');
3324: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_party_site_id), 'null'));
3325: FND_MSG_PUB.ADD;
3326: RAISE FND_API.G_EXC_ERROR;
3327: END;

Line 3324: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_party_site_id), 'null'));

3320:
3321: EXCEPTION WHEN NO_DATA_FOUND THEN
3322: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
3323: FND_MESSAGE.SET_TOKEN('RECORD', 'Party site use');
3324: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_party_site_id), 'null'));
3325: FND_MSG_PUB.ADD;
3326: RAISE FND_API.G_EXC_ERROR;
3327: END;
3328:

Line 3435: -- FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );

3431: -- p_data => x_msg_data );
3432:
3433: WHEN OTHERS THEN
3434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3435: -- FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
3436: -- FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
3437: -- FND_MSG_PUB.ADD;
3438: -- FND_MSG_PUB.Count_And_Get(
3439: -- p_encoded => FND_API.G_FALSE,

Line 3436: -- FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );

3432:
3433: WHEN OTHERS THEN
3434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3435: -- FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
3436: -- FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
3437: -- FND_MSG_PUB.ADD;
3438: -- FND_MSG_PUB.Count_And_Get(
3439: -- p_encoded => FND_API.G_FALSE,
3440: -- p_count => x_msg_count,

Line 3476: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OBSOLETE_COLUMN');

3472: (p_create_update_flag = 'U' AND
3473: p_party_site_rec.language IS NOT NULL AND
3474: p_party_site_rec.language <> p_old_party_site_rec.language)
3475: THEN
3476: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OBSOLETE_COLUMN');
3477: FND_MESSAGE.SET_TOKEN('COLUMN', 'language');
3478: FND_MSG_PUB.ADD;
3479: x_return_status := FND_API.G_RET_STS_ERROR;
3480: END IF;

Line 3477: FND_MESSAGE.SET_TOKEN('COLUMN', 'language');

3473: p_party_site_rec.language IS NOT NULL AND
3474: p_party_site_rec.language <> p_old_party_site_rec.language)
3475: THEN
3476: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OBSOLETE_COLUMN');
3477: FND_MESSAGE.SET_TOKEN('COLUMN', 'language');
3478: FND_MSG_PUB.ADD;
3479: x_return_status := FND_API.G_RET_STS_ERROR;
3480: END IF;
3481: