DBA Data[Home] [Help]

APPS.LNS_FEE_ASSIGNMENT_PUB dependencies on FND_MESSAGE

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

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:

Line 111: FND_MESSAGE.SET_TOKEN('COLUMN', 'fee_assignment_id');

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

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

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;

Line 226: FND_MESSAGE.SET_TOKEN('TABLE', 'lns_fee_assignments');

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:

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

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;

Line 235: FND_MESSAGE.SET_TOKEN('RECORD', 'assignment_rec');

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;

Line 236: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_fee_assignment_rec.fee_assignment_id), 'null'));

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:

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

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;

Line 344: FND_MESSAGE.SET_TOKEN('RECORD', 'assignment_rec');

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;

Line 345: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_fee_assignment_id), 'null'));

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;

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

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;

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

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:

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

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,

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

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,

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

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,

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

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,

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

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,

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

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,