DBA Data[Home] [Help]

APPS.LNS_FEE_ASSIGNMENT_PUB dependencies on FND_MESSAGE

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

102: INTO l_dummy
103: FROM LNS_FEE_ASSIGNMENTS
104: WHERE fee_assignment_id = l_fee_assignment_id;
105:
106: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_DUPLICATE_COLUMN');
107: FND_MESSAGE.SET_TOKEN('COLUMN', 'fee_assignment_id');
108: FND_MSG_PUB.ADD;
109: RAISE FND_API.G_EXC_ERROR;
110:

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

103: FROM LNS_FEE_ASSIGNMENTS
104: WHERE fee_assignment_id = l_fee_assignment_id;
105:
106: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_DUPLICATE_COLUMN');
107: FND_MESSAGE.SET_TOKEN('COLUMN', 'fee_assignment_id');
108: FND_MSG_PUB.ADD;
109: RAISE FND_API.G_EXC_ERROR;
110:
111: EXCEPTION

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

214: p_object_version_number = l_object_version_number
215: )
216: )
217: THEN
218: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_RECORD_CHANGED');
219: FND_MESSAGE.SET_TOKEN('TABLE', 'lns_fee_assignments');
220: FND_MSG_PUB.ADD;
221: RAISE FND_API.G_EXC_ERROR;
222: END IF;

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

215: )
216: )
217: THEN
218: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_RECORD_CHANGED');
219: FND_MESSAGE.SET_TOKEN('TABLE', 'lns_fee_assignments');
220: FND_MSG_PUB.ADD;
221: RAISE FND_API.G_EXC_ERROR;
222: END IF;
223:

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

223:
224: p_object_version_number := nvl(l_object_version_number, 1) + 1;
225:
226: EXCEPTION WHEN NO_DATA_FOUND THEN
227: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
228: FND_MESSAGE.SET_TOKEN('RECORD', 'assignment_rec');
229: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_fee_assignment_rec.fee_assignment_id), 'null'));
230: FND_MSG_PUB.ADD;
231: RAISE FND_API.G_EXC_ERROR;

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

224: p_object_version_number := nvl(l_object_version_number, 1) + 1;
225:
226: EXCEPTION WHEN NO_DATA_FOUND THEN
227: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
228: FND_MESSAGE.SET_TOKEN('RECORD', 'assignment_rec');
229: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_fee_assignment_rec.fee_assignment_id), 'null'));
230: FND_MSG_PUB.ADD;
231: RAISE FND_API.G_EXC_ERROR;
232: END;

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

225:
226: EXCEPTION WHEN NO_DATA_FOUND THEN
227: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
228: FND_MESSAGE.SET_TOKEN('RECORD', 'assignment_rec');
229: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_fee_assignment_rec.fee_assignment_id), 'null'));
230: FND_MSG_PUB.ADD;
231: RAISE FND_API.G_EXC_ERROR;
232: END;
233:

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

329: WHERE FEE_ASSIGNMENT_ID = p_fee_assignment_id;
330:
331: EXCEPTION
332: WHEN NO_DATA_FOUND THEN
333: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
334: FND_MESSAGE.SET_TOKEN('RECORD', 'assignment_rec');
335: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_fee_assignment_id), 'null'));
336: FND_MSG_PUB.ADD;
337: RAISE FND_API.G_EXC_ERROR;

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

330:
331: EXCEPTION
332: WHEN NO_DATA_FOUND THEN
333: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
334: FND_MESSAGE.SET_TOKEN('RECORD', 'assignment_rec');
335: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_fee_assignment_id), 'null'));
336: FND_MSG_PUB.ADD;
337: RAISE FND_API.G_EXC_ERROR;
338: END;

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

331: EXCEPTION
332: WHEN NO_DATA_FOUND THEN
333: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
334: FND_MESSAGE.SET_TOKEN('RECORD', 'assignment_rec');
335: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_fee_assignment_id), 'null'));
336: FND_MSG_PUB.ADD;
337: RAISE FND_API.G_EXC_ERROR;
338: END;
339: END IF;

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

370:
371: EXCEPTION
372: WHEN OTHERS THEN
373: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
374: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
375: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
376: FND_MSG_PUB.ADD;
377: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
378: END;

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

371: EXCEPTION
372: WHEN OTHERS THEN
373: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
374: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
375: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
376: FND_MSG_PUB.ADD;
377: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
378: END;
379:

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

504:
505: WHEN OTHERS THEN
506: ROLLBACK TO create_fee_assignment;
507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
508: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
509: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
510: FND_MSG_PUB.ADD;
511: FND_MSG_PUB.Count_And_Get(
512: p_encoded => FND_API.G_FALSE,

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

505: WHEN OTHERS THEN
506: ROLLBACK TO create_fee_assignment;
507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
508: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
509: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
510: FND_MSG_PUB.ADD;
511: FND_MSG_PUB.Count_And_Get(
512: p_encoded => FND_API.G_FALSE,
513: p_count => x_msg_count,

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

629:
630: WHEN OTHERS THEN
631: ROLLBACK TO update_fee_assignment;
632: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
633: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
634: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
635: FND_MSG_PUB.ADD;
636: FND_MSG_PUB.Count_And_Get(
637: p_encoded => FND_API.G_FALSE,

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

630: WHEN OTHERS THEN
631: ROLLBACK TO update_fee_assignment;
632: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
633: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
634: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
635: FND_MSG_PUB.ADD;
636: FND_MSG_PUB.Count_And_Get(
637: p_encoded => FND_API.G_FALSE,
638: p_count => x_msg_count,

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

734:
735: WHEN OTHERS THEN
736: ROLLBACK TO delete_fee_assignment;
737: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
738: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
739: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
740: FND_MSG_PUB.ADD;
741: FND_MSG_PUB.Count_And_Get(
742: p_encoded => FND_API.G_FALSE,

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

735: WHEN OTHERS THEN
736: ROLLBACK TO delete_fee_assignment;
737: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
738: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
739: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
740: FND_MSG_PUB.ADD;
741: FND_MSG_PUB.Count_And_Get(
742: p_encoded => FND_API.G_FALSE,
743: p_count => x_msg_count,