DBA Data[Home] [Help]

APPS.LNS_COND_ASSIGNMENT_PUB dependencies on FND_MESSAGE

Line 106: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_DUPLICATE_COLUMN');

102: INTO l_dummy
103: FROM LNS_COND_ASSIGNMENTS
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:

Line 107: FND_MESSAGE.SET_TOKEN('COLUMN', 'cond_assignment_id');

103: FROM LNS_COND_ASSIGNMENTS
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

Line 216: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_RECORD_CHANGED');

212: p_object_version_number = l_object_version_number
213: )
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;

Line 217: FND_MESSAGE.SET_TOKEN('TABLE', 'lns_COND_ASSIGNMENTs');

213: )
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:

Line 225: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');

221:
222: p_object_version_number := nvl(l_object_version_number, 1) + 1;
223:
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;

Line 226: FND_MESSAGE.SET_TOKEN('RECORD', 'cond_assignment_rec');

222: p_object_version_number := nvl(l_object_version_number, 1) + 1;
223:
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;

Line 227: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_COND_ASSIGNMENT_rec.cond_assignment_id), 'null'));

223:
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:

Line 330: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');

326: FOR UPDATE NOWAIT;
327:
328: EXCEPTION
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;

Line 331: FND_MESSAGE.SET_TOKEN('RECORD', 'cond_assignment_rec');

327:
328: EXCEPTION
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;

Line 332: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_COND_ASSIGNMENT_id), 'null'));

328: EXCEPTION
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;

Line 358: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');

354:
355: EXCEPTION
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;

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

355: EXCEPTION
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:

Line 493: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');

489:
490: WHEN OTHERS THEN
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,

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

490: WHEN OTHERS THEN
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,

Line 616: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');

612:
613: WHEN OTHERS THEN
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,

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

613: WHEN OTHERS THEN
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,

Line 721: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');

717:
718: WHEN OTHERS THEN
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,

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

718: WHEN OTHERS THEN
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,