DBA Data[Home] [Help]

APPS.LNS_FEE_ASSIGNMENT_PUB dependencies on FND_MSG_PUB

Line 112: FND_MSG_PUB.ADD;

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
116: WHEN NO_DATA_FOUND THEN

Line 227: FND_MSG_PUB.ADD;

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

Line 237: FND_MSG_PUB.ADD;

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:
241: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

Line 346: FND_MSG_PUB.ADD;

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;
350:

Line 386: FND_MSG_PUB.ADD;

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

Line 458: FND_MSG_PUB.initialize;

454: SAVEPOINT create_fee_assignment;
455:
456: -- initialize message list if p_init_msg_list is set to TRUE.
457: IF FND_API.to_Boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) THEN
458: FND_MSG_PUB.initialize;
459: END IF;
460:
461: -- initialize API return status to success.
462: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 510: FND_MSG_PUB.Count_And_Get(

506: EXCEPTION
507: WHEN FND_API.G_EXC_ERROR THEN
508: ROLLBACK TO create_fee_assignment;
509: x_return_status := FND_API.G_RET_STS_ERROR;
510: FND_MSG_PUB.Count_And_Get(
511: p_encoded => FND_API.G_FALSE,
512: p_count => x_msg_count,
513: p_data => x_msg_data);
514:

Line 518: FND_MSG_PUB.Count_And_Get(

514:
515: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
516: ROLLBACK TO create_fee_assignment;
517: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
518: FND_MSG_PUB.Count_And_Get(
519: p_encoded => FND_API.G_FALSE,
520: p_count => x_msg_count,
521: p_data => x_msg_data);
522:

Line 528: FND_MSG_PUB.ADD;

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,
532: p_data => x_msg_data);

Line 529: FND_MSG_PUB.Count_And_Get(

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,
532: p_data => x_msg_data);
533:

Line 594: FND_MSG_PUB.initialize;

590: SAVEPOINT update_fee_assignment;
591:
592: -- initialize message list if p_init_msg_list is set to TRUE.
593: IF FND_API.to_Boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) THEN
594: FND_MSG_PUB.initialize;
595: END IF;
596:
597: -- initialize API return status to success.
598: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 635: FND_MSG_PUB.Count_And_Get(

631: EXCEPTION
632: WHEN FND_API.G_EXC_ERROR THEN
633: ROLLBACK TO update_fee_assignment;
634: x_return_status := FND_API.G_RET_STS_ERROR;
635: FND_MSG_PUB.Count_And_Get(
636: p_encoded => FND_API.G_FALSE,
637: p_count => x_msg_count,
638: p_data => x_msg_data);
639:

Line 643: FND_MSG_PUB.Count_And_Get(

639:
640: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
641: ROLLBACK TO update_fee_assignment;
642: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
643: FND_MSG_PUB.Count_And_Get(
644: p_encoded => FND_API.G_FALSE,
645: p_count => x_msg_count,
646: p_data => x_msg_data);
647:

Line 653: FND_MSG_PUB.ADD;

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,
657: p_data => x_msg_data);

Line 654: FND_MSG_PUB.Count_And_Get(

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,
657: p_data => x_msg_data);
658:

Line 716: FND_MSG_PUB.initialize;

712: SAVEPOINT delete_fee_assignment;
713:
714: -- initialize message list if p_init_msg_list is set to TRUE.
715: IF FND_API.to_Boolean(p_init_msg_list) THEN
716: FND_MSG_PUB.initialize;
717: END IF;
718:
719: -- initialize API return status to success.
720: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 740: FND_MSG_PUB.Count_And_Get(

736: EXCEPTION
737: WHEN FND_API.G_EXC_ERROR THEN
738: ROLLBACK TO delete_fee_assignment;
739: x_return_status := FND_API.G_RET_STS_ERROR;
740: FND_MSG_PUB.Count_And_Get(
741: p_encoded => FND_API.G_FALSE,
742: p_count => x_msg_count,
743: p_data => x_msg_data);
744:

Line 748: FND_MSG_PUB.Count_And_Get(

744:
745: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
746: ROLLBACK TO delete_fee_assignment;
747: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
748: FND_MSG_PUB.Count_And_Get(
749: p_encoded => FND_API.G_FALSE,
750: p_count => x_msg_count,
751: p_data => x_msg_data);
752:

Line 758: FND_MSG_PUB.ADD;

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,
762: p_data => x_msg_data);

Line 759: FND_MSG_PUB.Count_And_Get(

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,
762: p_data => x_msg_data);
763: