106: INTO l_dummy
107: FROM LNS_FEE_ASSIGNMENTS
108: WHERE fee_assignment_id = l_fee_assignment_id;
109:
110: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_DUPLICATE_COLUMN');
111: FND_MESSAGE.SET_TOKEN('COLUMN', 'fee_assignment_id');
112: FND_MSG_PUB.ADD;
113: RAISE FND_API.G_EXC_ERROR;
114:
107: FROM LNS_FEE_ASSIGNMENTS
108: WHERE fee_assignment_id = l_fee_assignment_id;
109:
110: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_DUPLICATE_COLUMN');
111: FND_MESSAGE.SET_TOKEN('COLUMN', 'fee_assignment_id');
112: FND_MSG_PUB.ADD;
113: RAISE FND_API.G_EXC_ERROR;
114:
115: EXCEPTION
221: p_object_version_number = l_object_version_number
222: )
223: )
224: THEN
225: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_RECORD_CHANGED');
226: FND_MESSAGE.SET_TOKEN('TABLE', 'lns_fee_assignments');
227: FND_MSG_PUB.ADD;
228: RAISE FND_API.G_EXC_ERROR;
229: END IF;
222: )
223: )
224: THEN
225: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_RECORD_CHANGED');
226: FND_MESSAGE.SET_TOKEN('TABLE', 'lns_fee_assignments');
227: FND_MSG_PUB.ADD;
228: RAISE FND_API.G_EXC_ERROR;
229: END IF;
230:
230:
231: p_object_version_number := nvl(l_object_version_number, 1) + 1;
232:
233: EXCEPTION WHEN NO_DATA_FOUND THEN
234: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
235: FND_MESSAGE.SET_TOKEN('RECORD', 'assignment_rec');
236: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_fee_assignment_rec.fee_assignment_id), 'null'));
237: FND_MSG_PUB.ADD;
238: RAISE FND_API.G_EXC_ERROR;
231: p_object_version_number := nvl(l_object_version_number, 1) + 1;
232:
233: EXCEPTION WHEN NO_DATA_FOUND THEN
234: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
235: FND_MESSAGE.SET_TOKEN('RECORD', 'assignment_rec');
236: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_fee_assignment_rec.fee_assignment_id), 'null'));
237: FND_MSG_PUB.ADD;
238: RAISE FND_API.G_EXC_ERROR;
239: END;
232:
233: EXCEPTION WHEN NO_DATA_FOUND THEN
234: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
235: FND_MESSAGE.SET_TOKEN('RECORD', 'assignment_rec');
236: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_fee_assignment_rec.fee_assignment_id), 'null'));
237: FND_MSG_PUB.ADD;
238: RAISE FND_API.G_EXC_ERROR;
239: END;
240:
339: WHERE FEE_ASSIGNMENT_ID = p_fee_assignment_id;
340:
341: EXCEPTION
342: WHEN NO_DATA_FOUND THEN
343: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
344: FND_MESSAGE.SET_TOKEN('RECORD', 'assignment_rec');
345: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_fee_assignment_id), 'null'));
346: FND_MSG_PUB.ADD;
347: RAISE FND_API.G_EXC_ERROR;
340:
341: EXCEPTION
342: WHEN NO_DATA_FOUND THEN
343: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
344: FND_MESSAGE.SET_TOKEN('RECORD', 'assignment_rec');
345: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_fee_assignment_id), 'null'));
346: FND_MSG_PUB.ADD;
347: RAISE FND_API.G_EXC_ERROR;
348: END;
341: EXCEPTION
342: WHEN NO_DATA_FOUND THEN
343: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
344: FND_MESSAGE.SET_TOKEN('RECORD', 'assignment_rec');
345: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_fee_assignment_id), 'null'));
346: FND_MSG_PUB.ADD;
347: RAISE FND_API.G_EXC_ERROR;
348: END;
349: END IF;
380:
381: EXCEPTION
382: WHEN OTHERS THEN
383: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
384: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
385: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
386: FND_MSG_PUB.ADD;
387: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
388: END;
381: EXCEPTION
382: WHEN OTHERS THEN
383: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
384: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
385: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
386: FND_MSG_PUB.ADD;
387: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
388: END;
389:
522:
523: WHEN OTHERS THEN
524: ROLLBACK TO create_fee_assignment;
525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
526: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
527: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
528: FND_MSG_PUB.ADD;
529: FND_MSG_PUB.Count_And_Get(
530: p_encoded => FND_API.G_FALSE,
523: WHEN OTHERS THEN
524: ROLLBACK TO create_fee_assignment;
525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
526: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
527: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
528: FND_MSG_PUB.ADD;
529: FND_MSG_PUB.Count_And_Get(
530: p_encoded => FND_API.G_FALSE,
531: p_count => x_msg_count,
647:
648: WHEN OTHERS THEN
649: ROLLBACK TO update_fee_assignment;
650: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
651: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
652: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
653: FND_MSG_PUB.ADD;
654: FND_MSG_PUB.Count_And_Get(
655: p_encoded => FND_API.G_FALSE,
648: WHEN OTHERS THEN
649: ROLLBACK TO update_fee_assignment;
650: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
651: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
652: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
653: FND_MSG_PUB.ADD;
654: FND_MSG_PUB.Count_And_Get(
655: p_encoded => FND_API.G_FALSE,
656: p_count => x_msg_count,
752:
753: WHEN OTHERS THEN
754: ROLLBACK TO delete_fee_assignment;
755: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
756: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
757: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
758: FND_MSG_PUB.ADD;
759: FND_MSG_PUB.Count_And_Get(
760: p_encoded => FND_API.G_FALSE,
753: WHEN OTHERS THEN
754: ROLLBACK TO delete_fee_assignment;
755: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
756: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
757: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
758: FND_MSG_PUB.ADD;
759: FND_MSG_PUB.Count_And_Get(
760: p_encoded => FND_API.G_FALSE,
761: p_count => x_msg_count,