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 699: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');

695: p_object_version_number = l_object_version_number
696: )
697: )
698: THEN
699: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
700: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_party_sites');
701: FND_MSG_PUB.ADD;
702: RAISE FND_API.G_EXC_ERROR;
703: END IF;

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

696: )
697: )
698: THEN
699: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
700: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_party_sites');
701: FND_MSG_PUB.ADD;
702: RAISE FND_API.G_EXC_ERROR;
703: END IF;
704:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1034: FROM HZ_PARTY_SITE_USES
1035: WHERE PARTY_SITE_USE_ID = l_party_site_use_id;
1036:
1037: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
1038: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_site_use_id');
1039: FND_MSG_PUB.ADD;
1040: RAISE FND_API.G_EXC_ERROR;
1041:
1042: EXCEPTION

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

1217: p_object_version_number = l_object_version_number
1218: )
1219: )
1220: THEN
1221: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1222: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_PARTY_SITE_USES');
1223: FND_MSG_PUB.ADD;
1224: RAISE FND_API.G_EXC_ERROR;
1225: END IF;

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

1218: )
1219: )
1220: THEN
1221: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1222: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_PARTY_SITE_USES');
1223: FND_MSG_PUB.ADD;
1224: RAISE FND_API.G_EXC_ERROR;
1225: END IF;
1226:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1426: CLOSE c_party;
1427: EXCEPTION
1428: WHEN OTHERS THEN
1429: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1430: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_PARTIES');
1431: FND_MSG_PUB.ADD;
1432: RAISE FND_API.G_EXC_ERROR;
1433: END;
1434:

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

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

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

1548: CLOSE c_party_sites;
1549: EXCEPTION
1550: WHEN OTHERS THEN
1551: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1552: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_PARTY_SITES');
1553: FND_MSG_PUB.ADD;
1554: RAISE FND_API.G_EXC_ERROR;
1555: END;
1556:

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

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

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

1644: CLOSE c_party_site_uses;
1645: EXCEPTION
1646: WHEN OTHERS THEN
1647: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1648: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_PARTY_SITE_USES');
1649: FND_MSG_PUB.ADD;
1650: RAISE FND_API.G_EXC_ERROR;
1651: END;
1652:

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

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

Line 1818: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',

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

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

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

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

1928:
1929: WHEN OTHERS THEN
1930: ROLLBACK TO create_party_site;
1931: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1932: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1933: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1934: FND_MSG_PUB.ADD;
1935: FND_MSG_PUB.Count_And_Get(
1936: p_encoded => FND_API.G_FALSE,

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

1929: WHEN OTHERS THEN
1930: ROLLBACK TO create_party_site;
1931: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1932: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1933: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1934: FND_MSG_PUB.ADD;
1935: FND_MSG_PUB.Count_And_Get(
1936: p_encoded => FND_API.G_FALSE,
1937: p_count => x_msg_count,

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

2085: if (l_test_security <> 'T' OR l_test_security <> FND_API.G_TRUE) then
2086: --
2087: -- Bug 3835601: replaced the dss message with a more user friendly message
2088: --
2089: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_UPDATE_PRIVILEGE');
2090: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
2091: fnd_message.get_string('AR', 'HZ_DSS_PARTY_ADDRESSES'));
2092: FND_MSG_PUB.ADD;
2093: RAISE FND_API.G_EXC_ERROR;

Line 2090: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',

2086: --
2087: -- Bug 3835601: replaced the dss message with a more user friendly message
2088: --
2089: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_UPDATE_PRIVILEGE');
2090: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
2091: fnd_message.get_string('AR', 'HZ_DSS_PARTY_ADDRESSES'));
2092: FND_MSG_PUB.ADD;
2093: RAISE FND_API.G_EXC_ERROR;
2094: end if;

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

2087: -- Bug 3835601: replaced the dss message with a more user friendly message
2088: --
2089: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_UPDATE_PRIVILEGE');
2090: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
2091: fnd_message.get_string('AR', 'HZ_DSS_PARTY_ADDRESSES'));
2092: FND_MSG_PUB.ADD;
2093: RAISE FND_API.G_EXC_ERROR;
2094: end if;
2095: END IF;

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

2174: AND application_id = 222
2175: AND rownum =1;
2176: EXCEPTION
2177: WHEN NO_DATA_FOUND THEN
2178: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
2179: FND_MESSAGE.SET_TOKEN('RECORD', 'Message Name');
2180: --FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_party_site_use_rec.party_site_id), 'null'));
2181: FND_MSG_PUB.ADD;
2182: RAISE FND_API.G_EXC_ERROR;

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

2175: AND rownum =1;
2176: EXCEPTION
2177: WHEN NO_DATA_FOUND THEN
2178: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
2179: FND_MESSAGE.SET_TOKEN('RECORD', 'Message Name');
2180: --FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_party_site_use_rec.party_site_id), 'null'));
2181: FND_MSG_PUB.ADD;
2182: RAISE FND_API.G_EXC_ERROR;
2183: END;

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

2176: EXCEPTION
2177: WHEN NO_DATA_FOUND THEN
2178: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
2179: FND_MESSAGE.SET_TOKEN('RECORD', 'Message Name');
2180: --FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_party_site_use_rec.party_site_id), 'null'));
2181: FND_MSG_PUB.ADD;
2182: RAISE FND_API.G_EXC_ERROR;
2183: END;
2184: END IF;

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

2270:
2271: WHEN OTHERS THEN
2272: ROLLBACK TO update_party_site;
2273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2274: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2275: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2276: FND_MSG_PUB.ADD;
2277: FND_MSG_PUB.Count_And_Get(
2278: p_encoded => FND_API.G_FALSE,

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

2271: WHEN OTHERS THEN
2272: ROLLBACK TO update_party_site;
2273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2274: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2275: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2276: FND_MSG_PUB.ADD;
2277: FND_MSG_PUB.Count_And_Get(
2278: p_encoded => FND_API.G_FALSE,
2279: p_count => x_msg_count,

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

2460:
2461: WHEN OTHERS THEN
2462: ROLLBACK TO create_party_site_use;
2463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2464: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2465: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2466: FND_MSG_PUB.ADD;
2467: FND_MSG_PUB.Count_And_Get(
2468: p_encoded => FND_API.G_FALSE,

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

2461: WHEN OTHERS THEN
2462: ROLLBACK TO create_party_site_use;
2463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2464: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2465: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2466: FND_MSG_PUB.ADD;
2467: FND_MSG_PUB.Count_And_Get(
2468: p_encoded => FND_API.G_FALSE,
2469: p_count => x_msg_count,

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

2662:
2663: WHEN OTHERS THEN
2664: ROLLBACK TO update_party_site_use;
2665: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2666: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2667: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2668: FND_MSG_PUB.ADD;
2669: FND_MSG_PUB.Count_And_Get(
2670: p_encoded => FND_API.G_FALSE,

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

2663: WHEN OTHERS THEN
2664: ROLLBACK TO update_party_site_use;
2665: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2666: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2667: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2668: FND_MSG_PUB.ADD;
2669: FND_MSG_PUB.Count_And_Get(
2670: p_encoded => FND_API.G_FALSE,
2671: p_count => x_msg_count,

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

2745:
2746: --Check whether primary key has been passed in.
2747: IF p_party_site_id IS NULL OR
2748: p_party_site_id = FND_API.G_MISS_NUM THEN
2749: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
2750: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'party_site_id' );
2751: FND_MSG_PUB.ADD;
2752: RAISE FND_API.G_EXC_ERROR;
2753: END IF;

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

2746: --Check whether primary key has been passed in.
2747: IF p_party_site_id IS NULL OR
2748: p_party_site_id = FND_API.G_MISS_NUM THEN
2749: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
2750: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'party_site_id' );
2751: FND_MSG_PUB.ADD;
2752: RAISE FND_API.G_EXC_ERROR;
2753: END IF;
2754:

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

2818: p_data => x_msg_data );
2819:
2820: WHEN OTHERS THEN
2821: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2822: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2823: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2824: FND_MSG_PUB.ADD;
2825: FND_MSG_PUB.Count_And_Get(
2826: p_encoded => FND_API.G_FALSE,

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

2819:
2820: WHEN OTHERS THEN
2821: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2822: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2823: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2824: FND_MSG_PUB.ADD;
2825: FND_MSG_PUB.Count_And_Get(
2826: p_encoded => FND_API.G_FALSE,
2827: p_count => x_msg_count,

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

2883:
2884: --Check whether primary key has been passed in.
2885: IF p_party_site_use_id IS NULL OR
2886: p_party_site_use_id = FND_API.G_MISS_NUM THEN
2887: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
2888: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'p_party_site_use_id' );
2889: FND_MSG_PUB.ADD;
2890: RAISE FND_API.G_EXC_ERROR;
2891: END IF;

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

2884: --Check whether primary key has been passed in.
2885: IF p_party_site_use_id IS NULL OR
2886: p_party_site_use_id = FND_API.G_MISS_NUM THEN
2887: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
2888: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'p_party_site_use_id' );
2889: FND_MSG_PUB.ADD;
2890: RAISE FND_API.G_EXC_ERROR;
2891: END IF;
2892:

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

2927: p_data => x_msg_data );
2928:
2929: WHEN OTHERS THEN
2930: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2931: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2932: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2933: FND_MSG_PUB.ADD;
2934: FND_MSG_PUB.Count_And_Get(
2935: p_encoded => FND_API.G_FALSE,

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

2928:
2929: WHEN OTHERS THEN
2930: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2931: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2932: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2933: FND_MSG_PUB.ADD;
2934: FND_MSG_PUB.Count_And_Get(
2935: p_encoded => FND_API.G_FALSE,
2936: p_count => x_msg_count,

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

3005: WHERE PARTY_SITE_ID = p_party_site_id;
3006:
3007: EXCEPTION WHEN NO_DATA_FOUND THEN
3008: x_return_status := FND_API.G_RET_STS_ERROR;
3009: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
3010: FND_MESSAGE.SET_TOKEN('RECORD', 'Account sites');
3011: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_party_site_id), 'null'));
3012: FND_MSG_PUB.ADD;
3013: RAISE FND_API.G_EXC_ERROR;

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

3006:
3007: EXCEPTION WHEN NO_DATA_FOUND THEN
3008: x_return_status := FND_API.G_RET_STS_ERROR;
3009: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
3010: FND_MESSAGE.SET_TOKEN('RECORD', 'Account sites');
3011: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_party_site_id), 'null'));
3012: FND_MSG_PUB.ADD;
3013: RAISE FND_API.G_EXC_ERROR;
3014: END;

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

3007: EXCEPTION WHEN NO_DATA_FOUND THEN
3008: x_return_status := FND_API.G_RET_STS_ERROR;
3009: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
3010: FND_MESSAGE.SET_TOKEN('RECORD', 'Account sites');
3011: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_party_site_id), 'null'));
3012: FND_MSG_PUB.ADD;
3013: RAISE FND_API.G_EXC_ERROR;
3014: END;
3015:

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

3112: WHERE PARTY_SITE_ID = p_party_site_id;*/
3113:
3114: EXCEPTION WHEN NO_DATA_FOUND THEN
3115: x_return_status := FND_API.G_RET_STS_ERROR;
3116: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
3117: FND_MESSAGE.SET_TOKEN('RECORD', 'party site use');
3118: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_party_site_id), 'null'));
3119: FND_MSG_PUB.ADD;
3120: RAISE FND_API.G_EXC_ERROR;

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

3113:
3114: EXCEPTION WHEN NO_DATA_FOUND THEN
3115: x_return_status := FND_API.G_RET_STS_ERROR;
3116: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
3117: FND_MESSAGE.SET_TOKEN('RECORD', 'party site use');
3118: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_party_site_id), 'null'));
3119: FND_MSG_PUB.ADD;
3120: RAISE FND_API.G_EXC_ERROR;
3121: END;

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

3114: EXCEPTION WHEN NO_DATA_FOUND THEN
3115: x_return_status := FND_API.G_RET_STS_ERROR;
3116: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
3117: FND_MESSAGE.SET_TOKEN('RECORD', 'party site use');
3118: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_party_site_id), 'null'));
3119: FND_MSG_PUB.ADD;
3120: RAISE FND_API.G_EXC_ERROR;
3121: END;
3122:

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

3325: END LOOP;
3326: CLOSE c_prim;
3327:
3328: EXCEPTION WHEN NO_DATA_FOUND THEN
3329: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
3330: FND_MESSAGE.SET_TOKEN('RECORD', 'Party site use');
3331: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_party_site_id), 'null'));
3332: FND_MSG_PUB.ADD;
3333: RAISE FND_API.G_EXC_ERROR;

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

3326: CLOSE c_prim;
3327:
3328: EXCEPTION WHEN NO_DATA_FOUND THEN
3329: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
3330: FND_MESSAGE.SET_TOKEN('RECORD', 'Party site use');
3331: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_party_site_id), 'null'));
3332: FND_MSG_PUB.ADD;
3333: RAISE FND_API.G_EXC_ERROR;
3334: END;

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

3327:
3328: EXCEPTION WHEN NO_DATA_FOUND THEN
3329: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
3330: FND_MESSAGE.SET_TOKEN('RECORD', 'Party site use');
3331: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_party_site_id), 'null'));
3332: FND_MSG_PUB.ADD;
3333: RAISE FND_API.G_EXC_ERROR;
3334: END;
3335:

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

3438: -- p_data => x_msg_data );
3439:
3440: WHEN OTHERS THEN
3441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3442: -- FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
3443: -- FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
3444: -- FND_MSG_PUB.ADD;
3445: -- FND_MSG_PUB.Count_And_Get(
3446: -- p_encoded => FND_API.G_FALSE,

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

3439:
3440: WHEN OTHERS THEN
3441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3442: -- FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
3443: -- FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
3444: -- FND_MSG_PUB.ADD;
3445: -- FND_MSG_PUB.Count_And_Get(
3446: -- p_encoded => FND_API.G_FALSE,
3447: -- p_count => x_msg_count,

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

3479: (p_create_update_flag = 'U' AND
3480: p_party_site_rec.language IS NOT NULL AND
3481: p_party_site_rec.language <> p_old_party_site_rec.language)
3482: THEN
3483: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OBSOLETE_COLUMN');
3484: FND_MESSAGE.SET_TOKEN('COLUMN', 'language');
3485: FND_MSG_PUB.ADD;
3486: x_return_status := FND_API.G_RET_STS_ERROR;
3487: END IF;

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

3480: p_party_site_rec.language IS NOT NULL AND
3481: p_party_site_rec.language <> p_old_party_site_rec.language)
3482: THEN
3483: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OBSOLETE_COLUMN');
3484: FND_MESSAGE.SET_TOKEN('COLUMN', 'language');
3485: FND_MSG_PUB.ADD;
3486: x_return_status := FND_API.G_RET_STS_ERROR;
3487: END IF;
3488: