APPS.LNS_FUNDING_PUB dependencies on FND_MESSAGE

Line 556: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );

552:
553: if P_DISB_HEADER_REC.LOAN_ID is null then
554:
555: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Loan ID is missing');
556: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );
557: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'loan_id' );
558: FND_MSG_PUB.ADD;
559: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
560: RAISE FND_API.G_EXC_ERROR;

Line 557: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'loan_id' );

553: if P_DISB_HEADER_REC.LOAN_ID is null then
554:
555: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Loan ID is missing');
556: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );
557: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'loan_id' );
558: FND_MSG_PUB.ADD;
559: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
560: RAISE FND_API.G_EXC_ERROR;
561:

Line 733: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );

729:
730: if P_DISB_HEADER_REC.DISB_HEADER_ID is null then
731:
732: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Disbursement header ID is missing');
733: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );
734: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'disb_header_id' );
735: FND_MSG_PUB.ADD;
736: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
737: RAISE FND_API.G_EXC_ERROR;

Line 734: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'disb_header_id' );

730: if P_DISB_HEADER_REC.DISB_HEADER_ID is null then
731:
732: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Disbursement header ID is missing');
733: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );
734: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'disb_header_id' );
735: FND_MSG_PUB.ADD;
736: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
737: RAISE FND_API.G_EXC_ERROR;
738:

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

744:
745: if disb_head_cur%NOTFOUND then
746:
747: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'No disbursement header record found');
748: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
749: FND_MESSAGE.SET_TOKEN('RECORD', 'disbursement header');
750: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(P_DISB_HEADER_REC.DISB_HEADER_ID), 'null'));
751: FND_MSG_PUB.ADD;
752: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

Line 749: FND_MESSAGE.SET_TOKEN('RECORD', 'disbursement header');

745: if disb_head_cur%NOTFOUND then
746:
747: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'No disbursement header record found');
748: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
749: FND_MESSAGE.SET_TOKEN('RECORD', 'disbursement header');
750: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(P_DISB_HEADER_REC.DISB_HEADER_ID), 'null'));
751: FND_MSG_PUB.ADD;
752: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
753: RAISE FND_API.G_EXC_ERROR;

Line 750: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(P_DISB_HEADER_REC.DISB_HEADER_ID), 'null'));

746:
747: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'No disbursement header record found');
748: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
749: FND_MESSAGE.SET_TOKEN('RECORD', 'disbursement header');
750: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(P_DISB_HEADER_REC.DISB_HEADER_ID), 'null'));
751: FND_MSG_PUB.ADD;
752: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
753: RAISE FND_API.G_EXC_ERROR;
754:

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

758:
759: if l_disb_header_version <> P_DISB_HEADER_REC.OBJECT_VERSION_NUMBER then
760:
761: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Disbursement header record has already been changed');
762: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_RECORD_CHANGED');
763: FND_MESSAGE.SET_TOKEN('TABLE', 'LNS_DISB_HEADERS');
764: FND_MSG_PUB.ADD;
765: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
766: RAISE FND_API.G_EXC_ERROR;

Line 763: FND_MESSAGE.SET_TOKEN('TABLE', 'LNS_DISB_HEADERS');

759: if l_disb_header_version <> P_DISB_HEADER_REC.OBJECT_VERSION_NUMBER then
760:
761: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Disbursement header record has already been changed');
762: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_RECORD_CHANGED');
763: FND_MESSAGE.SET_TOKEN('TABLE', 'LNS_DISB_HEADERS');
764: FND_MSG_PUB.ADD;
765: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
766: RAISE FND_API.G_EXC_ERROR;
767:

Line 935: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );

931:
932: if P_DISB_HEADER_ID is null then
933:
934: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Disbursement header ID is missing');
935: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );
936: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'disb_header_id' );
937: FND_MSG_PUB.ADD;
938: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
939: RAISE FND_API.G_EXC_ERROR;

Line 936: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'disb_header_id' );

932: if P_DISB_HEADER_ID is null then
933:
934: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Disbursement header ID is missing');
935: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );
936: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'disb_header_id' );
937: FND_MSG_PUB.ADD;
938: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
939: RAISE FND_API.G_EXC_ERROR;
940:

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

946:
947: if disb_head_cur%NOTFOUND then
948:
949: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'No disbursement header record found');
950: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
951: FND_MESSAGE.SET_TOKEN('RECORD', 'disbursement header');
952: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(P_DISB_HEADER_ID), 'null'));
953: FND_MSG_PUB.ADD;
954: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

Line 951: FND_MESSAGE.SET_TOKEN('RECORD', 'disbursement header');

947: if disb_head_cur%NOTFOUND then
948:
949: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'No disbursement header record found');
950: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
951: FND_MESSAGE.SET_TOKEN('RECORD', 'disbursement header');
952: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(P_DISB_HEADER_ID), 'null'));
953: FND_MSG_PUB.ADD;
954: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
955: RAISE FND_API.G_EXC_ERROR;

Line 952: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(P_DISB_HEADER_ID), 'null'));

948:
949: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'No disbursement header record found');
950: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
951: FND_MESSAGE.SET_TOKEN('RECORD', 'disbursement header');
952: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(P_DISB_HEADER_ID), 'null'));
953: FND_MSG_PUB.ADD;
954: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
955: RAISE FND_API.G_EXC_ERROR;
956:

Line 964: FND_MESSAGE.SET_NAME('LNS', 'LNS_CANT_DEL_DISB_HDR');

960:
961: if l_status is not null then
962:
963: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Cannot delete disbursement header. It has already been processed.');
964: FND_MESSAGE.SET_NAME('LNS', 'LNS_CANT_DEL_DISB_HDR');
965: FND_MSG_PUB.ADD;
966: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
967: RAISE FND_API.G_EXC_ERROR;
968:

Line 1150: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );

1146:
1147: if P_DISB_LINE_REC.DISB_HEADER_ID is null then
1148:
1149: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Disbursement header ID is missing');
1150: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );
1151: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'disb_header_id' );
1152: FND_MSG_PUB.ADD;
1153: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
1154: RAISE FND_API.G_EXC_ERROR;

Line 1151: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'disb_header_id' );

1147: if P_DISB_LINE_REC.DISB_HEADER_ID is null then
1148:
1149: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Disbursement header ID is missing');
1150: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );
1151: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'disb_header_id' );
1152: FND_MSG_PUB.ADD;
1153: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
1154: RAISE FND_API.G_EXC_ERROR;
1155:

Line 1161: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_ENTER_PAYEE_PERC');

1157:
1158: if P_DISB_LINE_REC.LINE_PERCENT is null then
1159:
1160: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Line percent is missing');
1161: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_ENTER_PAYEE_PERC');
1162: FND_MSG_PUB.ADD;
1163: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
1164: RAISE FND_API.G_EXC_ERROR;
1165:

Line 1171: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_ENTER_PAYEE' );

1167:
1168: if P_DISB_LINE_REC.PAYEE_PARTY_ID is null then
1169:
1170: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Payee party ID is missing');
1171: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_ENTER_PAYEE' );
1172: FND_MSG_PUB.ADD;
1173: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
1174: RAISE FND_API.G_EXC_ERROR;
1175:

Line 1354: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );

1350:
1351: if P_DISB_LINE_REC.DISB_LINE_ID is null then
1352:
1353: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Disbursement line ID is missing');
1354: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );
1355: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'disb_line_id' );
1356: FND_MSG_PUB.ADD;
1357: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
1358: RAISE FND_API.G_EXC_ERROR;

Line 1355: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'disb_line_id' );

1351: if P_DISB_LINE_REC.DISB_LINE_ID is null then
1352:
1353: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Disbursement line ID is missing');
1354: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );
1355: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'disb_line_id' );
1356: FND_MSG_PUB.ADD;
1357: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
1358: RAISE FND_API.G_EXC_ERROR;
1359:

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

1365:
1366: if disb_line_cur%NOTFOUND then
1367:
1368: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'No disbursement line record found');
1369: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
1370: FND_MESSAGE.SET_TOKEN('RECORD', 'disbursement line');
1371: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(P_DISB_LINE_REC.DISB_LINE_ID), 'null'));
1372: FND_MSG_PUB.ADD;
1373: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

Line 1370: FND_MESSAGE.SET_TOKEN('RECORD', 'disbursement line');

1366: if disb_line_cur%NOTFOUND then
1367:
1368: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'No disbursement line record found');
1369: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
1370: FND_MESSAGE.SET_TOKEN('RECORD', 'disbursement line');
1371: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(P_DISB_LINE_REC.DISB_LINE_ID), 'null'));
1372: FND_MSG_PUB.ADD;
1373: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
1374: RAISE FND_API.G_EXC_ERROR;

Line 1371: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(P_DISB_LINE_REC.DISB_LINE_ID), 'null'));

1367:
1368: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'No disbursement line record found');
1369: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
1370: FND_MESSAGE.SET_TOKEN('RECORD', 'disbursement line');
1371: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(P_DISB_LINE_REC.DISB_LINE_ID), 'null'));
1372: FND_MSG_PUB.ADD;
1373: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
1374: RAISE FND_API.G_EXC_ERROR;
1375:

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

1379:
1380: if l_disb_line_version <> P_DISB_LINE_REC.OBJECT_VERSION_NUMBER then
1381:
1382: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Disbursement line record has already been changed');
1383: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_RECORD_CHANGED');
1384: FND_MESSAGE.SET_TOKEN('TABLE', 'LNS_DISB_LINES');
1385: FND_MSG_PUB.ADD;
1386: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
1387: RAISE FND_API.G_EXC_ERROR;

Line 1384: FND_MESSAGE.SET_TOKEN('TABLE', 'LNS_DISB_LINES');

1380: if l_disb_line_version <> P_DISB_LINE_REC.OBJECT_VERSION_NUMBER then
1381:
1382: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Disbursement line record has already been changed');
1383: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_RECORD_CHANGED');
1384: FND_MESSAGE.SET_TOKEN('TABLE', 'LNS_DISB_LINES');
1385: FND_MSG_PUB.ADD;
1386: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
1387: RAISE FND_API.G_EXC_ERROR;
1388:

Line 1554: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );

1550:
1551: if P_DISB_LINE_ID is null then
1552:
1553: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Disbursement line ID is missing');
1554: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );
1555: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'disb_line_id' );
1556: FND_MSG_PUB.ADD;
1557: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
1558: RAISE FND_API.G_EXC_ERROR;

Line 1555: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'disb_line_id' );

1551: if P_DISB_LINE_ID is null then
1552:
1553: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Disbursement line ID is missing');
1554: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );
1555: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'disb_line_id' );
1556: FND_MSG_PUB.ADD;
1557: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
1558: RAISE FND_API.G_EXC_ERROR;
1559:

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

1565:
1566: if disb_head_cur%NOTFOUND then
1567:
1568: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'No disbursement line record found');
1569: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
1570: FND_MESSAGE.SET_TOKEN('RECORD', 'disbursement line');
1571: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(P_DISB_LINE_ID), 'null'));
1572: FND_MSG_PUB.ADD;
1573: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

Line 1570: FND_MESSAGE.SET_TOKEN('RECORD', 'disbursement line');

1566: if disb_head_cur%NOTFOUND then
1567:
1568: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'No disbursement line record found');
1569: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
1570: FND_MESSAGE.SET_TOKEN('RECORD', 'disbursement line');
1571: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(P_DISB_LINE_ID), 'null'));
1572: FND_MSG_PUB.ADD;
1573: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
1574: RAISE FND_API.G_EXC_ERROR;

Line 1571: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(P_DISB_LINE_ID), 'null'));

1567:
1568: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'No disbursement line record found');
1569: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
1570: FND_MESSAGE.SET_TOKEN('RECORD', 'disbursement line');
1571: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(P_DISB_LINE_ID), 'null'));
1572: FND_MSG_PUB.ADD;
1573: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
1574: RAISE FND_API.G_EXC_ERROR;
1575:

Line 1583: FND_MESSAGE.SET_NAME('LNS', 'LNS_CANT_DEL_DISB_LN');

1579:
1580: if l_status is not null then
1581:
1582: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Cannot delete disbursement line. It has already been processed.');
1583: FND_MESSAGE.SET_NAME('LNS', 'LNS_CANT_DEL_DISB_LN');
1584: FND_MSG_PUB.ADD;
1585: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
1586: RAISE FND_API.G_EXC_ERROR;
1587:

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

1757: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_Ext_Payee_Create_Tab(' || l_Count || ').Payee_Creation_Msg: ' || l_Ext_Payee_Create_Tab(l_Count).Payee_Creation_Msg);
1758: --karamach bug5226980
1759: l_return_status := l_Ext_Payee_Create_Tab(l_Count).Payee_Creation_Status;
1760: if (l_Ext_Payee_Create_Tab(l_Count).Payee_Creation_Status = 'E') then
1761: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
1762: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed API call: IBY_DISBURSEMENT_SETUP_PUB.Create_External_Payee' || ' Payee_Creation_Msg: ' || l_Ext_Payee_Create_Tab(l_Count).Payee_Creation_Msg);
1763: FND_MSG_PUB.ADD;
1764: RAISE FND_API.G_EXC_ERROR;
1765: end if;

Line 1762: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed API call: IBY_DISBURSEMENT_SETUP_PUB.Create_External_Payee' || ' Payee_Creation_Msg: ' || l_Ext_Payee_Create_Tab(l_Count).Payee_Creation_Msg);

1758: --karamach bug5226980
1759: l_return_status := l_Ext_Payee_Create_Tab(l_Count).Payee_Creation_Status;
1760: if (l_Ext_Payee_Create_Tab(l_Count).Payee_Creation_Status = 'E') then
1761: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
1762: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed API call: IBY_DISBURSEMENT_SETUP_PUB.Create_External_Payee' || ' Payee_Creation_Msg: ' || l_Ext_Payee_Create_Tab(l_Count).Payee_Creation_Msg);
1763: FND_MSG_PUB.ADD;
1764: RAISE FND_API.G_EXC_ERROR;
1765: end if;
1766: END LOOP;

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

1765: end if;
1766: END LOOP;
1767:
1768: if l_return_status = 'E' then
1769: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
1770: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed API call: IBY_DISBURSEMENT_SETUP_PUB.Create_External_Payee');
1771: FND_MSG_PUB.ADD;
1772: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1773: p_count => l_msg_count,

Line 1770: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed API call: IBY_DISBURSEMENT_SETUP_PUB.Create_External_Payee');

1766: END LOOP;
1767:
1768: if l_return_status = 'E' then
1769: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
1770: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed API call: IBY_DISBURSEMENT_SETUP_PUB.Create_External_Payee');
1771: FND_MSG_PUB.ADD;
1772: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1773: p_count => l_msg_count,
1774: p_data => l_msg_data);

Line 1956: FND_MESSAGE.SET_NAME('LNS', 'LNS_SUBM_APPR_AND_DISB');

1952: l_loan_maturity_date;
1953:
1954: if disb_headers_cur%NOTFOUND and l_count = 0 then
1955:
1956: FND_MESSAGE.SET_NAME('LNS', 'LNS_SUBM_APPR_AND_DISB');
1957: FND_MSG_PUB.ADD;
1958: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
1959:
1960: -- LogMessage(FND_LOG.LEVEL_STATEMENT, 'ERROR: Disbursement schedule is not found');

Line 1961: FND_MESSAGE.SET_NAME('LNS', 'LNS_CREATE_DISB_SCHED');

1957: FND_MSG_PUB.ADD;
1958: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
1959:
1960: -- LogMessage(FND_LOG.LEVEL_STATEMENT, 'ERROR: Disbursement schedule is not found');
1961: FND_MESSAGE.SET_NAME('LNS', 'LNS_CREATE_DISB_SCHED');
1962: FND_MSG_PUB.ADD;
1963: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
1964: RAISE FND_API.G_EXC_ERROR;
1965:

Line 1989: FND_MESSAGE.SET_NAME('LNS', 'LNS_SUBM_APPR_AND_DISB');

1985: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Open loan maturity date: ' || l_loan_maturity_date);
1986:
1987: if l_DISB_HEADER_REC.LOAN_ID is null then
1988:
1989: FND_MESSAGE.SET_NAME('LNS', 'LNS_SUBM_APPR_AND_DISB');
1990: FND_MSG_PUB.ADD;
1991: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
1992:
1993: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Loan ID is missing');

Line 1994: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );

1990: FND_MSG_PUB.ADD;
1991: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
1992:
1993: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Loan ID is missing');
1994: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );
1995: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'loan id' );
1996: FND_MSG_PUB.ADD;
1997: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
1998: RAISE FND_API.G_EXC_ERROR;

Line 1995: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'loan id' );

1991: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
1992:
1993: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Loan ID is missing');
1994: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );
1995: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'loan id' );
1996: FND_MSG_PUB.ADD;
1997: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
1998: RAISE FND_API.G_EXC_ERROR;
1999:

Line 2004: FND_MESSAGE.SET_NAME('LNS', 'LNS_SUBM_APPR_AND_DISB');

2000: end if;
2001:
2002: if l_DISB_HEADER_REC.ACTIVITY_CODE is null then
2003:
2004: FND_MESSAGE.SET_NAME('LNS', 'LNS_SUBM_APPR_AND_DISB');
2005: FND_MSG_PUB.ADD;
2006: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2007:
2008: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Activity code is missing');

Line 2009: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_ENTER_DISB_ACTIV' );

2005: FND_MSG_PUB.ADD;
2006: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2007:
2008: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Activity code is missing');
2009: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_ENTER_DISB_ACTIV' );
2010: FND_MSG_PUB.ADD;
2011: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2012: RAISE FND_API.G_EXC_ERROR;
2013:

Line 2018: FND_MESSAGE.SET_NAME('LNS', 'LNS_SUBM_APPR_AND_DISB');

2014: end if;
2015:
2016: if l_DISB_HEADER_REC.HEADER_PERCENT is null or l_DISB_HEADER_REC.HEADER_AMOUNT is null then
2017:
2018: FND_MESSAGE.SET_NAME('LNS', 'LNS_SUBM_APPR_AND_DISB');
2019: FND_MSG_PUB.ADD;
2020: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2021:
2022: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Disbursement percent is missing');

Line 2023: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_ENTER_DISB_PERC' );

2019: FND_MSG_PUB.ADD;
2020: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2021:
2022: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Disbursement percent is missing');
2023: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_ENTER_DISB_PERC' );
2024: FND_MSG_PUB.ADD;
2025: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2026: RAISE FND_API.G_EXC_ERROR;
2027:

Line 2032: FND_MESSAGE.SET_NAME('LNS', 'LNS_SUBM_APPR_AND_DISB');

2028: end if;
2029:
2030: if l_DISB_HEADER_REC.TARGET_DATE is null then
2031:
2032: FND_MESSAGE.SET_NAME('LNS', 'LNS_SUBM_APPR_AND_DISB');
2033: FND_MSG_PUB.ADD;
2034: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2035:
2036: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Target date is missing');

Line 2037: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_ENTER_TARGET_DATE' );

2033: FND_MSG_PUB.ADD;
2034: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2035:
2036: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Target date is missing');
2037: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_ENTER_TARGET_DATE' );
2038: FND_MSG_PUB.ADD;
2039: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2040: RAISE FND_API.G_EXC_ERROR;
2041:

Line 2047: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_DISB_TARGET_DATE_ERR' );

2043:
2044: if trunc(l_DISB_HEADER_REC.TARGET_DATE) < trunc(l_loan_start_date) then
2045:
2046: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Target date must be later that start date');
2047: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_DISB_TARGET_DATE_ERR' );
2048: FND_MSG_PUB.ADD;
2049: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2050: RAISE FND_API.G_EXC_ERROR;
2051:

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

2077:
2078: if disb_lines_cur%NOTFOUND and l_count1 = 0 then
2079:
2080: -- LogMessage(FND_LOG.LEVEL_STATEMENT, 'ERROR: Disbursement lines are not found');
2081: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
2082: FND_MESSAGE.SET_TOKEN('RECORD', 'disbursement line record');
2083: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(l_DISB_HEADER_REC.DISB_HEADER_ID), 'null'));
2084: FND_MSG_PUB.ADD;
2085: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

Line 2082: FND_MESSAGE.SET_TOKEN('RECORD', 'disbursement line record');

2078: if disb_lines_cur%NOTFOUND and l_count1 = 0 then
2079:
2080: -- LogMessage(FND_LOG.LEVEL_STATEMENT, 'ERROR: Disbursement lines are not found');
2081: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
2082: FND_MESSAGE.SET_TOKEN('RECORD', 'disbursement line record');
2083: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(l_DISB_HEADER_REC.DISB_HEADER_ID), 'null'));
2084: FND_MSG_PUB.ADD;
2085: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2086: RAISE FND_API.G_EXC_ERROR;

Line 2083: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(l_DISB_HEADER_REC.DISB_HEADER_ID), 'null'));

2079:
2080: -- LogMessage(FND_LOG.LEVEL_STATEMENT, 'ERROR: Disbursement lines are not found');
2081: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
2082: FND_MESSAGE.SET_TOKEN('RECORD', 'disbursement line record');
2083: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(l_DISB_HEADER_REC.DISB_HEADER_ID), 'null'));
2084: FND_MSG_PUB.ADD;
2085: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2086: RAISE FND_API.G_EXC_ERROR;
2087:

Line 2108: FND_MESSAGE.SET_NAME('LNS', 'LNS_SUBM_APPR_AND_DISB');

2104: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Due date: ' || l_due_date);
2105:
2106: if l_DISB_LINE_REC.DISB_HEADER_ID is null then
2107:
2108: FND_MESSAGE.SET_NAME('LNS', 'LNS_SUBM_APPR_AND_DISB');
2109: FND_MSG_PUB.ADD;
2110: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2111:
2112: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Disbursement header is missing');

Line 2113: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );

2109: FND_MSG_PUB.ADD;
2110: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2111:
2112: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Disbursement header is missing');
2113: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );
2114: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'disb_header_id' );
2115: FND_MSG_PUB.ADD;
2116: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2117: RAISE FND_API.G_EXC_ERROR;

Line 2114: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'disb_header_id' );

2110: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2111:
2112: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Disbursement header is missing');
2113: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );
2114: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'disb_header_id' );
2115: FND_MSG_PUB.ADD;
2116: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2117: RAISE FND_API.G_EXC_ERROR;
2118:

Line 2123: FND_MESSAGE.SET_NAME('LNS', 'LNS_SUBM_APPR_AND_DISB');

2119: end if;
2120:
2121: if l_DISB_LINE_REC.LINE_PERCENT is null or l_DISB_LINE_REC.LINE_AMOUNT is null then
2122:
2123: FND_MESSAGE.SET_NAME('LNS', 'LNS_SUBM_APPR_AND_DISB');
2124: FND_MSG_PUB.ADD;
2125: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2126:
2127: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Line percent is missing');

Line 2128: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_ENTER_PAYEE_PERC' );

2124: FND_MSG_PUB.ADD;
2125: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2126:
2127: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Line percent is missing');
2128: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_ENTER_PAYEE_PERC' );
2129: FND_MSG_PUB.ADD;
2130: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2131: RAISE FND_API.G_EXC_ERROR;
2132:

Line 2137: FND_MESSAGE.SET_NAME('LNS', 'LNS_SUBM_APPR_AND_DISB');

2133: end if;
2134:
2135: if l_DISB_LINE_REC.PAYEE_PARTY_ID is null then
2136:
2137: FND_MESSAGE.SET_NAME('LNS', 'LNS_SUBM_APPR_AND_DISB');
2138: FND_MSG_PUB.ADD;
2139: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2140:
2141: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Payee party ID is missing');

Line 2142: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_ENTER_PAYEE' );

2138: FND_MSG_PUB.ADD;
2139: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2140:
2141: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Payee party ID is missing');
2142: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_ENTER_PAYEE' );
2143: FND_MSG_PUB.ADD;
2144: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2145: RAISE FND_API.G_EXC_ERROR;
2146:

Line 2156: FND_MESSAGE.SET_NAME('LNS', 'LNS_SUBM_APPR_AND_DISB');

2152:
2153: -- if no record exists - error; otherwise proceed
2154: if party_site_cur%NOTFOUND then
2155:
2156: FND_MESSAGE.SET_NAME('LNS', 'LNS_SUBM_APPR_AND_DISB');
2157: FND_MSG_PUB.ADD;
2158: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2159:
2160: -- LogMessage(FND_LOG.LEVEL_STATEMENT, 'ERROR: No site exist for the party');

Line 2161: FND_MESSAGE.SET_NAME('LNS', 'LNS_CREATE_PARTY_SITE');

2157: FND_MSG_PUB.ADD;
2158: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2159:
2160: -- LogMessage(FND_LOG.LEVEL_STATEMENT, 'ERROR: No site exist for the party');
2161: FND_MESSAGE.SET_NAME('LNS', 'LNS_CREATE_PARTY_SITE');
2162: FND_MSG_PUB.ADD;
2163: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2164: RAISE FND_API.G_EXC_ERROR;
2165:

Line 2180: FND_MESSAGE.SET_NAME('LNS', 'LNS_SUBM_APPR_AND_DISB');

2176: close disb_lines_cur;
2177:
2178: -- checking for total percent
2179: if l_sum_percent1 <> 100 or l_running_sum1 <> l_DISB_HEADER_REC.HEADER_AMOUNT then
2180: FND_MESSAGE.SET_NAME('LNS', 'LNS_SUBM_APPR_AND_DISB');
2181: FND_MSG_PUB.ADD;
2182: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2183:
2184: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Total percentage of all lines: ' || l_sum_percent1);

Line 2185: FND_MESSAGE.SET_NAME('LNS', 'LNS_DISB_LN_PERC_INVALID');

2181: FND_MSG_PUB.ADD;
2182: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2183:
2184: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Total percentage of all lines: ' || l_sum_percent1);
2185: FND_MESSAGE.SET_NAME('LNS', 'LNS_DISB_LN_PERC_INVALID');
2186: FND_MESSAGE.SET_TOKEN('DISB_NUM', l_DISB_HEADER_REC.DISBURSEMENT_NUMBER);
2187: FND_MSG_PUB.ADD;
2188: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2189: RAISE FND_API.G_EXC_ERROR;

Line 2186: FND_MESSAGE.SET_TOKEN('DISB_NUM', l_DISB_HEADER_REC.DISBURSEMENT_NUMBER);

2182: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2183:
2184: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Total percentage of all lines: ' || l_sum_percent1);
2185: FND_MESSAGE.SET_NAME('LNS', 'LNS_DISB_LN_PERC_INVALID');
2186: FND_MESSAGE.SET_TOKEN('DISB_NUM', l_DISB_HEADER_REC.DISBURSEMENT_NUMBER);
2187: FND_MSG_PUB.ADD;
2188: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2189: RAISE FND_API.G_EXC_ERROR;
2190: end if;

Line 2200: FND_MESSAGE.SET_NAME('LNS', 'LNS_SUBM_APPR_AND_DISB');

2196: close disb_headers_cur;
2197:
2198: -- checking for total percent
2199: if l_sum_percent <> 100 or l_running_sum <> l_funded_amount then
2200: FND_MESSAGE.SET_NAME('LNS', 'LNS_SUBM_APPR_AND_DISB');
2201: FND_MSG_PUB.ADD;
2202: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2203:
2204: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Total percentage of all disbursements: ' || l_sum_percent);

Line 2205: FND_MESSAGE.SET_NAME('LNS', 'LNS_DISB_HDR_PERC_INVALID');

2201: FND_MSG_PUB.ADD;
2202: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2203:
2204: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Total percentage of all disbursements: ' || l_sum_percent);
2205: FND_MESSAGE.SET_NAME('LNS', 'LNS_DISB_HDR_PERC_INVALID');
2206: FND_MSG_PUB.ADD;
2207: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2208: RAISE FND_API.G_EXC_ERROR;
2209: end if;

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

2352: -- if no record exists - return; otherwise proceed
2353: if validate_cur%NOTFOUND then
2354:
2355: -- LogMessage(FND_LOG.LEVEL_STATEMENT, 'ERROR: Disbursement Header Record is not found');
2356: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
2357: FND_MESSAGE.SET_TOKEN('RECORD', 'disbursement header record');
2358: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(P_DISB_HEADER_ID), 'null'));
2359: FND_MSG_PUB.ADD;
2360: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

Line 2357: FND_MESSAGE.SET_TOKEN('RECORD', 'disbursement header record');

2353: if validate_cur%NOTFOUND then
2354:
2355: -- LogMessage(FND_LOG.LEVEL_STATEMENT, 'ERROR: Disbursement Header Record is not found');
2356: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
2357: FND_MESSAGE.SET_TOKEN('RECORD', 'disbursement header record');
2358: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(P_DISB_HEADER_ID), 'null'));
2359: FND_MSG_PUB.ADD;
2360: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2361: RAISE FND_API.G_EXC_ERROR;

Line 2358: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(P_DISB_HEADER_ID), 'null'));

2354:
2355: -- LogMessage(FND_LOG.LEVEL_STATEMENT, 'ERROR: Disbursement Header Record is not found');
2356: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
2357: FND_MESSAGE.SET_TOKEN('RECORD', 'disbursement header record');
2358: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(P_DISB_HEADER_ID), 'null'));
2359: FND_MSG_PUB.ADD;
2360: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2361: RAISE FND_API.G_EXC_ERROR;
2362:

Line 2369: FND_MESSAGE.SET_NAME('LNS', 'LNS_SUBM_APPR_AND_DISB');

2365: close validate_cur;
2366:
2367: if l_DISB_HEADER_REC.ACTIVITY_CODE is null then
2368:
2369: FND_MESSAGE.SET_NAME('LNS', 'LNS_SUBM_APPR_AND_DISB');
2370: FND_MSG_PUB.ADD;
2371: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2372:
2373: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Activity code is missing');

Line 2374: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_ENTER_DISB_ACTIV' );

2370: FND_MSG_PUB.ADD;
2371: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2372:
2373: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Activity code is missing');
2374: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_ENTER_DISB_ACTIV' );
2375: FND_MSG_PUB.ADD;
2376: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2377: RAISE FND_API.G_EXC_ERROR;
2378:

Line 2383: FND_MESSAGE.SET_NAME('LNS', 'LNS_SUBM_APPR_AND_DISB');

2379: end if;
2380:
2381: if l_DISB_HEADER_REC.HEADER_PERCENT is null or l_DISB_HEADER_REC.HEADER_AMOUNT is null then
2382:
2383: FND_MESSAGE.SET_NAME('LNS', 'LNS_SUBM_APPR_AND_DISB');
2384: FND_MSG_PUB.ADD;
2385: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2386:
2387: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Disbursement percent is missing');

Line 2388: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_ENTER_DISB_PERC' );

2384: FND_MSG_PUB.ADD;
2385: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2386:
2387: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Disbursement percent is missing');
2388: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_ENTER_DISB_PERC' );
2389: FND_MSG_PUB.ADD;
2390: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2391: RAISE FND_API.G_EXC_ERROR;
2392:

Line 2399: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_ENTER_PAY_REQ_DATE' );

2395: -- validate Payment request date
2396: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Payment request date: ' || l_DISB_HEADER_REC.PAYMENT_REQUEST_DATE);
2397: if l_DISB_HEADER_REC.PAYMENT_REQUEST_DATE is null then
2398: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Payment request date is missing');
2399: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_ENTER_PAY_REQ_DATE' );
2400: FND_MSG_PUB.ADD;
2401: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2402: RAISE FND_API.G_EXC_ERROR;
2403: end if;

Line 2408: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_PAY_REQ_DT_INVALID' );

2404:
2405: if trunc(l_DISB_HEADER_REC.PAYMENT_REQUEST_DATE) < trunc(l_open_start_date) then
2406:
2407: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Payment request date must be greater than open start date');
2408: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_PAY_REQ_DT_INVALID' );
2409: FND_MSG_PUB.ADD;
2410: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2411: RAISE FND_API.G_EXC_ERROR;
2412:

Line 2419: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_ENTER_PAY_METHOD' );

2415: -- validate that no lines without payment method
2416: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Number of lines without payment method: ' || l_no_pay_mtd_count);
2417: if l_no_pay_mtd_count > 0 then
2418: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'There are disb lines without payment method');
2419: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_ENTER_PAY_METHOD' );
2420: FND_MSG_PUB.ADD;
2421: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2422: RAISE FND_API.G_EXC_ERROR;
2423: end if;

Line 2658: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );

2654:
2655: if l_DISB_LINE_REC.DISB_HEADER_ID is null then
2656:
2657: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Disbursement header is missing');
2658: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );
2659: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'disb_header_id' );
2660: FND_MSG_PUB.ADD;
2661: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2662: RAISE FND_API.G_EXC_ERROR;

Line 2659: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'disb_header_id' );

2655: if l_DISB_LINE_REC.DISB_HEADER_ID is null then
2656:
2657: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Disbursement header is missing');
2658: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );
2659: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'disb_header_id' );
2660: FND_MSG_PUB.ADD;
2661: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2662: RAISE FND_API.G_EXC_ERROR;
2663:

Line 2669: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_ENTER_PAYEE_PERC' );

2665:
2666: if l_DISB_LINE_REC.LINE_PERCENT is null then
2667:
2668: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Line percent is missing');
2669: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_ENTER_PAYEE_PERC' );
2670: FND_MSG_PUB.ADD;
2671: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2672: RAISE FND_API.G_EXC_ERROR;
2673:

Line 2679: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_ENTER_PAYEE' );

2675:
2676: if l_DISB_LINE_REC.PAYEE_PARTY_ID is null then
2677:
2678: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Payee party ID is missing');
2679: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_ENTER_PAYEE' );
2680: FND_MSG_PUB.ADD;
2681: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2682: RAISE FND_API.G_EXC_ERROR;
2683:

Line 2694: FND_MESSAGE.SET_NAME('LNS', 'LNS_CREATE_PARTY_SITE');

2690: -- if no record exists - error; otherwise proceed
2691: if party_site_cur%NOTFOUND then
2692:
2693: -- LogMessage(FND_LOG.LEVEL_STATEMENT, 'ERROR: No site exist for the party');
2694: FND_MESSAGE.SET_NAME('LNS', 'LNS_CREATE_PARTY_SITE');
2695: FND_MSG_PUB.ADD;
2696: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2697: RAISE FND_API.G_EXC_ERROR;
2698:

Line 2744: FND_MESSAGE.SET_NAME('LNS', 'LNS_DISB_LN_PERC_INVALID');

2740:
2741: -- checking for total percent
2742: if l_sum_percent <> 100 then
2743: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Total percentage of all lines: ' || l_sum_percent);
2744: FND_MESSAGE.SET_NAME('LNS', 'LNS_DISB_LN_PERC_INVALID');
2745: FND_MESSAGE.SET_TOKEN('DISB_NUM', l_disb_number);
2746: FND_MSG_PUB.ADD;
2747: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2748: RAISE FND_API.G_EXC_ERROR;

Line 2745: FND_MESSAGE.SET_TOKEN('DISB_NUM', l_disb_number);

2741: -- checking for total percent
2742: if l_sum_percent <> 100 then
2743: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Total percentage of all lines: ' || l_sum_percent);
2744: FND_MESSAGE.SET_NAME('LNS', 'LNS_DISB_LN_PERC_INVALID');
2745: FND_MESSAGE.SET_TOKEN('DISB_NUM', l_disb_number);
2746: FND_MSG_PUB.ADD;
2747: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2748: RAISE FND_API.G_EXC_ERROR;
2749: end if;

Line 3008: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );

3004:
3005: if l_DISB_HEADER_REC.LOAN_ID is null then
3006:
3007: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Loan ID is missing');
3008: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );
3009: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'loan id' );
3010: FND_MSG_PUB.ADD;
3011: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
3012: RAISE FND_API.G_EXC_ERROR;

Line 3009: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'loan id' );

3005: if l_DISB_HEADER_REC.LOAN_ID is null then
3006:
3007: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Loan ID is missing');
3008: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );
3009: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'loan id' );
3010: FND_MSG_PUB.ADD;
3011: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
3012: RAISE FND_API.G_EXC_ERROR;
3013:

Line 3019: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_ENTER_DISB_ACTIV' );

3015:
3016: if l_DISB_HEADER_REC.ACTIVITY_CODE is null then
3017:
3018: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Activity code is missing');
3019: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_ENTER_DISB_ACTIV' );
3020: FND_MSG_PUB.ADD;
3021: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
3022: RAISE FND_API.G_EXC_ERROR;
3023:

Line 3029: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_ENTER_DISB_PERC' );

3025:
3026: if l_DISB_HEADER_REC.HEADER_PERCENT is null then
3027:
3028: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Disbursement percent is missing');
3029: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_ENTER_DISB_PERC' );
3030: FND_MSG_PUB.ADD;
3031: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
3032: RAISE FND_API.G_EXC_ERROR;
3033:

Line 3039: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_ENTER_TARGET_DATE' );

3035:
3036: if l_DISB_HEADER_REC.TARGET_DATE is null then
3037:
3038: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Target date is missing');
3039: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_ENTER_TARGET_DATE' );
3040: FND_MSG_PUB.ADD;
3041: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
3042: RAISE FND_API.G_EXC_ERROR;
3043:

Line 3051: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_DISB_REQ_DATE_ERR' );

3047: if (l_DISB_HEADER_REC.STATUS NOT IN ('CANCELLED','IN_FUNDING','FUNDING_ERROR','PARTIALLY_FUNDED','FULLY_FUNDED')
3048: AND ( trunc(l_DISB_HEADER_REC.PAYMENT_REQUEST_DATE) < trunc(sysdate))) then
3049:
3050: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Payment Request date is less than today');
3051: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_DISB_REQ_DATE_ERR' );
3052: FND_MSG_PUB.ADD;
3053: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
3054: RAISE FND_API.G_EXC_ERROR;
3055:

Line 3062: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_DISB_TARGET_DATE_ERR' );

3058: if l_loan_status = 'INCOMPLETE' then
3059: if trunc(l_DISB_HEADER_REC.TARGET_DATE) < trunc(l_loan_start_date) then
3060:
3061: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Target date must be later that start date');
3062: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_DISB_TARGET_DATE_ERR' );
3063: FND_MSG_PUB.ADD;
3064: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
3065: RAISE FND_API.G_EXC_ERROR;
3066:

Line 3112: FND_MESSAGE.SET_NAME('LNS', 'LNS_DISB_HDR_PERC_INVALID');

3108:
3109: -- checking for total percent
3110: if l_sum_percent <> 100 then
3111: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Total percentage of all disbursements: ' || l_sum_percent);
3112: FND_MESSAGE.SET_NAME('LNS', 'LNS_DISB_HDR_PERC_INVALID');
3113: FND_MSG_PUB.ADD;
3114: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
3115: RAISE FND_API.G_EXC_ERROR;
3116: end if;

Line 3454: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );

3450: SAVEPOINT DEFAULT_PROD_DISBURSEMENTS;
3451:
3452: IF p_loan_id IS NULL THEN
3453: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'LOAN ID is missing');
3454: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );
3455: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'p_loan_id' );
3456: FND_MSG_PUB.ADD;
3457: RAISE FND_API.G_EXC_ERROR;
3458: END IF;

Line 3455: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'p_loan_id' );

3451:
3452: IF p_loan_id IS NULL THEN
3453: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'LOAN ID is missing');
3454: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );
3455: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'p_loan_id' );
3456: FND_MSG_PUB.ADD;
3457: RAISE FND_API.G_EXC_ERROR;
3458: END IF;
3459: SELECT llh.primary_borrower_id

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

3543: || G_PKG_NAME || '.' || l_api_name);
3544:
3545: WHEN OTHERS THEN
3546: ROLLBACK TO DEFAULT_PROD_DISBURSEMENTS;
3547: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
3548: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3549: FND_MSG_PUB.ADD;
3550:
3551: END DEFAULT_PROD_DISBURSEMENTS;

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

3544:
3545: WHEN OTHERS THEN
3546: ROLLBACK TO DEFAULT_PROD_DISBURSEMENTS;
3547: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
3548: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3549: FND_MSG_PUB.ADD;
3550:
3551: END DEFAULT_PROD_DISBURSEMENTS;
3552:

Line 4216: FND_MESSAGE.SET_NAME('LNS', 'LNS_FAIL_INS_AP_INV');

4212: ROLLBACK TO SUBMIT_SINGLE_PAY_REQ;
4213:
4214: if l_new_invoice = 'Y' then
4215: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Failed to insert invoice into interface table');
4216: FND_MESSAGE.SET_NAME('LNS', 'LNS_FAIL_INS_AP_INV');
4217: FND_MSG_PUB.Add;
4218: else
4219: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Failed to update invoice into interface table');
4220: FND_MESSAGE.SET_NAME('LNS', 'LNS_FAIL_UPD_AP_INV');

Line 4220: FND_MESSAGE.SET_NAME('LNS', 'LNS_FAIL_UPD_AP_INV');

4216: FND_MESSAGE.SET_NAME('LNS', 'LNS_FAIL_INS_AP_INV');
4217: FND_MSG_PUB.Add;
4218: else
4219: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Failed to update invoice into interface table');
4220: FND_MESSAGE.SET_NAME('LNS', 'LNS_FAIL_UPD_AP_INV');
4221: FND_MSG_PUB.Add;
4222: end if;
4223:
4224: RAISE FND_API.G_EXC_ERROR;

Line 4452: FND_MESSAGE.SET_NAME('LNS', 'LNS_FAIL_INS_AP_INV_LN');

4448: WHEN OTHERS THEN
4449: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Failed to insert invoice line into interface table');
4450: ROLLBACK TO SUBMIT_SINGLE_PAY_REQ;
4451:
4452: FND_MESSAGE.SET_NAME('LNS', 'LNS_FAIL_INS_AP_INV_LN');
4453: FND_MSG_PUB.Add;
4454: RAISE FND_API.G_EXC_ERROR;
4455: END;
4456:

Line 4577: FND_MESSAGE.SET_NAME('LNS', 'LNS_DISB_REJECTION');

4573: close get_party2_cur;
4574:
4575: end if;
4576:
4577: FND_MESSAGE.SET_NAME('LNS', 'LNS_DISB_REJECTION');
4578: FND_MESSAGE.SET_TOKEN('PAYEE', l_payee);
4579: FND_MESSAGE.SET_TOKEN('REJECTION', l_reject_desc);
4580: FND_MSG_PUB.Add;
4581:

Line 4578: FND_MESSAGE.SET_TOKEN('PAYEE', l_payee);

4574:
4575: end if;
4576:
4577: FND_MESSAGE.SET_NAME('LNS', 'LNS_DISB_REJECTION');
4578: FND_MESSAGE.SET_TOKEN('PAYEE', l_payee);
4579: FND_MESSAGE.SET_TOKEN('REJECTION', l_reject_desc);
4580: FND_MSG_PUB.Add;
4581:
4582: END LOOP;

Line 4579: FND_MESSAGE.SET_TOKEN('REJECTION', l_reject_desc);

4575: end if;
4576:
4577: FND_MESSAGE.SET_NAME('LNS', 'LNS_DISB_REJECTION');
4578: FND_MESSAGE.SET_TOKEN('PAYEE', l_payee);
4579: FND_MESSAGE.SET_TOKEN('REJECTION', l_reject_desc);
4580: FND_MSG_PUB.Add;
4581:
4582: END LOOP;
4583:

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

4944: -- if no record exists - return; otherwise proceed
4945: if loan_detail_cur%NOTFOUND then
4946:
4947: -- LogMessage(FND_LOG.LEVEL_STATEMENT, 'ERROR: Loan Record is not found');
4948: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
4949: FND_MESSAGE.SET_TOKEN('RECORD', 'loan header');
4950: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(P_DISB_HEADER_ID), 'null'));
4951: FND_MSG_PUB.ADD;
4952: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

Line 4949: FND_MESSAGE.SET_TOKEN('RECORD', 'loan header');

4945: if loan_detail_cur%NOTFOUND then
4946:
4947: -- LogMessage(FND_LOG.LEVEL_STATEMENT, 'ERROR: Loan Record is not found');
4948: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
4949: FND_MESSAGE.SET_TOKEN('RECORD', 'loan header');
4950: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(P_DISB_HEADER_ID), 'null'));
4951: FND_MSG_PUB.ADD;
4952: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
4953: RAISE FND_API.G_EXC_ERROR;

Line 4950: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(P_DISB_HEADER_ID), 'null'));

4946:
4947: -- LogMessage(FND_LOG.LEVEL_STATEMENT, 'ERROR: Loan Record is not found');
4948: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
4949: FND_MESSAGE.SET_TOKEN('RECORD', 'loan header');
4950: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(P_DISB_HEADER_ID), 'null'));
4951: FND_MSG_PUB.ADD;
4952: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
4953: RAISE FND_API.G_EXC_ERROR;
4954:

Line 5006: FND_MESSAGE.SET_NAME('LNS', 'LNS_NOT_ALL_COND_MET');

5002: fetch conditions_cur into l_cond_count;
5003: close conditions_cur;
5004:
5005: if l_cond_count > 0 then
5006: FND_MESSAGE.SET_NAME('LNS', 'LNS_NOT_ALL_COND_MET');
5007: FND_MSG_PUB.Add;
5008: RAISE FND_API.G_EXC_ERROR;
5009: end if;
5010:

Line 5109: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');

5105:
5106: IF l_return_status = 'S' THEN
5107: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_LOAN_HEADERS_ALL');
5108: ELSE
5109: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
5110: FND_MSG_PUB.Add;
5111: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
5112: -- RAISE FND_API.G_EXC_ERROR;
5113: END IF;

Line 5142: FND_MESSAGE.SET_NAME('LNS', 'LNS_SUBMIT_DISB_FAILED');

5138: x_return_status := FND_API.G_RET_STS_ERROR;
5139: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
5140:
5141: if x_msg_count = 0 then
5142: FND_MESSAGE.SET_NAME('LNS', 'LNS_SUBMIT_DISB_FAILED');
5143: FND_MSG_PUB.Add;
5144: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
5145: end if;
5146:

Line 5585: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_TERM_FAIL');

5581: IF l_return_status = 'S' THEN
5582: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_TERMS');
5583: ELSE
5584: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: LNS_TERMS_PUB.update_term returned error: ' || substr(l_msg_data,1,225));
5585: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_TERM_FAIL');
5586: FND_MSG_PUB.Add;
5587: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
5588: RAISE FND_API.G_EXC_ERROR;
5589: END IF;

Line 5638: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');

5634:
5635: IF l_return_status = 'S' THEN
5636: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_LOAN_HEADERS_ALL');
5637: ELSE
5638: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
5639: FND_MSG_PUB.Add;
5640: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
5641: RAISE FND_API.G_EXC_ERROR;
5642: END IF;

Line 5701: FND_MESSAGE.SET_NAME('LNS', 'LNS_BILLING_REQUEST_FAILED');

5697:
5698: if l_request_id = 0 then
5699:
5700: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Failed to start Billing Concurrent Program.');
5701: FND_MESSAGE.SET_NAME('LNS', 'LNS_BILLING_REQUEST_FAILED');
5702: FND_MSG_PUB.Add;
5703: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
5704: RAISE FND_API.G_EXC_ERROR;
5705:

Line 5746: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');

5742:
5743: IF l_return_status = 'S' THEN
5744: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_LOAN_HEADERS_ALL');
5745: ELSE
5746: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
5747: FND_MSG_PUB.Add;
5748: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
5749: RAISE FND_API.G_EXC_ERROR;
5750: END IF;

Line 5844: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_TERM_FAIL');

5840: IF l_return_status = 'S' THEN
5841: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_TERMS');
5842: ELSE
5843: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: LNS_TERMS_PUB.update_term returned error: ' || substr(l_msg_data,1,225));
5844: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_TERM_FAIL');
5845: FND_MSG_PUB.Add;
5846: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
5847: RAISE FND_API.G_EXC_ERROR;
5848: END IF;

Line 5910: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_TERM_FAIL');

5906: IF l_return_status = 'S' THEN
5907: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_TERMS');
5908: ELSE
5909: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: LNS_TERMS_PUB.update_term returned error: ' || substr(l_msg_data,1,225));
5910: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_TERM_FAIL');
5911: FND_MSG_PUB.Add;
5912: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
5913: RAISE FND_API.G_EXC_ERROR;
5914: END IF;

Line 5956: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');

5952:
5953: IF l_return_status = 'S' THEN
5954: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_LOAN_HEADERS_ALL');
5955: ELSE
5956: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
5957: FND_MSG_PUB.Add;
5958: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
5959: RAISE FND_API.G_EXC_ERROR;
5960: END IF;

Line 6004: FND_MESSAGE.SET_NAME('LNS', 'LNS_AGREEMENT_REQUEST_FAILED');

6000: ,l_loan_header_rec.loan_id,'Y');
6001:
6002: if l_request_id = 0 then
6003: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6004: FND_MESSAGE.SET_NAME('LNS', 'LNS_AGREEMENT_REQUEST_FAILED');
6005: FND_MSG_PUB.Add;
6006: l_last_api_called := 'FND_REQUEST.SUBMIT_REQUEST for Loan Agreement Report Generation';
6007: RAISE FND_API.G_EXC_ERROR;
6008: else

Line 6552: FND_MESSAGE.SET_NAME('SQLAP4', l_message_name);

6548: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_original_prepayment_amount: ' || l_original_prepayment_amount);
6549: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_pay_curr_invoice_amount: ' || l_pay_curr_invoice_amount);
6550:
6551: IF NOT l_success THEN
6552: FND_MESSAGE.SET_NAME('SQLAP4', l_message_name);
6553: FND_MESSAGE.SET_TOKEN('ERROR', l_Token);
6554: FND_MSG_PUB.ADD;
6555: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
6556: RAISE FND_API.G_EXC_ERROR;

Line 6553: FND_MESSAGE.SET_TOKEN('ERROR', l_Token);

6549: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_pay_curr_invoice_amount: ' || l_pay_curr_invoice_amount);
6550:
6551: IF NOT l_success THEN
6552: FND_MESSAGE.SET_NAME('SQLAP4', l_message_name);
6553: FND_MESSAGE.SET_TOKEN('ERROR', l_Token);
6554: FND_MSG_PUB.ADD;
6555: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
6556: RAISE FND_API.G_EXC_ERROR;
6557: ELSE

Line 6846: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');

6842:
6843: IF l_return_status = 'S' THEN
6844: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_LOAN_HEADERS_ALL');
6845: ELSE
6846: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
6847: FND_MSG_PUB.Add;
6848: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
6849: RAISE FND_API.G_EXC_ERROR;
6850: END IF;

Line 7048: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');

7044:
7045: IF l_return_status = 'S' THEN
7046: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_LOAN_HEADERS_ALL');
7047: ELSE
7048: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
7049: FND_MSG_PUB.Add;
7050: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
7051: RAISE FND_API.G_EXC_ERROR;
7052: END IF;

Line 7230: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');

7226:
7227: IF l_return_status = 'S' THEN
7228: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_LOAN_HEADERS_ALL');
7229: ELSE
7230: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
7231: FND_MSG_PUB.Add;
7232: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
7233: RAISE FND_API.G_EXC_ERROR;
7234: END IF;

Line 7849: FND_MESSAGE.SET_NAME('LNS', 'LNS_CREATE_DISB_SCHED');

7845:
7846: if P_AUTOFUNDING_FLAG = 'Y' then
7847:
7848: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'No disbursement header record found');
7849: FND_MESSAGE.SET_NAME('LNS', 'LNS_CREATE_DISB_SCHED');
7850: FND_MSG_PUB.ADD;
7851: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
7852: RAISE FND_API.G_EXC_ERROR;
7853:

Line 7901: FND_MESSAGE.SET_NAME('LNS', 'LNS_AUTOFUND_AND_MAND_CONDIT');

7897: fetch conditions_cur into l_cond_count;
7898: close conditions_cur;
7899:
7900: if l_cond_count > 0 then
7901: FND_MESSAGE.SET_NAME('LNS', 'LNS_AUTOFUND_AND_MAND_CONDIT');
7902: FND_MSG_PUB.Add;
7903: RAISE FND_API.G_EXC_ERROR;
7904: end if;
7905:

Line 8670: FND_MESSAGE.SET_NAME('LNS', 'LNS_CANT_PAYOFF_IN_FUND');

8666: fetch in_fund_count_cur into l_in_funding_count;
8667: close in_fund_count_cur;
8668:
8669: if l_in_funding_count > 0 then
8670: FND_MESSAGE.SET_NAME('LNS', 'LNS_CANT_PAYOFF_IN_FUND');
8671: FND_MSG_PUB.Add;
8672: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
8673: RAISE FND_API.G_EXC_ERROR;
8674: end if;