APPS.LNS_FUNDING_PUB dependencies on FND_MESSAGE

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

562:
563: if P_DISB_HEADER_REC.LOAN_ID is null then
564:
565: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Loan ID is missing');
566: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );
567: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'loan_id' );
568: FND_MSG_PUB.ADD;
569: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
570: RAISE FND_API.G_EXC_ERROR;

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

563: if P_DISB_HEADER_REC.LOAN_ID is null then
564:
565: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Loan ID is missing');
566: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );
567: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'loan_id' );
568: FND_MSG_PUB.ADD;
569: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
570: RAISE FND_API.G_EXC_ERROR;
571:

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

752:
753: if P_DISB_HEADER_REC.DISB_HEADER_ID is null then
754:
755: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Disbursement header ID is missing');
756: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );
757: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'disb_header_id' );
758: FND_MSG_PUB.ADD;
759: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
760: RAISE FND_API.G_EXC_ERROR;

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

753: if P_DISB_HEADER_REC.DISB_HEADER_ID is null then
754:
755: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Disbursement header ID is missing');
756: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );
757: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'disb_header_id' );
758: FND_MSG_PUB.ADD;
759: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
760: RAISE FND_API.G_EXC_ERROR;
761:

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

767:
768: if disb_head_cur%NOTFOUND then
769:
770: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'No disbursement header record found');
771: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
772: FND_MESSAGE.SET_TOKEN('RECORD', 'disbursement header');
773: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(P_DISB_HEADER_REC.DISB_HEADER_ID), 'null'));
774: FND_MSG_PUB.ADD;
775: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

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

768: if disb_head_cur%NOTFOUND then
769:
770: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'No disbursement header record found');
771: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
772: FND_MESSAGE.SET_TOKEN('RECORD', 'disbursement header');
773: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(P_DISB_HEADER_REC.DISB_HEADER_ID), 'null'));
774: FND_MSG_PUB.ADD;
775: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
776: RAISE FND_API.G_EXC_ERROR;

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

769:
770: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'No disbursement header record found');
771: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
772: FND_MESSAGE.SET_TOKEN('RECORD', 'disbursement header');
773: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(P_DISB_HEADER_REC.DISB_HEADER_ID), 'null'));
774: FND_MSG_PUB.ADD;
775: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
776: RAISE FND_API.G_EXC_ERROR;
777:

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

781:
782: if l_disb_header_version <> P_DISB_HEADER_REC.OBJECT_VERSION_NUMBER then
783:
784: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Disbursement header record has already been changed');
785: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_RECORD_CHANGED');
786: FND_MESSAGE.SET_TOKEN('TABLE', 'LNS_DISB_HEADERS');
787: FND_MSG_PUB.ADD;
788: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
789: RAISE FND_API.G_EXC_ERROR;

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

782: if l_disb_header_version <> P_DISB_HEADER_REC.OBJECT_VERSION_NUMBER then
783:
784: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Disbursement header record has already been changed');
785: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_RECORD_CHANGED');
786: FND_MESSAGE.SET_TOKEN('TABLE', 'LNS_DISB_HEADERS');
787: FND_MSG_PUB.ADD;
788: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
789: RAISE FND_API.G_EXC_ERROR;
790:

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

956:
957: if P_DISB_HEADER_ID is null then
958:
959: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Disbursement header ID is missing');
960: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );
961: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'disb_header_id' );
962: FND_MSG_PUB.ADD;
963: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
964: RAISE FND_API.G_EXC_ERROR;

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

957: if P_DISB_HEADER_ID is null then
958:
959: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Disbursement header ID is missing');
960: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );
961: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'disb_header_id' );
962: FND_MSG_PUB.ADD;
963: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
964: RAISE FND_API.G_EXC_ERROR;
965:

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

971:
972: if disb_head_cur%NOTFOUND then
973:
974: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'No disbursement header record found');
975: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
976: FND_MESSAGE.SET_TOKEN('RECORD', 'disbursement header');
977: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(P_DISB_HEADER_ID), 'null'));
978: FND_MSG_PUB.ADD;
979: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

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

972: if disb_head_cur%NOTFOUND then
973:
974: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'No disbursement header record found');
975: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
976: FND_MESSAGE.SET_TOKEN('RECORD', 'disbursement header');
977: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(P_DISB_HEADER_ID), 'null'));
978: FND_MSG_PUB.ADD;
979: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
980: RAISE FND_API.G_EXC_ERROR;

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

973:
974: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'No disbursement header record found');
975: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
976: FND_MESSAGE.SET_TOKEN('RECORD', 'disbursement header');
977: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(P_DISB_HEADER_ID), 'null'));
978: FND_MSG_PUB.ADD;
979: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
980: RAISE FND_API.G_EXC_ERROR;
981:

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

985:
986: if l_status is not null then
987:
988: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Cannot delete disbursement header. It has already been processed.');
989: FND_MESSAGE.SET_NAME('LNS', 'LNS_CANT_DEL_DISB_HDR');
990: FND_MSG_PUB.ADD;
991: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
992: RAISE FND_API.G_EXC_ERROR;
993:

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

1176:
1177: if P_DISB_LINE_REC.DISB_HEADER_ID is null then
1178:
1179: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Disbursement header ID is missing');
1180: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );
1181: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'disb_header_id' );
1182: FND_MSG_PUB.ADD;
1183: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
1184: RAISE FND_API.G_EXC_ERROR;

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

1177: if P_DISB_LINE_REC.DISB_HEADER_ID is null then
1178:
1179: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Disbursement header ID is missing');
1180: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );
1181: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'disb_header_id' );
1182: FND_MSG_PUB.ADD;
1183: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
1184: RAISE FND_API.G_EXC_ERROR;
1185:

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

1187:
1188: if P_DISB_LINE_REC.LINE_PERCENT is null then
1189:
1190: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Line percent is missing');
1191: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_ENTER_PAYEE_PERC');
1192: FND_MSG_PUB.ADD;
1193: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
1194: RAISE FND_API.G_EXC_ERROR;
1195:

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

1197:
1198: if P_DISB_LINE_REC.PAYEE_PARTY_ID is null then
1199:
1200: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Payee party ID is missing');
1201: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_ENTER_PAYEE' );
1202: FND_MSG_PUB.ADD;
1203: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
1204: RAISE FND_API.G_EXC_ERROR;
1205:

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

1386:
1387: if P_DISB_LINE_REC.DISB_LINE_ID is null then
1388:
1389: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Disbursement line ID is missing');
1390: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );
1391: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'disb_line_id' );
1392: FND_MSG_PUB.ADD;
1393: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
1394: RAISE FND_API.G_EXC_ERROR;

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

1387: if P_DISB_LINE_REC.DISB_LINE_ID is null then
1388:
1389: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Disbursement line ID is missing');
1390: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );
1391: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'disb_line_id' );
1392: FND_MSG_PUB.ADD;
1393: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
1394: RAISE FND_API.G_EXC_ERROR;
1395:

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

1401:
1402: if disb_line_cur%NOTFOUND then
1403:
1404: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'No disbursement line record found');
1405: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
1406: FND_MESSAGE.SET_TOKEN('RECORD', 'disbursement line');
1407: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(P_DISB_LINE_REC.DISB_LINE_ID), 'null'));
1408: FND_MSG_PUB.ADD;
1409: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

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

1402: if disb_line_cur%NOTFOUND then
1403:
1404: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'No disbursement line record found');
1405: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
1406: FND_MESSAGE.SET_TOKEN('RECORD', 'disbursement line');
1407: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(P_DISB_LINE_REC.DISB_LINE_ID), 'null'));
1408: FND_MSG_PUB.ADD;
1409: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
1410: RAISE FND_API.G_EXC_ERROR;

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

1403:
1404: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'No disbursement line record found');
1405: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
1406: FND_MESSAGE.SET_TOKEN('RECORD', 'disbursement line');
1407: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(P_DISB_LINE_REC.DISB_LINE_ID), 'null'));
1408: FND_MSG_PUB.ADD;
1409: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
1410: RAISE FND_API.G_EXC_ERROR;
1411:

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

1415:
1416: if l_disb_line_version <> P_DISB_LINE_REC.OBJECT_VERSION_NUMBER then
1417:
1418: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Disbursement line record has already been changed');
1419: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_RECORD_CHANGED');
1420: FND_MESSAGE.SET_TOKEN('TABLE', 'LNS_DISB_LINES');
1421: FND_MSG_PUB.ADD;
1422: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
1423: RAISE FND_API.G_EXC_ERROR;

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

1416: if l_disb_line_version <> P_DISB_LINE_REC.OBJECT_VERSION_NUMBER then
1417:
1418: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Disbursement line record has already been changed');
1419: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_RECORD_CHANGED');
1420: FND_MESSAGE.SET_TOKEN('TABLE', 'LNS_DISB_LINES');
1421: FND_MSG_PUB.ADD;
1422: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
1423: RAISE FND_API.G_EXC_ERROR;
1424:

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

1589:
1590: if P_DISB_LINE_ID is null then
1591:
1592: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Disbursement line ID is missing');
1593: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );
1594: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'disb_line_id' );
1595: FND_MSG_PUB.ADD;
1596: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
1597: RAISE FND_API.G_EXC_ERROR;

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

1590: if P_DISB_LINE_ID is null then
1591:
1592: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Disbursement line ID is missing');
1593: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );
1594: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'disb_line_id' );
1595: FND_MSG_PUB.ADD;
1596: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
1597: RAISE FND_API.G_EXC_ERROR;
1598:

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

1604:
1605: if disb_head_cur%NOTFOUND then
1606:
1607: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'No disbursement line record found');
1608: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
1609: FND_MESSAGE.SET_TOKEN('RECORD', 'disbursement line');
1610: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(P_DISB_LINE_ID), 'null'));
1611: FND_MSG_PUB.ADD;
1612: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

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

1605: if disb_head_cur%NOTFOUND then
1606:
1607: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'No disbursement line record found');
1608: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
1609: FND_MESSAGE.SET_TOKEN('RECORD', 'disbursement line');
1610: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(P_DISB_LINE_ID), 'null'));
1611: FND_MSG_PUB.ADD;
1612: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
1613: RAISE FND_API.G_EXC_ERROR;

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

1606:
1607: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'No disbursement line record found');
1608: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
1609: FND_MESSAGE.SET_TOKEN('RECORD', 'disbursement line');
1610: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(P_DISB_LINE_ID), 'null'));
1611: FND_MSG_PUB.ADD;
1612: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
1613: RAISE FND_API.G_EXC_ERROR;
1614:

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

1618:
1619: if l_status is not null then
1620:
1621: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Cannot delete disbursement line. It has already been processed.');
1622: FND_MESSAGE.SET_NAME('LNS', 'LNS_CANT_DEL_DISB_LN');
1623: FND_MSG_PUB.ADD;
1624: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
1625: RAISE FND_API.G_EXC_ERROR;
1626:

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

1800: 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);
1801: --karamach bug5226980
1802: l_return_status := l_Ext_Payee_Create_Tab(l_Count).Payee_Creation_Status;
1803: if (l_Ext_Payee_Create_Tab(l_Count).Payee_Creation_Status = 'E') then
1804: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
1805: 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);
1806: FND_MSG_PUB.ADD;
1807: RAISE FND_API.G_EXC_ERROR;
1808: end if;

Line 1805: 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);

1801: --karamach bug5226980
1802: l_return_status := l_Ext_Payee_Create_Tab(l_Count).Payee_Creation_Status;
1803: if (l_Ext_Payee_Create_Tab(l_Count).Payee_Creation_Status = 'E') then
1804: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
1805: 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);
1806: FND_MSG_PUB.ADD;
1807: RAISE FND_API.G_EXC_ERROR;
1808: end if;
1809: END LOOP;

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

1808: end if;
1809: END LOOP;
1810:
1811: if l_return_status = 'E' then
1812: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
1813: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed API call: IBY_DISBURSEMENT_SETUP_PUB.Create_External_Payee');
1814: FND_MSG_PUB.ADD;
1815: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1816: p_count => l_msg_count,

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

1809: END LOOP;
1810:
1811: if l_return_status = 'E' then
1812: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
1813: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed API call: IBY_DISBURSEMENT_SETUP_PUB.Create_External_Payee');
1814: FND_MSG_PUB.ADD;
1815: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1816: p_count => l_msg_count,
1817: p_data => l_msg_data);

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

2015: l_loan_maturity_date;
2016:
2017: if disb_headers_cur%NOTFOUND and l_count = 0 then
2018:
2019: FND_MESSAGE.SET_NAME('LNS', 'LNS_SUBM_APPR_AND_DISB');
2020: FND_MSG_PUB.ADD;
2021: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2022:
2023: -- LogMessage(FND_LOG.LEVEL_STATEMENT, 'ERROR: Disbursement schedule is not found');

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

2020: FND_MSG_PUB.ADD;
2021: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2022:
2023: -- LogMessage(FND_LOG.LEVEL_STATEMENT, 'ERROR: Disbursement schedule is not found');
2024: FND_MESSAGE.SET_NAME('LNS', 'LNS_CREATE_DISB_SCHED');
2025: FND_MSG_PUB.ADD;
2026: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2027: RAISE FND_API.G_EXC_ERROR;
2028:

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

2048: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Open loan maturity date: ' || l_loan_maturity_date);
2049:
2050: if l_DISB_HEADER_REC.LOAN_ID is null then
2051:
2052: FND_MESSAGE.SET_NAME('LNS', 'LNS_SUBM_APPR_AND_DISB');
2053: FND_MSG_PUB.ADD;
2054: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2055:
2056: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Loan ID is missing');

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

2053: FND_MSG_PUB.ADD;
2054: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2055:
2056: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Loan ID is missing');
2057: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );
2058: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'loan id' );
2059: FND_MSG_PUB.ADD;
2060: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2061: RAISE FND_API.G_EXC_ERROR;

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

2054: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2055:
2056: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Loan ID is missing');
2057: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );
2058: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'loan id' );
2059: FND_MSG_PUB.ADD;
2060: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2061: RAISE FND_API.G_EXC_ERROR;
2062:

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

2063: end if;
2064:
2065: if l_DISB_HEADER_REC.ACTIVITY_CODE is null then
2066:
2067: FND_MESSAGE.SET_NAME('LNS', 'LNS_SUBM_APPR_AND_DISB');
2068: FND_MSG_PUB.ADD;
2069: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2070:
2071: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Activity code is missing');

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

2068: FND_MSG_PUB.ADD;
2069: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2070:
2071: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Activity code is missing');
2072: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_ENTER_DISB_ACTIV' );
2073: FND_MSG_PUB.ADD;
2074: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2075: RAISE FND_API.G_EXC_ERROR;
2076:

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

2077: end if;
2078:
2079: if l_DISB_HEADER_REC.HEADER_PERCENT is null or l_DISB_HEADER_REC.HEADER_AMOUNT is null then
2080:
2081: FND_MESSAGE.SET_NAME('LNS', 'LNS_SUBM_APPR_AND_DISB');
2082: FND_MSG_PUB.ADD;
2083: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2084:
2085: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Disbursement percent is missing');

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

2082: FND_MSG_PUB.ADD;
2083: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2084:
2085: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Disbursement percent is missing');
2086: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_ENTER_DISB_PERC' );
2087: FND_MSG_PUB.ADD;
2088: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2089: RAISE FND_API.G_EXC_ERROR;
2090:

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

2091: end if;
2092:
2093: if l_DISB_HEADER_REC.TARGET_DATE is null then
2094:
2095: FND_MESSAGE.SET_NAME('LNS', 'LNS_SUBM_APPR_AND_DISB');
2096: FND_MSG_PUB.ADD;
2097: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2098:
2099: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Target date is missing');

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

2096: FND_MSG_PUB.ADD;
2097: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2098:
2099: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Target date is missing');
2100: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_ENTER_TARGET_DATE' );
2101: FND_MSG_PUB.ADD;
2102: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2103: RAISE FND_API.G_EXC_ERROR;
2104:

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

2106:
2107: if trunc(l_DISB_HEADER_REC.TARGET_DATE) < trunc(l_loan_start_date) then
2108:
2109: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Target date must be later that start date');
2110: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_DISB_TARGET_DATE_ERR' );
2111: FND_MSG_PUB.ADD;
2112: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2113: RAISE FND_API.G_EXC_ERROR;
2114:

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

2140:
2141: if disb_lines_cur%NOTFOUND and l_count1 = 0 then
2142:
2143: -- LogMessage(FND_LOG.LEVEL_STATEMENT, 'ERROR: Disbursement lines are not found');
2144: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
2145: FND_MESSAGE.SET_TOKEN('RECORD', 'disbursement line record');
2146: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(l_DISB_HEADER_REC.DISB_HEADER_ID), 'null'));
2147: FND_MSG_PUB.ADD;
2148: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

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

2141: if disb_lines_cur%NOTFOUND and l_count1 = 0 then
2142:
2143: -- LogMessage(FND_LOG.LEVEL_STATEMENT, 'ERROR: Disbursement lines are not found');
2144: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
2145: FND_MESSAGE.SET_TOKEN('RECORD', 'disbursement line record');
2146: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(l_DISB_HEADER_REC.DISB_HEADER_ID), 'null'));
2147: FND_MSG_PUB.ADD;
2148: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2149: RAISE FND_API.G_EXC_ERROR;

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

2142:
2143: -- LogMessage(FND_LOG.LEVEL_STATEMENT, 'ERROR: Disbursement lines are not found');
2144: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
2145: FND_MESSAGE.SET_TOKEN('RECORD', 'disbursement line record');
2146: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(l_DISB_HEADER_REC.DISB_HEADER_ID), 'null'));
2147: FND_MSG_PUB.ADD;
2148: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2149: RAISE FND_API.G_EXC_ERROR;
2150:

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

2167: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Due date: ' || l_due_date);
2168:
2169: if l_DISB_LINE_REC.DISB_HEADER_ID is null then
2170:
2171: FND_MESSAGE.SET_NAME('LNS', 'LNS_SUBM_APPR_AND_DISB');
2172: FND_MSG_PUB.ADD;
2173: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2174:
2175: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Disbursement header is missing');

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

2172: FND_MSG_PUB.ADD;
2173: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2174:
2175: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Disbursement header is missing');
2176: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );
2177: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'disb_header_id' );
2178: FND_MSG_PUB.ADD;
2179: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2180: RAISE FND_API.G_EXC_ERROR;

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

2173: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2174:
2175: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Disbursement header is missing');
2176: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );
2177: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'disb_header_id' );
2178: FND_MSG_PUB.ADD;
2179: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2180: RAISE FND_API.G_EXC_ERROR;
2181:

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

2182: end if;
2183:
2184: if l_DISB_LINE_REC.LINE_PERCENT is null or l_DISB_LINE_REC.LINE_AMOUNT is null then
2185:
2186: FND_MESSAGE.SET_NAME('LNS', 'LNS_SUBM_APPR_AND_DISB');
2187: FND_MSG_PUB.ADD;
2188: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2189:
2190: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Line percent is missing');

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

2187: FND_MSG_PUB.ADD;
2188: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2189:
2190: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Line percent is missing');
2191: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_ENTER_PAYEE_PERC' );
2192: FND_MSG_PUB.ADD;
2193: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2194: RAISE FND_API.G_EXC_ERROR;
2195:

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

2196: end if;
2197:
2198: if l_DISB_LINE_REC.PAYEE_PARTY_ID is null then
2199:
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, 'Payee party ID is missing');

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

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, 'Payee party ID is missing');
2205: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_ENTER_PAYEE' );
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:

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

2215:
2216: -- if no record exists - error; otherwise proceed
2217: if party_site_cur%NOTFOUND then
2218:
2219: FND_MESSAGE.SET_NAME('LNS', 'LNS_SUBM_APPR_AND_DISB');
2220: FND_MSG_PUB.ADD;
2221: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2222:
2223: -- LogMessage(FND_LOG.LEVEL_STATEMENT, 'ERROR: No site exist for the party');

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

2220: FND_MSG_PUB.ADD;
2221: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2222:
2223: -- LogMessage(FND_LOG.LEVEL_STATEMENT, 'ERROR: No site exist for the party');
2224: FND_MESSAGE.SET_NAME('LNS', 'LNS_CREATE_PARTY_SITE');
2225: FND_MSG_PUB.ADD;
2226: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2227: RAISE FND_API.G_EXC_ERROR;
2228:

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

2239: close disb_lines_cur;
2240:
2241: -- checking for total percent
2242: if l_sum_percent1 <> 100 or l_running_sum1 <> l_DISB_HEADER_REC.HEADER_AMOUNT then
2243: FND_MESSAGE.SET_NAME('LNS', 'LNS_SUBM_APPR_AND_DISB');
2244: FND_MSG_PUB.ADD;
2245: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2246:
2247: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Total percentage of all lines: ' || l_sum_percent1);

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

2244: FND_MSG_PUB.ADD;
2245: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2246:
2247: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Total percentage of all lines: ' || l_sum_percent1);
2248: FND_MESSAGE.SET_NAME('LNS', 'LNS_DISB_LN_PERC_INVALID');
2249: FND_MESSAGE.SET_TOKEN('DISB_NUM', l_DISB_HEADER_REC.DISBURSEMENT_NUMBER);
2250: FND_MSG_PUB.ADD;
2251: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2252: RAISE FND_API.G_EXC_ERROR;

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

2245: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2246:
2247: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Total percentage of all lines: ' || l_sum_percent1);
2248: FND_MESSAGE.SET_NAME('LNS', 'LNS_DISB_LN_PERC_INVALID');
2249: FND_MESSAGE.SET_TOKEN('DISB_NUM', l_DISB_HEADER_REC.DISBURSEMENT_NUMBER);
2250: FND_MSG_PUB.ADD;
2251: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2252: RAISE FND_API.G_EXC_ERROR;
2253: end if;

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

2259: close disb_headers_cur;
2260:
2261: -- checking for total percent
2262: if l_sum_percent <> 100 or l_running_sum <> l_funded_amount then
2263: FND_MESSAGE.SET_NAME('LNS', 'LNS_SUBM_APPR_AND_DISB');
2264: FND_MSG_PUB.ADD;
2265: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2266:
2267: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Total percentage of all disbursements: ' || l_sum_percent);

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

2264: FND_MSG_PUB.ADD;
2265: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2266:
2267: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Total percentage of all disbursements: ' || l_sum_percent);
2268: FND_MESSAGE.SET_NAME('LNS', 'LNS_DISB_HDR_PERC_INVALID');
2269: FND_MSG_PUB.ADD;
2270: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2271: RAISE FND_API.G_EXC_ERROR;
2272: end if;

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

2429: -- if no record exists - return; otherwise proceed
2430: if validate_cur%NOTFOUND then
2431:
2432: -- LogMessage(FND_LOG.LEVEL_STATEMENT, 'ERROR: Disbursement Header Record is not found');
2433: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
2434: FND_MESSAGE.SET_TOKEN('RECORD', 'disbursement header record');
2435: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(P_DISB_HEADER_ID), 'null'));
2436: FND_MSG_PUB.ADD;
2437: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

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

2430: if validate_cur%NOTFOUND then
2431:
2432: -- LogMessage(FND_LOG.LEVEL_STATEMENT, 'ERROR: Disbursement Header Record is not found');
2433: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
2434: FND_MESSAGE.SET_TOKEN('RECORD', 'disbursement header record');
2435: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(P_DISB_HEADER_ID), 'null'));
2436: FND_MSG_PUB.ADD;
2437: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2438: RAISE FND_API.G_EXC_ERROR;

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

2431:
2432: -- LogMessage(FND_LOG.LEVEL_STATEMENT, 'ERROR: Disbursement Header Record is not found');
2433: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
2434: FND_MESSAGE.SET_TOKEN('RECORD', 'disbursement header record');
2435: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(P_DISB_HEADER_ID), 'null'));
2436: FND_MSG_PUB.ADD;
2437: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2438: RAISE FND_API.G_EXC_ERROR;
2439:

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

2443:
2444: if l_DISB_HEADER_REC.ACTIVITY_CODE is null and l_DISB_HEADER_REC.DESCRIPTION is null then
2445:
2446: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Activity code is missing');
2447: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_ENTER_DISB_ACTIV' );
2448: FND_MSG_PUB.ADD;
2449: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2450: RAISE FND_API.G_EXC_ERROR;
2451:

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

2453:
2454: if l_DISB_HEADER_REC.HEADER_AMOUNT is null then
2455:
2456: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Disbursement percent is missing');
2457: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_ENTER_DISB_PERC' );
2458: FND_MSG_PUB.ADD;
2459: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2460: RAISE FND_API.G_EXC_ERROR;
2461:

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

2464: -- validate Payment request date
2465: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Payment request date: ' || l_DISB_HEADER_REC.PAYMENT_REQUEST_DATE);
2466: if l_DISB_HEADER_REC.PAYMENT_REQUEST_DATE is null then
2467: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Payment request date is missing');
2468: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_ENTER_PAY_REQ_DATE' );
2469: FND_MSG_PUB.ADD;
2470: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2471: RAISE FND_API.G_EXC_ERROR;
2472: end if;

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

2473:
2474: if trunc(l_DISB_HEADER_REC.PAYMENT_REQUEST_DATE) < trunc(l_open_start_date) then
2475:
2476: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Payment request date must be greater than open start date');
2477: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_PAY_REQ_DT_INVALID' );
2478: FND_MSG_PUB.ADD;
2479: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2480: RAISE FND_API.G_EXC_ERROR;
2481:

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

2484: -- validate that no lines without payment method
2485: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Number of lines without payment method: ' || l_no_pay_mtd_count);
2486: if l_no_pay_mtd_count > 0 then
2487: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'There are disb lines without payment method');
2488: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_ENTER_PAY_METHOD' );
2489: FND_MSG_PUB.ADD;
2490: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2491: RAISE FND_API.G_EXC_ERROR;
2492: end if;

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

2723:
2724: if l_DISB_LINE_REC.DISB_HEADER_ID is null then
2725:
2726: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Disbursement header is missing');
2727: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );
2728: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'disb_header_id' );
2729: FND_MSG_PUB.ADD;
2730: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2731: RAISE FND_API.G_EXC_ERROR;

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

2724: if l_DISB_LINE_REC.DISB_HEADER_ID is null then
2725:
2726: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Disbursement header is missing');
2727: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );
2728: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'disb_header_id' );
2729: FND_MSG_PUB.ADD;
2730: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2731: RAISE FND_API.G_EXC_ERROR;
2732:

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

2734:
2735: if l_DISB_LINE_REC.LINE_PERCENT is null then
2736:
2737: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Line percent is missing');
2738: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_ENTER_PAYEE_PERC' );
2739: FND_MSG_PUB.ADD;
2740: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2741: RAISE FND_API.G_EXC_ERROR;
2742:

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

2744:
2745: if l_DISB_LINE_REC.PAYEE_PARTY_ID is null then
2746:
2747: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Payee party ID is missing');
2748: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_ENTER_PAYEE' );
2749: FND_MSG_PUB.ADD;
2750: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2751: RAISE FND_API.G_EXC_ERROR;
2752:

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

2760: -- if no record exists - error; otherwise proceed
2761: if party_site_cur%NOTFOUND then
2762:
2763: -- LogMessage(FND_LOG.LEVEL_STATEMENT, 'ERROR: No site exist for the party');
2764: FND_MESSAGE.SET_NAME('LNS', 'LNS_CREATE_PARTY_SITE');
2765: FND_MSG_PUB.ADD;
2766: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2767: RAISE FND_API.G_EXC_ERROR;
2768:

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

2810:
2811: -- checking for total percent
2812: if l_sum_percent <> 100 then
2813: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Total percentage of all lines: ' || l_sum_percent);
2814: FND_MESSAGE.SET_NAME('LNS', 'LNS_DISB_LN_PERC_INVALID');
2815: FND_MESSAGE.SET_TOKEN('DISB_NUM', l_disb_number);
2816: FND_MSG_PUB.ADD;
2817: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2818: RAISE FND_API.G_EXC_ERROR;

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

2811: -- checking for total percent
2812: if l_sum_percent <> 100 then
2813: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Total percentage of all lines: ' || l_sum_percent);
2814: FND_MESSAGE.SET_NAME('LNS', 'LNS_DISB_LN_PERC_INVALID');
2815: FND_MESSAGE.SET_TOKEN('DISB_NUM', l_disb_number);
2816: FND_MSG_PUB.ADD;
2817: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2818: RAISE FND_API.G_EXC_ERROR;
2819: end if;

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

3082:
3083: if l_DISB_HEADER_REC.LOAN_ID is null then
3084:
3085: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Loan ID is missing');
3086: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );
3087: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'loan id' );
3088: FND_MSG_PUB.ADD;
3089: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
3090: RAISE FND_API.G_EXC_ERROR;

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

3083: if l_DISB_HEADER_REC.LOAN_ID is null then
3084:
3085: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Loan ID is missing');
3086: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );
3087: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'loan id' );
3088: FND_MSG_PUB.ADD;
3089: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
3090: RAISE FND_API.G_EXC_ERROR;
3091:

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

3093:
3094: if l_DISB_HEADER_REC.ACTIVITY_CODE is null and l_DISB_HEADER_REC.DESCRIPTION is null then
3095:
3096: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Activity code is missing');
3097: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_ENTER_DISB_ACTIV' );
3098: FND_MSG_PUB.ADD;
3099: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
3100: RAISE FND_API.G_EXC_ERROR;
3101:

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

3103:
3104: if l_DISB_HEADER_REC.HEADER_PERCENT is null and l_DISB_HEADER_REC.HEADER_AMOUNT is null then
3105:
3106: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Disbursement percent is missing');
3107: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_ENTER_DISB_PERC' );
3108: FND_MSG_PUB.ADD;
3109: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
3110: RAISE FND_API.G_EXC_ERROR;
3111:

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

3113:
3114: if l_DISB_HEADER_REC.TARGET_DATE is null and l_DISB_HEADER_REC.PHASE = 'OPEN' then
3115:
3116: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Target date is missing');
3117: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_ENTER_TARGET_DATE' );
3118: FND_MSG_PUB.ADD;
3119: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
3120: RAISE FND_API.G_EXC_ERROR;
3121:

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

3125: if (l_DISB_HEADER_REC.STATUS NOT IN ('CANCELLED','IN_FUNDING','FUNDING_ERROR','PARTIALLY_FUNDED','FULLY_FUNDED')
3126: AND ( trunc(l_DISB_HEADER_REC.PAYMENT_REQUEST_DATE) < trunc(sysdate))) then
3127:
3128: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Payment Request date is less than today');
3129: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_DISB_REQ_DATE_ERR' );
3130: FND_MSG_PUB.ADD;
3131: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
3132: RAISE FND_API.G_EXC_ERROR;
3133:

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

3136: if l_loan_status = 'INCOMPLETE' then
3137: if l_DISB_HEADER_REC.PHASE = 'OPEN' then
3138: if trunc(l_DISB_HEADER_REC.TARGET_DATE) < trunc(l_loan_start_date) then
3139: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Target date must be later that start date');
3140: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_DISB_TARGET_DATE_ERR' );
3141: FND_MSG_PUB.ADD;
3142: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
3143: RAISE FND_API.G_EXC_ERROR;
3144:

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

3145: end if;
3146: else
3147: if trunc(l_DISB_HEADER_REC.PAYMENT_REQUEST_DATE) < trunc(l_loan_start_date) then
3148: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Target date must be later that start date');
3149: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_DISB_TARGET_DATE_ERR' );
3150: FND_MSG_PUB.ADD;
3151: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
3152: RAISE FND_API.G_EXC_ERROR;
3153:

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

3210:
3211: -- checking for total percent
3212: if l_sum_percent <> 100 then
3213: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Total percentage of all disbursements: ' || l_sum_percent);
3214: FND_MESSAGE.SET_NAME('LNS', 'LNS_DISB_HDR_PERC_INVALID');
3215: FND_MSG_PUB.ADD;
3216: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
3217: RAISE FND_API.G_EXC_ERROR;
3218: end if;

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

3566: SAVEPOINT DEFAULT_PROD_DISBURSEMENTS;
3567:
3568: IF p_loan_id IS NULL THEN
3569: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'LOAN ID is missing');
3570: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );
3571: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'p_loan_id' );
3572: FND_MSG_PUB.ADD;
3573: RAISE FND_API.G_EXC_ERROR;
3574: END IF;

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

3567:
3568: IF p_loan_id IS NULL THEN
3569: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'LOAN ID is missing');
3570: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );
3571: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'p_loan_id' );
3572: FND_MSG_PUB.ADD;
3573: RAISE FND_API.G_EXC_ERROR;
3574: END IF;
3575:

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

3707: || G_PKG_NAME || '.' || l_api_name);
3708:
3709: WHEN OTHERS THEN
3710: ROLLBACK TO DEFAULT_PROD_DISBURSEMENTS;
3711: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
3712: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3713: FND_MSG_PUB.ADD;
3714:
3715: END DEFAULT_PROD_DISBURSEMENTS;

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

3708:
3709: WHEN OTHERS THEN
3710: ROLLBACK TO DEFAULT_PROD_DISBURSEMENTS;
3711: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
3712: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3713: FND_MSG_PUB.ADD;
3714:
3715: END DEFAULT_PROD_DISBURSEMENTS;
3716:

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

4411: ROLLBACK TO SUBMIT_SINGLE_PAY_REQ;
4412:
4413: if l_new_invoice = 'Y' then
4414: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Failed to insert invoice into interface table');
4415: FND_MESSAGE.SET_NAME('LNS', 'LNS_FAIL_INS_AP_INV');
4416: FND_MSG_PUB.Add;
4417: else
4418: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Failed to update invoice into interface table');
4419: FND_MESSAGE.SET_NAME('LNS', 'LNS_FAIL_UPD_AP_INV');

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

4415: FND_MESSAGE.SET_NAME('LNS', 'LNS_FAIL_INS_AP_INV');
4416: FND_MSG_PUB.Add;
4417: else
4418: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Failed to update invoice into interface table');
4419: FND_MESSAGE.SET_NAME('LNS', 'LNS_FAIL_UPD_AP_INV');
4420: FND_MSG_PUB.Add;
4421: end if;
4422:
4423: RAISE FND_API.G_EXC_ERROR;

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

4665: WHEN OTHERS THEN
4666: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Failed to insert invoice line into interface table');
4667: ROLLBACK TO SUBMIT_SINGLE_PAY_REQ;
4668:
4669: FND_MESSAGE.SET_NAME('LNS', 'LNS_FAIL_INS_AP_INV_LN');
4670: FND_MSG_PUB.Add;
4671: RAISE FND_API.G_EXC_ERROR;
4672: END;
4673:

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

4790: close get_party2_cur;
4791:
4792: end if;
4793:
4794: FND_MESSAGE.SET_NAME('LNS', 'LNS_DISB_REJECTION');
4795: FND_MESSAGE.SET_TOKEN('PAYEE', l_payee);
4796: FND_MESSAGE.SET_TOKEN('REJECTION', l_reject_desc);
4797: FND_MSG_PUB.Add;
4798:

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

4791:
4792: end if;
4793:
4794: FND_MESSAGE.SET_NAME('LNS', 'LNS_DISB_REJECTION');
4795: FND_MESSAGE.SET_TOKEN('PAYEE', l_payee);
4796: FND_MESSAGE.SET_TOKEN('REJECTION', l_reject_desc);
4797: FND_MSG_PUB.Add;
4798:
4799: END LOOP;

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

4792: end if;
4793:
4794: FND_MESSAGE.SET_NAME('LNS', 'LNS_DISB_REJECTION');
4795: FND_MESSAGE.SET_TOKEN('PAYEE', l_payee);
4796: FND_MESSAGE.SET_TOKEN('REJECTION', l_reject_desc);
4797: FND_MSG_PUB.Add;
4798:
4799: END LOOP;
4800:

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

5185: -- if no record exists - return; otherwise proceed
5186: if loan_detail_cur%NOTFOUND then
5187:
5188: -- LogMessage(FND_LOG.LEVEL_STATEMENT, 'ERROR: Loan Record is not found');
5189: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
5190: FND_MESSAGE.SET_TOKEN('RECORD', 'loan header');
5191: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(P_DISB_HEADER_ID), 'null'));
5192: FND_MSG_PUB.ADD;
5193: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

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

5186: if loan_detail_cur%NOTFOUND then
5187:
5188: -- LogMessage(FND_LOG.LEVEL_STATEMENT, 'ERROR: Loan Record is not found');
5189: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
5190: FND_MESSAGE.SET_TOKEN('RECORD', 'loan header');
5191: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(P_DISB_HEADER_ID), 'null'));
5192: FND_MSG_PUB.ADD;
5193: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
5194: RAISE FND_API.G_EXC_ERROR;

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

5187:
5188: -- LogMessage(FND_LOG.LEVEL_STATEMENT, 'ERROR: Loan Record is not found');
5189: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
5190: FND_MESSAGE.SET_TOKEN('RECORD', 'loan header');
5191: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(P_DISB_HEADER_ID), 'null'));
5192: FND_MSG_PUB.ADD;
5193: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
5194: RAISE FND_API.G_EXC_ERROR;
5195:

Line 5231: FND_MESSAGE.SET_NAME('LNS', 'LNS_SUBMIT_DISB_FUNDS_UNRESERV');

5227: RAISE FND_API.G_EXC_ERROR;
5228: ELSE
5229: -- Bug#9964875
5230: IF (l_status_code = 'FAIL' or l_status_code = 'PARTIAL' or l_status_code = 'XLA_ERROR') THEN
5231: FND_MESSAGE.SET_NAME('LNS', 'LNS_SUBMIT_DISB_FUNDS_UNRESERV');
5232: FND_MSG_PUB.Add;
5233: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
5234: RAISE FND_API.G_EXC_ERROR;
5235: END IF;

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

5256: fetch conditions_cur into l_cond_count;
5257: close conditions_cur;
5258:
5259: if l_cond_count > 0 then
5260: FND_MESSAGE.SET_NAME('LNS', 'LNS_NOT_ALL_COND_MET');
5261: FND_MSG_PUB.Add;
5262: RAISE FND_API.G_EXC_ERROR;
5263: end if;
5264:

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

5363:
5364: IF l_return_status = 'S' THEN
5365: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_LOAN_HEADERS_ALL');
5366: ELSE
5367: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
5368: FND_MSG_PUB.Add;
5369: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
5370: -- RAISE FND_API.G_EXC_ERROR;
5371: END IF;

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

5385: ,X_MSG_DATA => l_msg_data);
5386:
5387: logMessage(FND_LOG.LEVEL_STATEMENT, 'l_return_status: ' || l_return_status);
5388: IF l_return_status <> 'S' THEN
5389: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
5390: FND_MESSAGE.SET_TOKEN('ERROR' ,'Call to lns_distributions_pub.submit_disbursement_bc failed for acitivity = LNS_SUBMIT_DISBURSEMENT');
5391: FND_MSG_PUB.ADD;
5392: logMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
5393: RAISE FND_API.G_EXC_ERROR;

Line 5390: FND_MESSAGE.SET_TOKEN('ERROR' ,'Call to lns_distributions_pub.submit_disbursement_bc failed for acitivity = LNS_SUBMIT_DISBURSEMENT');

5386:
5387: logMessage(FND_LOG.LEVEL_STATEMENT, 'l_return_status: ' || l_return_status);
5388: IF l_return_status <> 'S' THEN
5389: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
5390: FND_MESSAGE.SET_TOKEN('ERROR' ,'Call to lns_distributions_pub.submit_disbursement_bc failed for acitivity = LNS_SUBMIT_DISBURSEMENT');
5391: FND_MSG_PUB.ADD;
5392: logMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
5393: RAISE FND_API.G_EXC_ERROR;
5394: END IF;

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

5421: x_return_status := FND_API.G_RET_STS_ERROR;
5422: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
5423:
5424: if x_msg_count = 0 then
5425: FND_MESSAGE.SET_NAME('LNS', 'LNS_SUBMIT_DISB_FAILED');
5426: FND_MSG_PUB.Add;
5427: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
5428: end if;
5429:

Line 5858: FND_MESSAGE.SET_NAME('LNS', 'LNS_FUND_AGREEMENT_REASON1');

5854: LogMessage(FND_LOG.LEVEL_STATEMENT, 'DISBURSEMENT_DATE: ' || l_DISB_LINE_REC.DISBURSEMENT_DATE);
5855:
5856: -- Retrieve agreement reason
5857: l_agreement_reason := null;
5858: FND_MESSAGE.SET_NAME('LNS', 'LNS_FUND_AGREEMENT_REASON1');
5859: FND_MESSAGE.SET_TOKEN('DISB', l_disb_desc);
5860: FND_MESSAGE.SET_TOKEN('DATE', l_DISB_LINE_REC.DISBURSEMENT_DATE);
5861: FND_MESSAGE.SET_TOKEN('AMOUNT', to_char(l_inv_paid_amount, FND_CURRENCY.SAFE_GET_FORMAT_MASK(l_currency,50)));
5862: FND_MESSAGE.SET_TOKEN('CURR', l_currency);

Line 5859: FND_MESSAGE.SET_TOKEN('DISB', l_disb_desc);

5855:
5856: -- Retrieve agreement reason
5857: l_agreement_reason := null;
5858: FND_MESSAGE.SET_NAME('LNS', 'LNS_FUND_AGREEMENT_REASON1');
5859: FND_MESSAGE.SET_TOKEN('DISB', l_disb_desc);
5860: FND_MESSAGE.SET_TOKEN('DATE', l_DISB_LINE_REC.DISBURSEMENT_DATE);
5861: FND_MESSAGE.SET_TOKEN('AMOUNT', to_char(l_inv_paid_amount, FND_CURRENCY.SAFE_GET_FORMAT_MASK(l_currency,50)));
5862: FND_MESSAGE.SET_TOKEN('CURR', l_currency);
5863: FND_MSG_PUB.Add;

Line 5860: FND_MESSAGE.SET_TOKEN('DATE', l_DISB_LINE_REC.DISBURSEMENT_DATE);

5856: -- Retrieve agreement reason
5857: l_agreement_reason := null;
5858: FND_MESSAGE.SET_NAME('LNS', 'LNS_FUND_AGREEMENT_REASON1');
5859: FND_MESSAGE.SET_TOKEN('DISB', l_disb_desc);
5860: FND_MESSAGE.SET_TOKEN('DATE', l_DISB_LINE_REC.DISBURSEMENT_DATE);
5861: FND_MESSAGE.SET_TOKEN('AMOUNT', to_char(l_inv_paid_amount, FND_CURRENCY.SAFE_GET_FORMAT_MASK(l_currency,50)));
5862: FND_MESSAGE.SET_TOKEN('CURR', l_currency);
5863: FND_MSG_PUB.Add;
5864: l_agreement_reason := FND_MSG_PUB.Get(p_encoded => 'F');

Line 5861: FND_MESSAGE.SET_TOKEN('AMOUNT', to_char(l_inv_paid_amount, FND_CURRENCY.SAFE_GET_FORMAT_MASK(l_currency,50)));

5857: l_agreement_reason := null;
5858: FND_MESSAGE.SET_NAME('LNS', 'LNS_FUND_AGREEMENT_REASON1');
5859: FND_MESSAGE.SET_TOKEN('DISB', l_disb_desc);
5860: FND_MESSAGE.SET_TOKEN('DATE', l_DISB_LINE_REC.DISBURSEMENT_DATE);
5861: FND_MESSAGE.SET_TOKEN('AMOUNT', to_char(l_inv_paid_amount, FND_CURRENCY.SAFE_GET_FORMAT_MASK(l_currency,50)));
5862: FND_MESSAGE.SET_TOKEN('CURR', l_currency);
5863: FND_MSG_PUB.Add;
5864: l_agreement_reason := FND_MSG_PUB.Get(p_encoded => 'F');
5865: FND_MSG_PUB.DELETE_MSG(FND_MSG_PUB.COUNT_MSG);

Line 5862: FND_MESSAGE.SET_TOKEN('CURR', l_currency);

5858: FND_MESSAGE.SET_NAME('LNS', 'LNS_FUND_AGREEMENT_REASON1');
5859: FND_MESSAGE.SET_TOKEN('DISB', l_disb_desc);
5860: FND_MESSAGE.SET_TOKEN('DATE', l_DISB_LINE_REC.DISBURSEMENT_DATE);
5861: FND_MESSAGE.SET_TOKEN('AMOUNT', to_char(l_inv_paid_amount, FND_CURRENCY.SAFE_GET_FORMAT_MASK(l_currency,50)));
5862: FND_MESSAGE.SET_TOKEN('CURR', l_currency);
5863: FND_MSG_PUB.Add;
5864: l_agreement_reason := FND_MSG_PUB.Get(p_encoded => 'F');
5865: FND_MSG_PUB.DELETE_MSG(FND_MSG_PUB.COUNT_MSG);
5866:

Line 5944: FND_MESSAGE.SET_NAME('LNS', 'LNS_FUND_AGREEMENT_REASON2');

5940: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'New LOAN_MATURITY_DATE: ' || l_loan_details.maturity_date);
5941:
5942: if l_dates_shifted_flag = 'Y' then
5943: -- Retrieve agreement reason
5944: FND_MESSAGE.SET_NAME('LNS', 'LNS_FUND_AGREEMENT_REASON2');
5945: FND_MSG_PUB.Add;
5946: l_agreement_reason := l_agreement_reason || FND_MSG_PUB.Get(p_encoded => 'F');
5947: FND_MSG_PUB.DELETE_MSG(FND_MSG_PUB.COUNT_MSG);
5948: end if;

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

5970: IF l_return_status = 'S' THEN
5971: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_TERMS');
5972: ELSE
5973: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: LNS_TERMS_PUB.update_term returned error: ' || substr(l_msg_data,1,225));
5974: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_TERM_FAIL');
5975: FND_MSG_PUB.Add;
5976: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
5977: RAISE FND_API.G_EXC_ERROR;
5978: END IF;

Line 6026: FND_MESSAGE.SET_NAME('LNS', 'LNS_FUND_AGREEMENT_REASON3');

6022: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'New maturity_date: ' || l_loan_details.maturity_date);
6023: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_dates_shifted_flag: ' || l_dates_shifted_flag);
6024:
6025: -- Retrieve agreement reason
6026: FND_MESSAGE.SET_NAME('LNS', 'LNS_FUND_AGREEMENT_REASON3');
6027: FND_MSG_PUB.Add;
6028: l_agreement_reason := l_agreement_reason || FND_MSG_PUB.Get(p_encoded => 'F');
6029: FND_MSG_PUB.DELETE_MSG(FND_MSG_PUB.COUNT_MSG);
6030:

Line 6033: FND_MESSAGE.SET_NAME('LNS', 'LNS_FUND_AGREEMENT_REASON2');

6029: FND_MSG_PUB.DELETE_MSG(FND_MSG_PUB.COUNT_MSG);
6030:
6031: if l_dates_shifted_flag = 'Y' then
6032: -- Retrieve agreement reason
6033: FND_MESSAGE.SET_NAME('LNS', 'LNS_FUND_AGREEMENT_REASON2');
6034: FND_MSG_PUB.Add;
6035: l_agreement_reason := l_agreement_reason || FND_MSG_PUB.Get(p_encoded => 'F');
6036: FND_MSG_PUB.DELETE_MSG(FND_MSG_PUB.COUNT_MSG);
6037: end if;

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

6067: IF l_return_status = 'S' THEN
6068: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_TERMS');
6069: ELSE
6070: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: LNS_TERMS_PUB.update_term returned error: ' || substr(l_msg_data,1,225));
6071: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_TERM_FAIL');
6072: FND_MSG_PUB.Add;
6073: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
6074: RAISE FND_API.G_EXC_ERROR;
6075: END IF;

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

6108:
6109: IF l_return_status = 'S' THEN
6110: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_LOAN_HEADERS_ALL');
6111: ELSE
6112: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
6113: FND_MSG_PUB.Add;
6114: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
6115: RAISE FND_API.G_EXC_ERROR;
6116: END IF;

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

6150:
6151: IF l_return_status = 'S' THEN
6152: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_LOAN_HEADERS_ALL');
6153: ELSE
6154: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
6155: FND_MSG_PUB.Add;
6156: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
6157: RAISE FND_API.G_EXC_ERROR;
6158: END IF;

Line 6210: FND_MESSAGE.SET_NAME('LNS', 'LNS_FUND_AGREEMENT_REASON2');

6206: LogMessage(FND_LOG.LEVEL_STATEMENT, 'NEXT_PAYMENT_DUE_DATE: ' || l_term_rec.NEXT_PAYMENT_DUE_DATE);
6207:
6208: if l_dates_shifted_flag = 'Y' then
6209: -- Retrieve agreement reason
6210: FND_MESSAGE.SET_NAME('LNS', 'LNS_FUND_AGREEMENT_REASON2');
6211: FND_MSG_PUB.Add;
6212: l_agreement_reason := l_agreement_reason || FND_MSG_PUB.Get(p_encoded => 'F');
6213: FND_MSG_PUB.DELETE_MSG(FND_MSG_PUB.COUNT_MSG);
6214: end if;

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

6225: IF l_return_status = 'S' THEN
6226: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_TERMS');
6227: ELSE
6228: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: LNS_TERMS_PUB.update_term returned error: ' || substr(l_msg_data,1,225));
6229: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_TERM_FAIL');
6230: FND_MSG_PUB.Add;
6231: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
6232: RAISE FND_API.G_EXC_ERROR;
6233: END IF;

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

6273:
6274: IF l_return_status = 'S' THEN
6275: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_LOAN_HEADERS_ALL');
6276: ELSE
6277: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
6278: FND_MSG_PUB.Add;
6279: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
6280: RAISE FND_API.G_EXC_ERROR;
6281: END IF;

Line 6344: FND_MESSAGE.SET_NAME('LNS', 'LNS_PROCESS_FEE_ERROR');

6340: ,x_msg_count => l_msg_count
6341: ,x_msg_data => l_msg_data);
6342:
6343: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
6344: FND_MESSAGE.SET_NAME('LNS', 'LNS_PROCESS_FEE_ERROR');
6345: FND_MSG_PUB.ADD;
6346: RAISE FND_API.G_EXC_ERROR;
6347: end if;
6348:

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

6398:
6399: if l_request_id = 0 then
6400:
6401: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Failed to start Billing Concurrent Program.');
6402: FND_MESSAGE.SET_NAME('LNS', 'LNS_BILLING_REQUEST_FAILED');
6403: FND_MSG_PUB.Add;
6404: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
6405: RAISE FND_API.G_EXC_ERROR;
6406:

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

6962: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_original_prepayment_amount: ' || l_original_prepayment_amount);
6963: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_pay_curr_invoice_amount: ' || l_pay_curr_invoice_amount);
6964:
6965: IF NOT l_success THEN
6966: FND_MESSAGE.SET_NAME('SQLAP4', l_message_name);
6967: FND_MESSAGE.SET_TOKEN('ERROR', l_Token);
6968: FND_MSG_PUB.ADD;
6969: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
6970: RAISE FND_API.G_EXC_ERROR;

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

6963: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_pay_curr_invoice_amount: ' || l_pay_curr_invoice_amount);
6964:
6965: IF NOT l_success THEN
6966: FND_MESSAGE.SET_NAME('SQLAP4', l_message_name);
6967: FND_MESSAGE.SET_TOKEN('ERROR', l_Token);
6968: FND_MSG_PUB.ADD;
6969: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
6970: RAISE FND_API.G_EXC_ERROR;
6971: ELSE

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

7076: ,X_MSG_DATA => l_msg_data);
7077:
7078: logMessage(FND_LOG.LEVEL_STATEMENT, 'l_return_status: ' || l_return_status);
7079: IF l_return_status <> 'S' THEN
7080: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
7081: FND_MESSAGE.SET_TOKEN('ERROR' ,'Call to lns_distributions_pub.submit_disbursement_bc failed for acitivity = LNS_SUBMITTED_DISB_CANCEL');
7082: FND_MSG_PUB.ADD;
7083: logMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
7084: RAISE FND_API.G_EXC_ERROR;

Line 7081: FND_MESSAGE.SET_TOKEN('ERROR' ,'Call to lns_distributions_pub.submit_disbursement_bc failed for acitivity = LNS_SUBMITTED_DISB_CANCEL');

7077:
7078: logMessage(FND_LOG.LEVEL_STATEMENT, 'l_return_status: ' || l_return_status);
7079: IF l_return_status <> 'S' THEN
7080: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
7081: FND_MESSAGE.SET_TOKEN('ERROR' ,'Call to lns_distributions_pub.submit_disbursement_bc failed for acitivity = LNS_SUBMITTED_DISB_CANCEL');
7082: FND_MSG_PUB.ADD;
7083: logMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
7084: RAISE FND_API.G_EXC_ERROR;
7085: END IF;

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

7321:
7322: IF l_return_status = 'S' THEN
7323: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_LOAN_HEADERS_ALL');
7324: ELSE
7325: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
7326: FND_MSG_PUB.Add;
7327: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
7328: RAISE FND_API.G_EXC_ERROR;
7329: END IF;

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

7525:
7526: IF l_return_status = 'S' THEN
7527: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_LOAN_HEADERS_ALL');
7528: ELSE
7529: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
7530: FND_MSG_PUB.Add;
7531: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
7532: RAISE FND_API.G_EXC_ERROR;
7533: END IF;

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

7707:
7708: IF l_return_status = 'S' THEN
7709: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_LOAN_HEADERS_ALL');
7710: ELSE
7711: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
7712: FND_MSG_PUB.Add;
7713: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
7714: RAISE FND_API.G_EXC_ERROR;
7715: END IF;

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

8331:
8332: if P_AUTOFUNDING_FLAG = 'Y' then
8333:
8334: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'No disbursement header record found');
8335: FND_MESSAGE.SET_NAME('LNS', 'LNS_CREATE_DISB_SCHED');
8336: FND_MSG_PUB.ADD;
8337: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
8338: RAISE FND_API.G_EXC_ERROR;
8339:

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

8383: fetch conditions_cur into l_cond_count;
8384: close conditions_cur;
8385:
8386: if l_cond_count > 0 then
8387: FND_MESSAGE.SET_NAME('LNS', 'LNS_AUTOFUND_AND_MAND_CONDIT');
8388: FND_MSG_PUB.Add;
8389: RAISE FND_API.G_EXC_ERROR;
8390: end if;
8391:

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

9168: fetch in_fund_count_cur into l_in_funding_count;
9169: close in_fund_count_cur;
9170:
9171: if l_in_funding_count > 0 then
9172: FND_MESSAGE.SET_NAME('LNS', 'LNS_CANT_PAYOFF_IN_FUND');
9173: FND_MSG_PUB.Add;
9174: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
9175: RAISE FND_API.G_EXC_ERROR;
9176: end if;

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

9627:
9628: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_return_status: ' || l_return_status);
9629:
9630: IF l_return_status <> 'S' THEN
9631: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
9632: FND_MSG_PUB.Add;
9633: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
9634: RAISE FND_API.G_EXC_ERROR;
9635: END IF;

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

9736: -- START OF BODY OF API
9737:
9738: IF P_LOAN_ID IS NULL THEN
9739: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'LOAN ID is missing');
9740: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );
9741: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'P_LOAN_ID' );
9742: FND_MSG_PUB.ADD;
9743: RAISE FND_API.G_EXC_ERROR;
9744: END IF;

Line 9741: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'P_LOAN_ID' );

9737:
9738: IF P_LOAN_ID IS NULL THEN
9739: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'LOAN ID is missing');
9740: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );
9741: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'P_LOAN_ID' );
9742: FND_MSG_PUB.ADD;
9743: RAISE FND_API.G_EXC_ERROR;
9744: END IF;
9745:

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

9744: END IF;
9745:
9746: IF P_AMOUNT IS NULL THEN
9747: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'AMOUNT is missing');
9748: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );
9749: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'P_AMOUNT' );
9750: FND_MSG_PUB.ADD;
9751: RAISE FND_API.G_EXC_ERROR;
9752: END IF;

Line 9749: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'P_AMOUNT' );

9745:
9746: IF P_AMOUNT IS NULL THEN
9747: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'AMOUNT is missing');
9748: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );
9749: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'P_AMOUNT' );
9750: FND_MSG_PUB.ADD;
9751: RAISE FND_API.G_EXC_ERROR;
9752: END IF;
9753:

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

9752: END IF;
9753:
9754: IF P_DUE_DATE IS NULL THEN
9755: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'DUE_DATE is missing');
9756: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );
9757: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'P_DUE_DATE' );
9758: FND_MSG_PUB.ADD;
9759: RAISE FND_API.G_EXC_ERROR;
9760: END IF;

Line 9757: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'P_DUE_DATE' );

9753:
9754: IF P_DUE_DATE IS NULL THEN
9755: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'DUE_DATE is missing');
9756: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );
9757: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'P_DUE_DATE' );
9758: FND_MSG_PUB.ADD;
9759: RAISE FND_API.G_EXC_ERROR;
9760: END IF;
9761: