eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.LNS_FEE_ASSIGNMENT_PUB dependencies on FND_API

Line 102: l_fee_assignment_id <> FND_API.G_MISS_NUM

98: END IF;
99:
100: -- if primary key value is passed, check for uniqueness.
101: IF l_fee_assignment_id IS NOT NULL AND
102: l_fee_assignment_id <> FND_API.G_MISS_NUM
103: THEN
104: BEGIN
105: SELECT 'Y'
106: INTO l_dummy

Line 113: RAISE FND_API.G_EXC_ERROR;

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
117: NULL;

Line 228: RAISE FND_API.G_EXC_ERROR;

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

Line 238: RAISE FND_API.G_EXC_ERROR;

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
242: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In do_update_fee_assignment procedure: Before call to LNS_FEE_ASSIGNMENTS_PKG.Update_Row');

Line 332: p_fee_assignment_id <> FND_API.G_MISS_NUM

328: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Begin do_delete_fee_assignment procedure');
329: END IF;
330:
331: IF p_fee_assignment_id IS NOT NULL AND
332: p_fee_assignment_id <> FND_API.G_MISS_NUM
333: THEN
334: -- check whether record has been deleted by another user. If not, lock it.
335: BEGIN
336: SELECT loan_id, fee_id, object_version_number

Line 347: RAISE FND_API.G_EXC_ERROR;

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

Line 383: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 387: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 457: IF FND_API.to_Boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) THEN

453: -- standard start of API savepoint
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.

Line 462: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
463:
464: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
465: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In Create_fee_assignment procedure: Before call to do_create_fee_assignment proc');
466: END IF;

Line 507: WHEN FND_API.G_EXC_ERROR THEN

503: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In Create_fee_assignment procedure: After call to do_create_fee_assignment proc');
504: END IF;
505: */
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,

Line 509: x_return_status := FND_API.G_RET_STS_ERROR;

505: */
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);

Line 511: p_encoded => FND_API.G_FALSE,

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:
515: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 515: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

511: p_encoded => FND_API.G_FALSE,
512: p_count => x_msg_count,
513: p_data => x_msg_data);
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,

Line 517: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 519: p_encoded => FND_API.G_FALSE,

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

Line 525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

521: p_data => x_msg_data);
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(

Line 530: p_encoded => FND_API.G_FALSE,

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

Line 593: IF FND_API.to_Boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) THEN

589: -- standard start of API savepoint
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.

Line 598: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
599: /*
600: -- Get old record. Will be used by history package.
601: get_fee_assignment_rec (
602: p_fee_assignment_id => l_fee_assignment_rec.fee_assignment_id,

Line 608: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

604: x_return_status => x_return_status,
605: x_msg_count => x_msg_count,
606: x_msg_data => x_msg_data );
607: */
608: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
609: RAISE FND_API.G_EXC_ERROR;
610: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
612: END IF;

Line 609: RAISE FND_API.G_EXC_ERROR;

605: x_msg_count => x_msg_count,
606: x_msg_data => x_msg_data );
607: */
608: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
609: RAISE FND_API.G_EXC_ERROR;
610: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
612: END IF;
613:

Line 610: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

606: x_msg_data => x_msg_data );
607: */
608: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
609: RAISE FND_API.G_EXC_ERROR;
610: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
612: END IF;
613:
614: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

Line 611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

607: */
608: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
609: RAISE FND_API.G_EXC_ERROR;
610: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
612: END IF;
613:
614: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
615: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In Update_fee_assignment procedure: Before call to do_update_fee_assignment proc');

Line 632: WHEN FND_API.G_EXC_ERROR THEN

628: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In Update_fee_assignment procedure: After call to do_update_fee_assignment proc');
629: END IF;
630:
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,

Line 634: x_return_status := FND_API.G_RET_STS_ERROR;

630:
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);

Line 636: p_encoded => FND_API.G_FALSE,

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:
640: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 640: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

636: p_encoded => FND_API.G_FALSE,
637: p_count => x_msg_count,
638: p_data => x_msg_data);
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,

Line 642: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 644: p_encoded => FND_API.G_FALSE,

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

Line 650: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

646: p_data => x_msg_data);
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(

Line 655: p_encoded => FND_API.G_FALSE,

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

Line 715: IF FND_API.to_Boolean(p_init_msg_list) THEN

711: -- standard start of API savepoint
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.

Line 720: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
721:
722: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
723: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In Delete_fee_assignment procedure: Before call to do_delete_fee_assignment proc');
724: END IF;

Line 737: WHEN FND_API.G_EXC_ERROR THEN

733: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In Delete_fee_assignment procedure: After call to do_delete_fee_assignment proc');
734: END IF;
735:
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,

Line 739: x_return_status := FND_API.G_RET_STS_ERROR;

735:
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);

Line 741: p_encoded => FND_API.G_FALSE,

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:
745: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 745: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

741: p_encoded => FND_API.G_FALSE,
742: p_count => x_msg_count,
743: p_data => x_msg_data);
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,

Line 747: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 749: p_encoded => FND_API.G_FALSE,

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

Line 755: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

751: p_data => x_msg_data);
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(

Line 760: p_encoded => FND_API.G_FALSE,

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