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_TERMS_PUB dependencies on FND_MSG_PUB

Line 98: FND_MSG_PUB.ADD;

94: WHERE term_id = l_term_id;
95:
96: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_DUPLICATE_COLUMN');
97: FND_MESSAGE.SET_TOKEN('COLUMN', 'term_id');
98: FND_MSG_PUB.ADD;
99: RAISE FND_API.G_EXC_ERROR;
100:
101: EXCEPTION
102: WHEN NO_DATA_FOUND THEN

Line 279: FND_MSG_PUB.ADD;

275: )
276: THEN
277: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_RECORD_CHANGED');
278: FND_MESSAGE.SET_TOKEN('TABLE', 'lns_terms');
279: FND_MSG_PUB.ADD;
280: RAISE FND_API.G_EXC_ERROR;
281: END IF;
282:
283:

Line 288: FND_MSG_PUB.ADD;

284: EXCEPTION WHEN NO_DATA_FOUND THEN
285: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
286: FND_MESSAGE.SET_TOKEN('RECORD', 'loan_term_rec');
287: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_loan_term_rec.term_id), 'null'));
288: FND_MSG_PUB.ADD;
289: RAISE FND_API.G_EXC_ERROR;
290: END;
291:
292: -- begin raverma 01-24-2006 add validation for day count

Line 489: FND_MSG_PUB.initialize;

485: SAVEPOINT create_term;
486:
487: -- initialize message list if p_init_msg_list is set to TRUE.
488: IF (p_init_msg_list is not null and FND_API.to_Boolean(p_init_msg_list)) THEN
489: FND_MSG_PUB.initialize;
490: END IF;
491:
492: -- initialize API return status to success.
493: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 510: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

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

Line 517: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

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

Line 526: FND_MSG_PUB.ADD;

522: ROLLBACK TO create_term;
523: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
524: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
525: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
526: FND_MSG_PUB.ADD;
527: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
528: p_count => x_msg_count,
529: p_data => x_msg_data);
530:

Line 527: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

523: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
524: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
525: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
526: FND_MSG_PUB.ADD;
527: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
528: p_count => x_msg_count,
529: p_data => x_msg_data);
530:
531: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

Line 590: FND_MSG_PUB.initialize;

586: SAVEPOINT update_term;
587:
588: -- initialize message list if p_init_msg_list is set to TRUE.
589: IF (p_init_msg_list is not null and FND_API.to_Boolean(p_init_msg_list)) THEN
590: FND_MSG_PUB.initialize;
591: END IF;
592:
593: -- initialize API return status to success.
594: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 626: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

622: EXCEPTION
623: WHEN FND_API.G_EXC_ERROR THEN
624: ROLLBACK TO update_term;
625: x_return_status := FND_API.G_RET_STS_ERROR;
626: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
627: p_count => x_msg_count,
628: p_data => x_msg_data);
629:
630: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 633: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

629:
630: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
631: ROLLBACK TO update_term;
632: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
633: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
634: p_count => x_msg_count,
635: p_data => x_msg_data);
636:
637: WHEN OTHERS THEN

Line 642: FND_MSG_PUB.ADD;

638: ROLLBACK TO update_term;
639: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
640: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
641: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
642: FND_MSG_PUB.ADD;
643: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
644: p_count => x_msg_count,
645: p_data => x_msg_data);
646:

Line 643: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

639: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
640: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
641: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
642: FND_MSG_PUB.ADD;
643: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
644: p_count => x_msg_count,
645: p_data => x_msg_data);
646:
647: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

Line 722: FND_MSG_PUB.ADD;

718: p_loan_term_rec.DAY_COUNT_METHOD <> 'ACTUAL_365' AND
719: p_loan_term_rec.DAY_COUNT_METHOD <> 'ACTUAL_365L'))
720: then
721: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_DAY_COUNT');
722: FND_MSG_PUB.ADD;
723: RAISE FND_API.G_EXC_ERROR;
724: end if;
725:
726: --Standard call to get message count and if count is 1, get message info.

Line 727: FND_MSG_PUB.Count_And_Get(

723: RAISE FND_API.G_EXC_ERROR;
724: end if;
725:
726: --Standard call to get message count and if count is 1, get message info.
727: FND_MSG_PUB.Count_And_Get(
728: p_encoded => FND_API.G_FALSE,
729: p_count => x_msg_count,
730: p_data => x_msg_data );
731:

Line 739: FND_MSG_PUB.Count_And_Get(

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

Line 747: FND_MSG_PUB.Count_And_Get(

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

Line 756: FND_MSG_PUB.ADD;

752: WHEN OTHERS THEN
753: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
754: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_OTHERS_EXCEP' );
755: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
756: FND_MSG_PUB.ADD;
757: FND_MSG_PUB.Count_And_Get(
758: p_encoded => FND_API.G_FALSE,
759: p_count => x_msg_count,
760: p_data => x_msg_data );

Line 757: FND_MSG_PUB.Count_And_Get(

753: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
754: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_OTHERS_EXCEP' );
755: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
756: FND_MSG_PUB.ADD;
757: FND_MSG_PUB.Count_And_Get(
758: p_encoded => FND_API.G_FALSE,
759: p_count => x_msg_count,
760: p_data => x_msg_data );
761:

Line 808: FND_MSG_PUB.initialize;

804: BEGIN
805:
806: --Initialize message list if p_init_msg_list is set to TRUE.
807: IF (p_init_msg_list is not null AND FND_API.to_Boolean(p_init_msg_list)) THEN
808: FND_MSG_PUB.initialize;
809: END IF;
810:
811: --Initialize API return status to success.
812: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 818: FND_MSG_PUB.ADD;

814: --Check whether primary key has been passed in.
815: IF p_term_id IS NULL OR p_term_id = FND_API.G_MISS_NUM THEN
816: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );
817: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'term_id' );
818: FND_MSG_PUB.ADD;
819: RAISE FND_API.G_EXC_ERROR;
820: END IF;
821:
822: x_loan_term_rec.term_id := p_term_id;

Line 886: FND_MSG_PUB.Count_And_Get(

882: X_PENAL_INT_GRACE_DAYS => x_loan_term_rec.PENAL_INT_GRACE_DAYS
883: );
884:
885: --Standard call to get message count and if count is 1, get message info.
886: FND_MSG_PUB.Count_And_Get(
887: p_encoded => FND_API.G_FALSE,
888: p_count => x_msg_count,
889: p_data => x_msg_data );
890:

Line 895: FND_MSG_PUB.Count_And_Get(

891: EXCEPTION
892: WHEN FND_API.G_EXC_ERROR THEN
893: x_return_status := FND_API.G_RET_STS_ERROR;
894:
895: FND_MSG_PUB.Count_And_Get(
896: p_encoded => FND_API.G_FALSE,
897: p_count => x_msg_count,
898: p_data => x_msg_data );
899:

Line 903: FND_MSG_PUB.Count_And_Get(

899:
900: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
901: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
902:
903: FND_MSG_PUB.Count_And_Get(
904: p_encoded => FND_API.G_FALSE,
905: p_count => x_msg_count,
906: p_data => x_msg_data );
907:

Line 912: FND_MSG_PUB.ADD;

908: WHEN OTHERS THEN
909: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
910: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_OTHERS_EXCEP' );
911: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
912: FND_MSG_PUB.ADD;
913: FND_MSG_PUB.Count_And_Get(
914: p_encoded => FND_API.G_FALSE,
915: p_count => x_msg_count,
916: p_data => x_msg_data );

Line 913: FND_MSG_PUB.Count_And_Get(

909: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
910: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_OTHERS_EXCEP' );
911: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
912: FND_MSG_PUB.ADD;
913: FND_MSG_PUB.Count_And_Get(
914: p_encoded => FND_API.G_FALSE,
915: p_count => x_msg_count,
916: p_data => x_msg_data );
917:

Line 1023: FND_MSG_PUB.Add;

1019:
1020: --dbms_output.put_line('reamortize ' || l_reamortize_overpay);
1021: if l_reamortize_overpay = 'Y' then
1022: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_REAMORTIZE');
1023: FND_MSG_PUB.Add;
1024: RAISE FND_API.G_EXC_ERROR;
1025: end if;
1026:
1027: /* removing this validation as per conversation with ravi on 11-3-2004

Line 1043: FND_MSG_PUB.Add;

1039: loop
1040: if l_rate_schedule(k).interest_only_flag = 'Y' and l_interest_only = 'N' then
1041: dbms_output.put_line('output non continuous');
1042: FND_MESSAGE.SET_NAME('LNS', 'LNS_INTEREST_ONLY_BREAK');
1043: FND_MSG_PUB.Add;
1044: RAISE FND_API.G_EXC_ERROR;
1045: end if;
1046: l_interest_only := l_rate_schedule(k).interest_only_flag;
1047:

Line 1053: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

1049: end if;
1050: */
1051: end if;
1052:
1053: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1054:
1055: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - End');
1056:
1057: