104: WHERE cond_assignment_id = l_COND_ASSIGNMENT_id;
105:
106: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_DUPLICATE_COLUMN');
107: FND_MESSAGE.SET_TOKEN('COLUMN', 'cond_assignment_id');
108: FND_MSG_PUB.ADD;
109: RAISE FND_API.G_EXC_ERROR;
110:
111: EXCEPTION
112: WHEN NO_DATA_FOUND THEN
214: )
215: THEN
216: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_RECORD_CHANGED');
217: FND_MESSAGE.SET_TOKEN('TABLE', 'lns_COND_ASSIGNMENTs');
218: FND_MSG_PUB.ADD;
219: RAISE FND_API.G_EXC_ERROR;
220: END IF;
221:
222: p_object_version_number := nvl(l_object_version_number, 1) + 1;
224: EXCEPTION WHEN NO_DATA_FOUND THEN
225: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
226: FND_MESSAGE.SET_TOKEN('RECORD', 'cond_assignment_rec');
227: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_COND_ASSIGNMENT_rec.cond_assignment_id), 'null'));
228: FND_MSG_PUB.ADD;
229: RAISE FND_API.G_EXC_ERROR;
230: END;
231:
232: Set_Defaults(p_COND_ASSIGNMENT_rec);
329: WHEN NO_DATA_FOUND THEN
330: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
331: FND_MESSAGE.SET_TOKEN('RECORD', 'cond_assignment_rec');
332: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_COND_ASSIGNMENT_id), 'null'));
333: FND_MSG_PUB.ADD;
334: RAISE FND_API.G_EXC_ERROR;
335: END;
336: END IF;
337:
356: WHEN OTHERS THEN
357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
358: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
359: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
360: FND_MSG_PUB.ADD;
361: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
362: END;
363:
364: /*
448: SAVEPOINT create_COND_ASSIGNMENT;
449:
450: -- initialize message list if p_init_msg_list is set to TRUE.
451: IF FND_API.to_Boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) THEN
452: FND_MSG_PUB.initialize;
453: END IF;
454:
455: -- initialize API return status to success.
456: x_return_status := FND_API.G_RET_STS_SUCCESS;
473: EXCEPTION
474: WHEN FND_API.G_EXC_ERROR THEN
475: ROLLBACK TO create_COND_ASSIGNMENT;
476: x_return_status := FND_API.G_RET_STS_ERROR;
477: FND_MSG_PUB.Count_And_Get(
478: p_encoded => FND_API.G_FALSE,
479: p_count => x_msg_count,
480: p_data => x_msg_data);
481:
481:
482: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
483: ROLLBACK TO create_COND_ASSIGNMENT;
484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
485: FND_MSG_PUB.Count_And_Get(
486: p_encoded => FND_API.G_FALSE,
487: p_count => x_msg_count,
488: p_data => x_msg_data);
489:
491: ROLLBACK TO create_COND_ASSIGNMENT;
492: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
493: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
494: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
495: FND_MSG_PUB.ADD;
496: FND_MSG_PUB.Count_And_Get(
497: p_encoded => FND_API.G_FALSE,
498: p_count => x_msg_count,
499: p_data => x_msg_data);
492: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
493: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
494: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
495: FND_MSG_PUB.ADD;
496: FND_MSG_PUB.Count_And_Get(
497: p_encoded => FND_API.G_FALSE,
498: p_count => x_msg_count,
499: p_data => x_msg_data);
500:
557: SAVEPOINT update_COND_ASSIGNMENT;
558:
559: -- initialize message list if p_init_msg_list is set to TRUE.
560: IF FND_API.to_Boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) THEN
561: FND_MSG_PUB.initialize;
562: END IF;
563:
564: -- initialize API return status to success.
565: x_return_status := FND_API.G_RET_STS_SUCCESS;
596: EXCEPTION
597: WHEN FND_API.G_EXC_ERROR THEN
598: ROLLBACK TO update_COND_ASSIGNMENT;
599: x_return_status := FND_API.G_RET_STS_ERROR;
600: FND_MSG_PUB.Count_And_Get(
601: p_encoded => FND_API.G_FALSE,
602: p_count => x_msg_count,
603: p_data => x_msg_data);
604:
604:
605: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
606: ROLLBACK TO update_COND_ASSIGNMENT;
607: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
608: FND_MSG_PUB.Count_And_Get(
609: p_encoded => FND_API.G_FALSE,
610: p_count => x_msg_count,
611: p_data => x_msg_data);
612:
614: ROLLBACK TO update_COND_ASSIGNMENT;
615: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
616: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
617: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
618: FND_MSG_PUB.ADD;
619: FND_MSG_PUB.Count_And_Get(
620: p_encoded => FND_API.G_FALSE,
621: p_count => x_msg_count,
622: p_data => x_msg_data);
615: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
616: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
617: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
618: FND_MSG_PUB.ADD;
619: FND_MSG_PUB.Count_And_Get(
620: p_encoded => FND_API.G_FALSE,
621: p_count => x_msg_count,
622: p_data => x_msg_data);
623:
677: SAVEPOINT delete_COND_ASSIGNMENT;
678:
679: -- initialize message list if p_init_msg_list is set to TRUE.
680: IF FND_API.to_Boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) THEN
681: FND_MSG_PUB.initialize;
682: END IF;
683:
684: -- initialize API return status to success.
685: x_return_status := FND_API.G_RET_STS_SUCCESS;
701: EXCEPTION
702: WHEN FND_API.G_EXC_ERROR THEN
703: ROLLBACK TO delete_COND_ASSIGNMENT;
704: x_return_status := FND_API.G_RET_STS_ERROR;
705: FND_MSG_PUB.Count_And_Get(
706: p_encoded => FND_API.G_FALSE,
707: p_count => x_msg_count,
708: p_data => x_msg_data);
709:
709:
710: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
711: ROLLBACK TO delete_COND_ASSIGNMENT;
712: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
713: FND_MSG_PUB.Count_And_Get(
714: p_encoded => FND_API.G_FALSE,
715: p_count => x_msg_count,
716: p_data => x_msg_data);
717:
719: ROLLBACK TO delete_COND_ASSIGNMENT;
720: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
721: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
722: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
723: FND_MSG_PUB.ADD;
724: FND_MSG_PUB.Count_And_Get(
725: p_encoded => FND_API.G_FALSE,
726: p_count => x_msg_count,
727: p_data => x_msg_data);
720: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
721: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
722: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
723: FND_MSG_PUB.ADD;
724: FND_MSG_PUB.Count_And_Get(
725: p_encoded => FND_API.G_FALSE,
726: p_count => x_msg_count,
727: p_data => x_msg_data);
728: