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.

[Home] [Help]

APPS.LNS_COND_ASSIGNMENT_PUB dependencies on FND_API

Line 98: l_COND_ASSIGNMENT_id <> FND_API.G_MISS_NUM

94: END IF;
95:
96: -- if primary key value is passed, check for uniqueness.
97: IF l_COND_ASSIGNMENT_id IS NOT NULL AND
98: l_COND_ASSIGNMENT_id <> FND_API.G_MISS_NUM
99: THEN
100: BEGIN
101: SELECT 'Y'
102: INTO l_dummy

Line 109: RAISE FND_API.G_EXC_ERROR;

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
112: WHEN NO_DATA_FOUND THEN
113: NULL;

Line 219: RAISE FND_API.G_EXC_ERROR;

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

Line 229: RAISE FND_API.G_EXC_ERROR;

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:
232: Set_Defaults(p_COND_ASSIGNMENT_rec);
233:

Line 318: p_COND_ASSIGNMENT_id <> FND_API.G_MISS_NUM

314: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Begin do_delete_COND_ASSIGNMENT procedure');
315: END IF;
316:
317: IF p_COND_ASSIGNMENT_id IS NOT NULL AND
318: p_COND_ASSIGNMENT_id <> FND_API.G_MISS_NUM
319: THEN
320: -- check whether record has been deleted by another user. If not, lock it.
321: BEGIN
322: SELECT loan_id, object_version_number

Line 334: RAISE FND_API.G_EXC_ERROR;

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;
337:
338:

Line 357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

353: WHERE COND_ASSIGNMENT_ID = p_cond_assignment_id;
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;

Line 361: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:
364: /*
365: --Call to table-handler

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

447: -- standard start of API savepoint
448: SAVEPOINT create_COND_ASSIGNMENT;
449:
450: -- initialize message list if p_init_msg_list is set to TRUE.
451: IF FND_API.to_Boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) THEN
452: FND_MSG_PUB.initialize;
453: END IF;
454:
455: -- initialize API return status to success.

Line 456: x_return_status := FND_API.G_RET_STS_SUCCESS;

452: FND_MSG_PUB.initialize;
453: END IF;
454:
455: -- initialize API return status to success.
456: x_return_status := FND_API.G_RET_STS_SUCCESS;
457:
458: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
459: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In Create_COND_ASSIGNMENT procedure: Before call to do_create_COND_ASSIGNMENT proc');
460: END IF;

Line 474: WHEN FND_API.G_EXC_ERROR THEN

470: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In Create_COND_ASSIGNMENT procedure: After call to do_create_COND_ASSIGNMENT proc');
471: END IF;
472:
473: EXCEPTION
474: WHEN FND_API.G_EXC_ERROR THEN
475: ROLLBACK TO create_COND_ASSIGNMENT;
476: x_return_status := FND_API.G_RET_STS_ERROR;
477: FND_MSG_PUB.Count_And_Get(
478: p_encoded => FND_API.G_FALSE,

Line 476: x_return_status := FND_API.G_RET_STS_ERROR;

472:
473: EXCEPTION
474: WHEN FND_API.G_EXC_ERROR THEN
475: ROLLBACK TO create_COND_ASSIGNMENT;
476: x_return_status := FND_API.G_RET_STS_ERROR;
477: FND_MSG_PUB.Count_And_Get(
478: p_encoded => FND_API.G_FALSE,
479: p_count => x_msg_count,
480: p_data => x_msg_data);

Line 478: p_encoded => FND_API.G_FALSE,

474: WHEN FND_API.G_EXC_ERROR THEN
475: ROLLBACK TO create_COND_ASSIGNMENT;
476: x_return_status := FND_API.G_RET_STS_ERROR;
477: FND_MSG_PUB.Count_And_Get(
478: p_encoded => FND_API.G_FALSE,
479: p_count => x_msg_count,
480: p_data => x_msg_data);
481:
482: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 482: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

478: p_encoded => FND_API.G_FALSE,
479: p_count => x_msg_count,
480: p_data => x_msg_data);
481:
482: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
483: ROLLBACK TO create_COND_ASSIGNMENT;
484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
485: FND_MSG_PUB.Count_And_Get(
486: p_encoded => FND_API.G_FALSE,

Line 484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

480: p_data => x_msg_data);
481:
482: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
483: ROLLBACK TO create_COND_ASSIGNMENT;
484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
485: FND_MSG_PUB.Count_And_Get(
486: p_encoded => FND_API.G_FALSE,
487: p_count => x_msg_count,
488: p_data => x_msg_data);

Line 486: p_encoded => FND_API.G_FALSE,

482: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
483: ROLLBACK TO create_COND_ASSIGNMENT;
484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
485: FND_MSG_PUB.Count_And_Get(
486: p_encoded => FND_API.G_FALSE,
487: p_count => x_msg_count,
488: p_data => x_msg_data);
489:
490: WHEN OTHERS THEN

Line 492: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 497: p_encoded => FND_API.G_FALSE,

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,
499: p_data => x_msg_data);
500:
501: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

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

556: -- standard start of API savepoint
557: SAVEPOINT update_COND_ASSIGNMENT;
558:
559: -- initialize message list if p_init_msg_list is set to TRUE.
560: IF FND_API.to_Boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) THEN
561: FND_MSG_PUB.initialize;
562: END IF;
563:
564: -- initialize API return status to success.

Line 565: x_return_status := FND_API.G_RET_STS_SUCCESS;

561: FND_MSG_PUB.initialize;
562: END IF;
563:
564: -- initialize API return status to success.
565: x_return_status := FND_API.G_RET_STS_SUCCESS;
566: /*
567: -- Get old record. Will be used by history package.
568: get_COND_ASSIGNMENT_rec (
569: p_COND_ASSIGNMENT_id => l_COND_ASSIGNMENT_rec.assignment_id,

Line 575: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

571: x_return_status => x_return_status,
572: x_msg_count => x_msg_count,
573: x_msg_data => x_msg_data );
574: */
575: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
576: RAISE FND_API.G_EXC_ERROR;
577: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
578: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
579: END IF;

Line 576: RAISE FND_API.G_EXC_ERROR;

572: x_msg_count => x_msg_count,
573: x_msg_data => x_msg_data );
574: */
575: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
576: RAISE FND_API.G_EXC_ERROR;
577: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
578: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
579: END IF;
580:

Line 577: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

573: x_msg_data => x_msg_data );
574: */
575: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
576: RAISE FND_API.G_EXC_ERROR;
577: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
578: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
579: END IF;
580:
581: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 578: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

574: */
575: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
576: RAISE FND_API.G_EXC_ERROR;
577: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
578: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
579: END IF;
580:
581: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
582: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In Update_COND_ASSIGNMENT procedure: Before call to do_update_COND_ASSIGNMENT proc');

Line 597: WHEN FND_API.G_EXC_ERROR THEN

593: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In Update_COND_ASSIGNMENT procedure: After call to do_update_COND_ASSIGNMENT proc');
594: END IF;
595:
596: EXCEPTION
597: WHEN FND_API.G_EXC_ERROR THEN
598: ROLLBACK TO update_COND_ASSIGNMENT;
599: x_return_status := FND_API.G_RET_STS_ERROR;
600: FND_MSG_PUB.Count_And_Get(
601: p_encoded => FND_API.G_FALSE,

Line 599: x_return_status := FND_API.G_RET_STS_ERROR;

595:
596: EXCEPTION
597: WHEN FND_API.G_EXC_ERROR THEN
598: ROLLBACK TO update_COND_ASSIGNMENT;
599: x_return_status := FND_API.G_RET_STS_ERROR;
600: FND_MSG_PUB.Count_And_Get(
601: p_encoded => FND_API.G_FALSE,
602: p_count => x_msg_count,
603: p_data => x_msg_data);

Line 601: p_encoded => FND_API.G_FALSE,

597: WHEN FND_API.G_EXC_ERROR THEN
598: ROLLBACK TO update_COND_ASSIGNMENT;
599: x_return_status := FND_API.G_RET_STS_ERROR;
600: FND_MSG_PUB.Count_And_Get(
601: p_encoded => FND_API.G_FALSE,
602: p_count => x_msg_count,
603: p_data => x_msg_data);
604:
605: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 605: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

601: p_encoded => FND_API.G_FALSE,
602: p_count => x_msg_count,
603: p_data => x_msg_data);
604:
605: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
606: ROLLBACK TO update_COND_ASSIGNMENT;
607: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
608: FND_MSG_PUB.Count_And_Get(
609: p_encoded => FND_API.G_FALSE,

Line 607: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

603: p_data => x_msg_data);
604:
605: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
606: ROLLBACK TO update_COND_ASSIGNMENT;
607: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
608: FND_MSG_PUB.Count_And_Get(
609: p_encoded => FND_API.G_FALSE,
610: p_count => x_msg_count,
611: p_data => x_msg_data);

Line 609: p_encoded => FND_API.G_FALSE,

605: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
606: ROLLBACK TO update_COND_ASSIGNMENT;
607: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
608: FND_MSG_PUB.Count_And_Get(
609: p_encoded => FND_API.G_FALSE,
610: p_count => x_msg_count,
611: p_data => x_msg_data);
612:
613: WHEN OTHERS THEN

Line 615: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 620: p_encoded => FND_API.G_FALSE,

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,
622: p_data => x_msg_data);
623:
624: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

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

676: -- standard start of API savepoint
677: SAVEPOINT delete_COND_ASSIGNMENT;
678:
679: -- initialize message list if p_init_msg_list is set to TRUE.
680: IF FND_API.to_Boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) THEN
681: FND_MSG_PUB.initialize;
682: END IF;
683:
684: -- initialize API return status to success.

Line 685: x_return_status := FND_API.G_RET_STS_SUCCESS;

681: FND_MSG_PUB.initialize;
682: END IF;
683:
684: -- initialize API return status to success.
685: x_return_status := FND_API.G_RET_STS_SUCCESS;
686:
687: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
688: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In Delete_COND_ASSIGNMENT procedure: Before call to do_delete_COND_ASSIGNMENT proc');
689: END IF;

Line 702: WHEN FND_API.G_EXC_ERROR THEN

698: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In Delete_COND_ASSIGNMENT procedure: After call to do_delete_COND_ASSIGNMENT proc');
699: END IF;
700:
701: EXCEPTION
702: WHEN FND_API.G_EXC_ERROR THEN
703: ROLLBACK TO delete_COND_ASSIGNMENT;
704: x_return_status := FND_API.G_RET_STS_ERROR;
705: FND_MSG_PUB.Count_And_Get(
706: p_encoded => FND_API.G_FALSE,

Line 704: x_return_status := FND_API.G_RET_STS_ERROR;

700:
701: EXCEPTION
702: WHEN FND_API.G_EXC_ERROR THEN
703: ROLLBACK TO delete_COND_ASSIGNMENT;
704: x_return_status := FND_API.G_RET_STS_ERROR;
705: FND_MSG_PUB.Count_And_Get(
706: p_encoded => FND_API.G_FALSE,
707: p_count => x_msg_count,
708: p_data => x_msg_data);

Line 706: p_encoded => FND_API.G_FALSE,

702: WHEN FND_API.G_EXC_ERROR THEN
703: ROLLBACK TO delete_COND_ASSIGNMENT;
704: x_return_status := FND_API.G_RET_STS_ERROR;
705: FND_MSG_PUB.Count_And_Get(
706: p_encoded => FND_API.G_FALSE,
707: p_count => x_msg_count,
708: p_data => x_msg_data);
709:
710: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 710: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

706: p_encoded => FND_API.G_FALSE,
707: p_count => x_msg_count,
708: p_data => x_msg_data);
709:
710: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
711: ROLLBACK TO delete_COND_ASSIGNMENT;
712: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
713: FND_MSG_PUB.Count_And_Get(
714: p_encoded => FND_API.G_FALSE,

Line 712: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

708: p_data => x_msg_data);
709:
710: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
711: ROLLBACK TO delete_COND_ASSIGNMENT;
712: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
713: FND_MSG_PUB.Count_And_Get(
714: p_encoded => FND_API.G_FALSE,
715: p_count => x_msg_count,
716: p_data => x_msg_data);

Line 714: p_encoded => FND_API.G_FALSE,

710: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
711: ROLLBACK TO delete_COND_ASSIGNMENT;
712: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
713: FND_MSG_PUB.Count_And_Get(
714: p_encoded => FND_API.G_FALSE,
715: p_count => x_msg_count,
716: p_data => x_msg_data);
717:
718: WHEN OTHERS THEN

Line 720: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 725: p_encoded => FND_API.G_FALSE,

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,
727: p_data => x_msg_data);
728:
729: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN