82: and party_type in ('ORGANIZATION','PERSON')
83: FOR UPDATE NOWAIT;
84: EXCEPTION
85: WHEN NO_DATA_FOUND THEN
86: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
87: FND_MESSAGE.SET_TOKEN('RECORD', 'party of type organization');
88: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(P_PARTY_ID), 'NULL'));
89: FND_MSG_PUB.ADD;
90: RAISE FND_API.G_EXC_ERROR;
83: FOR UPDATE NOWAIT;
84: EXCEPTION
85: WHEN NO_DATA_FOUND THEN
86: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
87: FND_MESSAGE.SET_TOKEN('RECORD', 'party of type organization');
88: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(P_PARTY_ID), 'NULL'));
89: FND_MSG_PUB.ADD;
90: RAISE FND_API.G_EXC_ERROR;
91: END;
84: EXCEPTION
85: WHEN NO_DATA_FOUND THEN
86: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
87: FND_MESSAGE.SET_TOKEN('RECORD', 'party of type organization');
88: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(P_PARTY_ID), 'NULL'));
89: FND_MSG_PUB.ADD;
90: RAISE FND_API.G_EXC_ERROR;
91: END;
92:
93: -- If this happens the record has changed
94: IF NOT ((x_object_version_number is null and l_object_version_number is null)
95: OR (nvl(x_object_version_number,-1) = l_object_version_number))
96: THEN
97: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
98: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_PARTIES');
99: FND_MSG_PUB.ADD;
100: RAISE FND_API.G_EXC_ERROR;
101: END IF;
94: IF NOT ((x_object_version_number is null and l_object_version_number is null)
95: OR (nvl(x_object_version_number,-1) = l_object_version_number))
96: THEN
97: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
98: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_PARTIES');
99: FND_MSG_PUB.ADD;
100: RAISE FND_API.G_EXC_ERROR;
101: END IF;
102:
169: end if;
170:
171: if (l_test_security <> 'T' OR l_test_security <> FND_API.G_TRUE) then
172:
173: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_UPDATE_PRIVILEGE');
174: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
175: hz_dss_util_pub.get_display_name('HZ_PARTIES', null));
176: FND_MSG_PUB.ADD;
177: RAISE FND_API.G_EXC_ERROR;
170:
171: if (l_test_security <> 'T' OR l_test_security <> FND_API.G_TRUE) then
172:
173: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_UPDATE_PRIVILEGE');
174: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
175: hz_dss_util_pub.get_display_name('HZ_PARTIES', null));
176: FND_MSG_PUB.ADD;
177: RAISE FND_API.G_EXC_ERROR;
178: end if;
233: p_data => x_msg_data);
234: WHEN OTHERS THEN
235: ROLLBACK TO set_certification_level ;
236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
237: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
238: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
239: FND_MSG_PUB.ADD;
240: FND_MSG_PUB.Count_And_Get(
241: p_encoded => FND_API.G_FALSE,
234: WHEN OTHERS THEN
235: ROLLBACK TO set_certification_level ;
236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
237: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
238: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
239: FND_MSG_PUB.ADD;
240: FND_MSG_PUB.Count_And_Get(
241: p_encoded => FND_API.G_FALSE,
242: p_count => x_msg_count,
299: end if;
300:
301: if (l_test_security <> 'T' OR l_test_security <> FND_API.G_TRUE) then
302:
303: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_UPDATE_PRIVILEGE');
304: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
305: hz_dss_util_pub.get_display_name('HZ_PARTIES', null));
306: FND_MSG_PUB.ADD;
307: RAISE FND_API.G_EXC_ERROR;
300:
301: if (l_test_security <> 'T' OR l_test_security <> FND_API.G_TRUE) then
302:
303: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_UPDATE_PRIVILEGE');
304: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
305: hz_dss_util_pub.get_display_name('HZ_PARTIES', null));
306: FND_MSG_PUB.ADD;
307: RAISE FND_API.G_EXC_ERROR;
308: end if;
404: p_data => x_msg_data);
405: WHEN OTHERS THEN
406: ROLLBACK TO set_party_attributes;
407: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
408: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
409: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
410: FND_MSG_PUB.ADD;
411: FND_MSG_PUB.Count_And_Get(
412: p_encoded => FND_API.G_FALSE,
405: WHEN OTHERS THEN
406: ROLLBACK TO set_party_attributes;
407: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
408: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
409: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
410: FND_MSG_PUB.ADD;
411: FND_MSG_PUB.Count_And_Get(
412: p_encoded => FND_API.G_FALSE,
413: p_count => x_msg_count,