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

APPS.LNS_APPROVAL_ACTION_PUB dependencies on FND_MSG_PUB

Line 103: FND_MSG_PUB.ADD;

99: WHERE action_id = l_action_id;
100:
101: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_DUPLICATE_COLUMN');
102: FND_MESSAGE.SET_TOKEN('COLUMN', 'action_id');
103: FND_MSG_PUB.ADD;
104: RAISE FND_API.G_EXC_ERROR;
105:
106: EXCEPTION
107: WHEN NO_DATA_FOUND THEN

Line 210: FND_MSG_PUB.ADD;

206: )
207: THEN
208: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_RECORD_CHANGED');
209: FND_MESSAGE.SET_TOKEN('TABLE', 'lns_approval_actions');
210: FND_MSG_PUB.ADD;
211: RAISE FND_API.G_EXC_ERROR;
212: END IF;
213:
214: p_object_version_number := nvl(l_object_version_number, 1) + 1;

Line 220: FND_MSG_PUB.ADD;

216: EXCEPTION WHEN NO_DATA_FOUND THEN
217: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
218: FND_MESSAGE.SET_TOKEN('RECORD', 'approval action_rec');
219: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_approval_action_rec.action_id), 'null'));
220: FND_MSG_PUB.ADD;
221: RAISE FND_API.G_EXC_ERROR;
222: END;
223:
224: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In do_update_approval_action procedure: Before call to LNS_APPROVAL_ACTIONS_PKG.Update_Row');

Line 323: FND_MSG_PUB.ADD;

319: WHEN NO_DATA_FOUND THEN
320: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
321: FND_MESSAGE.SET_TOKEN('RECORD', 'approval action_rec');
322: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_action_id), 'null'));
323: FND_MSG_PUB.ADD;
324: RAISE FND_API.G_EXC_ERROR;
325: END;
326: END IF;
327:

Line 358: FND_MSG_PUB.ADD;

354: FETCH C_Check_Fee_Violation INTO l_dummy;
355: IF C_Check_Fee_Violation%FOUND THEN
356: x_return_status := FND_API.G_RET_STS_ERROR;
357: FND_MESSAGE.SET_NAME('LNS', 'LNS_NEGATIVE_NUMBER_ERROR');
358: FND_MSG_PUB.ADD;
359: CLOSE C_Check_Fee_Violation;
360: RAISE FND_API.G_EXC_ERROR;
361:
362: END IF;

Line 577: FND_MSG_PUB.initialize;

573: SAVEPOINT create_approval_action;
574:
575: -- initialize message list if p_init_msg_list is set to TRUE.
576: IF FND_API.to_Boolean(p_init_msg_list) THEN
577: FND_MSG_PUB.initialize;
578: END IF;
579:
580: -- initialize API return status to success.
581: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 624: FND_MSG_PUB.ADD;

620: IF C_Get_Loan_Info%NOTFOUND THEN
621: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
622: FND_MESSAGE.SET_TOKEN('RECORD', 'loan header');
623: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(l_loan_header_rec.loan_id), 'null'));
624: FND_MSG_PUB.ADD;
625: CLOSE C_Get_Loan_Info;
626: l_last_api_called := 'C_Get_Loan_Info';
627: RAISE FND_API.G_EXC_ERROR;
628: END IF;

Line 684: FND_MSG_PUB.ADD;

680:
681: ELSE
682: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_INVALID_STATUS');
683: FND_MESSAGE.SET_TOKEN('VALUE', l_status);
684: FND_MSG_PUB.ADD;
685: RAISE FND_API.G_EXC_ERROR;
686: END IF;
687:
688: ELSIF (l_approval_action_rec.action_type = 'SUBMIT_FOR_CONV') THEN

Line 694: FND_MSG_PUB.ADD;

690: l_loan_header_rec.secondary_status := 'PENDING_CONVERSION';
691: ELSE
692: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_INVALID_STATUS');
693: FND_MESSAGE.SET_TOKEN('VALUE', l_status);
694: FND_MSG_PUB.ADD;
695: RAISE FND_API.G_EXC_ERROR;
696: END IF;
697:
698: ELSIF (l_approval_action_rec.action_type = 'SUBMIT_FOR_CNCL') THEN

Line 721: FND_MSG_PUB.ADD;

717: END IF;
718: ELSE
719: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_INVALID_STATUS');
720: FND_MESSAGE.SET_TOKEN('VALUE', l_status);
721: FND_MSG_PUB.ADD;
722: RAISE FND_API.G_EXC_ERROR;
723: END IF;
724:
725: ELSIF (l_approval_action_rec.action_type = 'APPROVE') THEN

Line 798: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - LNS_FINANCIALS.shiftLoanDates failed with message: ' ||FND_MSG_PUB.Get(p_encoded => 'F'));

794: ,x_msg_count => x_msg_count
795: ,x_msg_data => x_msg_data);
796:
797: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
798: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - LNS_FINANCIALS.shiftLoanDates failed with message: ' ||FND_MSG_PUB.Get(p_encoded => 'F'));
799: l_last_api_called := 'LNS_FINANCIALS.shiftLoanDates';
800: RAISE FND_API.G_EXC_ERROR;
801: END IF;
802:

Line 837: FND_MSG_PUB.Add;

833: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
834: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Successfully update LNS_TERMS');
835: ELSE
836: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_TERM_FAIL');
837: FND_MSG_PUB.Add;
838: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - LNS_TERMS_PUB.update_term failed with message: ' || FND_MSG_PUB.Get(p_encoded => 'F'));
839: l_last_api_called := 'LNS_TERMS_PUB.update_term';
840: RAISE FND_API.G_EXC_ERROR;
841: END IF;

Line 838: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - LNS_TERMS_PUB.update_term failed with message: ' || FND_MSG_PUB.Get(p_encoded => 'F'));

834: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Successfully update LNS_TERMS');
835: ELSE
836: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_TERM_FAIL');
837: FND_MSG_PUB.Add;
838: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - LNS_TERMS_PUB.update_term failed with message: ' || FND_MSG_PUB.Get(p_encoded => 'F'));
839: l_last_api_called := 'LNS_TERMS_PUB.update_term';
840: RAISE FND_API.G_EXC_ERROR;
841: END IF;
842:

Line 877: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - lns_fee_engine.processDisbursementFees to process Conversion fees for TERM phase failed with message: ' ||FND_MSG_PUB.Get(p_encoded => 'F'));

873:
874: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - lns_fee_engine.processDisbursementFees to process Conversion fees for permanent conversion to TERM phase');
875:
876: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
877: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - lns_fee_engine.processDisbursementFees to process Conversion fees for TERM phase failed with message: ' ||FND_MSG_PUB.Get(p_encoded => 'F'));
878: l_last_api_called := 'lns_fee_engine.processDisbursementFees';
879: RAISE FND_API.G_EXC_ERROR;
880: END IF;
881: */

Line 887: FND_MSG_PUB.ADD;

883:
884: ELSE
885: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_INVALID_STATUS');
886: FND_MESSAGE.SET_TOKEN('VALUE', l_status);
887: FND_MSG_PUB.ADD;
888: RAISE FND_API.G_EXC_ERROR;
889: END IF;
890:
891: ELSIF (l_approval_action_rec.action_type = 'REJECT') THEN

Line 923: FND_MSG_PUB.ADD;

919: l_loan_header_rec.secondary_status := nvl(l_prev_sec_status,FND_API.G_MISS_CHAR);
920: ELSE
921: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_INVALID_STATUS');
922: FND_MESSAGE.SET_TOKEN('VALUE', l_status);
923: FND_MSG_PUB.ADD;
924: RAISE FND_API.G_EXC_ERROR;
925: END IF;
926:
927: ELSIF (l_approval_action_rec.action_type = 'REQUEST_FOR_INFO') THEN

Line 1023: FND_MSG_PUB.ADD;

1019: end if;
1020: ELSE
1021: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_INVALID_STATUS');
1022: FND_MESSAGE.SET_TOKEN('VALUE', l_status);
1023: FND_MSG_PUB.ADD;
1024: RAISE FND_API.G_EXC_ERROR;
1025: END IF;
1026: --This code is passed from workflow AME Approval process for just creating Loan Approval Action
1027: --for the current approver.

Line 1089: --FND_MSG_PUB.initialize;

1085: ,x_msg_count => x_msg_count
1086: ,x_msg_data => x_msg_data);
1087: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Call to Lns_distributions_pub.budgetary_control return status ' || x_return_status);
1088: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'l_budgetary_status' || l_budgetary_status);
1089: --FND_MSG_PUB.initialize;
1090: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
1091: RAISE FND_API.G_EXC_ERROR;
1092:
1093: else -- BC Call Returned 'S'

Line 1104: FND_MSG_PUB.initialize;

1100: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'budget required: NO BUDGET');
1101: RAISE FND_API.G_EXC_ERROR;
1102: else
1103: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'NO BUDGET');
1104: FND_MSG_PUB.initialize;
1105: l_loan_header_rec.secondary_status := 'NO_BUDGET';
1106: end if;
1107:
1108: end if;

Line 1244: FND_MSG_PUB.Add;

1240:
1241: if l_request_id = 0 then
1242: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1243: FND_MESSAGE.SET_NAME('LNS', 'LNS_AGREEMENT_REQUEST_FAILED');
1244: FND_MSG_PUB.Add;
1245: l_last_api_called := 'FND_REQUEST.SUBMIT_REQUEST for Loan Agreement Report Generation';
1246: RAISE FND_API.G_EXC_ERROR;
1247: else
1248: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Successfully submited Loan Agreement Report Generation Concurrent Program. Request id: ' || l_request_id);

Line 1272: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - LNS_LOAN_HEADER_PUB.update_loan failed with message: ' ||FND_MSG_PUB.Get(p_encoded => 'F'));

1268: ,x_msg_data => x_msg_data);
1269: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - After call to LNS_LOAN_HEADER_PUB.update_loan proc');
1270: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - x_return_status = ' || x_return_status);
1271: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1272: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - LNS_LOAN_HEADER_PUB.update_loan failed with message: ' ||FND_MSG_PUB.Get(p_encoded => 'F'));
1273: l_last_api_called := 'LNS_LOAN_HEADER_PUB.update_loan';
1274: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1275: END IF;
1276:

Line 1307: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - LNS_LOAN_HEADER_PUB.update_loan failed with message: ' ||FND_MSG_PUB.Get(p_encoded => 'F'));

1303: ,x_msg_data => x_msg_data);
1304: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - After call to LNS_LOAN_HEADER_PUB.update_loan 2 proc');
1305: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - x_return_status = ' || x_return_status);
1306: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1307: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - LNS_LOAN_HEADER_PUB.update_loan failed with message: ' ||FND_MSG_PUB.Get(p_encoded => 'F'));
1308: l_last_api_called := 'LNS_LOAN_HEADER_PUB.update_loan';
1309: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1310: END IF;
1311:

Line 1327: FND_MSG_PUB.ADD;

1323: x_return_status := FND_API.G_RET_STS_ERROR;
1324: if l_last_api_called is not null then
1325: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
1326: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed API call: ' || l_last_api_called || ' SQLERRM: ' || SQLERRM);
1327: FND_MSG_PUB.ADD;
1328: end if;
1329: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1330: p_count => x_msg_count,
1331: p_data => x_msg_data);

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

1325: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
1326: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed API call: ' || l_last_api_called || ' SQLERRM: ' || SQLERRM);
1327: FND_MSG_PUB.ADD;
1328: end if;
1329: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1330: p_count => x_msg_count,
1331: p_data => x_msg_data);
1332:
1333: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1339: FND_MSG_PUB.ADD;

1335: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1336: if l_last_api_called is not null then
1337: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
1338: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed API call: ' || l_last_api_called || ' SQLERRM: ' || SQLERRM);
1339: FND_MSG_PUB.ADD;
1340: end if;
1341: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1342: p_count => x_msg_count,
1343: p_data => x_msg_data);

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

1337: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
1338: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed API call: ' || l_last_api_called || ' SQLERRM: ' || SQLERRM);
1339: FND_MSG_PUB.ADD;
1340: end if;
1341: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1342: p_count => x_msg_count,
1343: p_data => x_msg_data);
1344:
1345: WHEN OTHERS THEN

Line 1351: FND_MSG_PUB.ADD;

1347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1348: if l_last_api_called is not null then
1349: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
1350: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1351: FND_MSG_PUB.ADD;
1352: end if;
1353: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1354: p_count => x_msg_count,
1355: p_data => x_msg_data);

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

1349: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
1350: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1351: FND_MSG_PUB.ADD;
1352: end if;
1353: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1354: p_count => x_msg_count,
1355: p_data => x_msg_data);
1356:
1357: END create_approval_action;

Line 1409: FND_MSG_PUB.initialize;

1405: SAVEPOINT update_approval_action;
1406:
1407: -- initialize message list if p_init_msg_list is set to TRUE.
1408: IF FND_API.to_Boolean(p_init_msg_list) THEN
1409: FND_MSG_PUB.initialize;
1410: END IF;
1411:
1412: -- initialize API return status to success.
1413: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1439: EXCEPTION
1440: WHEN FND_API.G_EXC_ERROR THEN
1441: ROLLBACK TO update_approval_action;
1442: x_return_status := FND_API.G_RET_STS_ERROR;
1443: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1444: p_count => x_msg_count,
1445: p_data => x_msg_data);
1446:
1447: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1446:
1447: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1448: ROLLBACK TO update_approval_action;
1449: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1450: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1451: p_count => x_msg_count,
1452: p_data => x_msg_data);
1453:
1454: WHEN OTHERS THEN

Line 1459: FND_MSG_PUB.ADD;

1455: ROLLBACK TO update_approval_action;
1456: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1457: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
1458: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1459: FND_MSG_PUB.ADD;
1460: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1461: p_count => x_msg_count,
1462: p_data => x_msg_data);
1463:

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

1456: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1457: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
1458: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1459: FND_MSG_PUB.ADD;
1460: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1461: p_count => x_msg_count,
1462: p_data => x_msg_data);
1463:
1464: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'End Update_approval_action procedure');

Line 1516: FND_MSG_PUB.initialize;

1512: SAVEPOINT delete_approval_action;
1513:
1514: -- initialize message list if p_init_msg_list is set to TRUE.
1515: IF FND_API.to_Boolean(p_init_msg_list) THEN
1516: FND_MSG_PUB.initialize;
1517: END IF;
1518:
1519: -- initialize API return status to success.
1520: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1531: EXCEPTION
1532: WHEN FND_API.G_EXC_ERROR THEN
1533: ROLLBACK TO delete_approval_action;
1534: x_return_status := FND_API.G_RET_STS_ERROR;
1535: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1536: p_count => x_msg_count,
1537: p_data => x_msg_data);
1538:
1539: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1538:
1539: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1540: ROLLBACK TO delete_approval_action;
1541: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1542: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1543: p_count => x_msg_count,
1544: p_data => x_msg_data);
1545:
1546: WHEN OTHERS THEN

Line 1551: FND_MSG_PUB.ADD;

1547: ROLLBACK TO delete_approval_action;
1548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1549: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
1550: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1551: FND_MSG_PUB.ADD;
1552: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1553: p_count => x_msg_count,
1554: p_data => x_msg_data);
1555:

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

1548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1549: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
1550: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1551: FND_MSG_PUB.ADD;
1552: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1553: p_count => x_msg_count,
1554: p_data => x_msg_data);
1555:
1556: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'End Delete_approval_action procedure');

Line 1681: FND_MSG_PUB.initialize;

1677: END IF;
1678:
1679: -- Initialize message list if p_init_msg_list is set to TRUE
1680: IF FND_API.To_Boolean(p_init_msg_list) THEN
1681: FND_MSG_PUB.initialize;
1682: END IF;
1683:
1684: -- Initialize API return status to success
1685: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1696: FND_MSG_PUB.Add;

1692: if P_LOAN_LINE_ID is null then
1693:
1694: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );
1695: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'P_LOAN_LINE_ID' );
1696: FND_MSG_PUB.Add;
1697: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
1698: RAISE FND_API.G_EXC_ERROR;
1699:
1700: end if;

Line 1697: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));

1693:
1694: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );
1695: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'P_LOAN_LINE_ID' );
1696: FND_MSG_PUB.Add;
1697: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
1698: RAISE FND_API.G_EXC_ERROR;
1699:
1700: end if;
1701:

Line 1709: FND_MSG_PUB.Add;

1705: close conditions_cur;
1706:
1707: if l_cond_count > 0 then
1708: FND_MESSAGE.SET_NAME('LNS', 'LNS_NOT_ALL_COND_MET');
1709: FND_MSG_PUB.Add;
1710: RAISE FND_API.G_EXC_ERROR;
1711: end if;
1712:
1713: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_BILLING_BATCH_PUB.ADJUST_ADD_RECEIVABLE...');

Line 1784: FND_MSG_PUB.Add;

1780: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_return_status: ' || l_return_status);
1781:
1782: IF l_return_status <> 'S' THEN
1783: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
1784: FND_MSG_PUB.Add;
1785: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
1786: RAISE FND_API.G_EXC_ERROR;
1787: END IF;
1788:

Line 1785: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));

1781:
1782: IF l_return_status <> 'S' THEN
1783: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
1784: FND_MSG_PUB.Add;
1785: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
1786: RAISE FND_API.G_EXC_ERROR;
1787: END IF;
1788:
1789: FND_MESSAGE.SET_NAME('LNS', 'LNS_ADD_REC_AGR_REASON');

Line 1794: FND_MSG_PUB.Add;

1790: FND_MESSAGE.SET_TOKEN('REC', l_trx_number);
1791: FND_MESSAGE.SET_TOKEN('AMOUNT', to_char(l_adj_amount, FND_CURRENCY.SAFE_GET_FORMAT_MASK(l_currency,50)));
1792: FND_MESSAGE.SET_TOKEN('CURR', l_currency);
1793: FND_MESSAGE.SET_TOKEN('DATE', l_adj_date);
1794: FND_MSG_PUB.Add;
1795: l_agreement_reason := FND_MSG_PUB.Get(p_encoded => 'F');
1796: FND_MSG_PUB.DELETE_MSG(FND_MSG_PUB.COUNT_MSG);
1797:
1798: LNS_REP_UTILS.STORE_LOAN_AGREEMENT_CP(l_loan_id, l_agreement_reason);

Line 1795: l_agreement_reason := FND_MSG_PUB.Get(p_encoded => 'F');

1791: FND_MESSAGE.SET_TOKEN('AMOUNT', to_char(l_adj_amount, FND_CURRENCY.SAFE_GET_FORMAT_MASK(l_currency,50)));
1792: FND_MESSAGE.SET_TOKEN('CURR', l_currency);
1793: FND_MESSAGE.SET_TOKEN('DATE', l_adj_date);
1794: FND_MSG_PUB.Add;
1795: l_agreement_reason := FND_MSG_PUB.Get(p_encoded => 'F');
1796: FND_MSG_PUB.DELETE_MSG(FND_MSG_PUB.COUNT_MSG);
1797:
1798: LNS_REP_UTILS.STORE_LOAN_AGREEMENT_CP(l_loan_id, l_agreement_reason);
1799:

Line 1796: FND_MSG_PUB.DELETE_MSG(FND_MSG_PUB.COUNT_MSG);

1792: FND_MESSAGE.SET_TOKEN('CURR', l_currency);
1793: FND_MESSAGE.SET_TOKEN('DATE', l_adj_date);
1794: FND_MSG_PUB.Add;
1795: l_agreement_reason := FND_MSG_PUB.Get(p_encoded => 'F');
1796: FND_MSG_PUB.DELETE_MSG(FND_MSG_PUB.COUNT_MSG);
1797:
1798: LNS_REP_UTILS.STORE_LOAN_AGREEMENT_CP(l_loan_id, l_agreement_reason);
1799:
1800: if P_COMMIT = FND_API.G_TRUE then

Line 1811: FND_MSG_PUB.Count_And_Get(

1807:
1808: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'Successfully approved additional receivable ' || l_trx_number);
1809:
1810: -- Standard call to get message count and if count is 1, get message info
1811: FND_MSG_PUB.Count_And_Get(
1812: p_encoded => FND_API.G_FALSE,
1813: p_count => x_msg_count,
1814: p_data => x_msg_data);
1815:

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

1818: EXCEPTION
1819: WHEN FND_API.G_EXC_ERROR THEN
1820: ROLLBACK TO APPROVE_ADD_RECEIVABLE;
1821: x_return_status := FND_API.G_RET_STS_ERROR;
1822: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1823: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'Rollbacked');
1824: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1825: ROLLBACK TO APPROVE_ADD_RECEIVABLE;
1826: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1823: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'Rollbacked');
1824: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1825: ROLLBACK TO APPROVE_ADD_RECEIVABLE;
1826: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1827: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1828: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'Rollbacked');
1829: WHEN OTHERS THEN
1830: ROLLBACK TO APPROVE_ADD_RECEIVABLE;
1831: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1832: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN

1828: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'Rollbacked');
1829: WHEN OTHERS THEN
1830: ROLLBACK TO APPROVE_ADD_RECEIVABLE;
1831: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1832: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
1833: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1834: END IF;
1835: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1836: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'Rollbacked');

Line 1833: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

1829: WHEN OTHERS THEN
1830: ROLLBACK TO APPROVE_ADD_RECEIVABLE;
1831: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1832: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
1833: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1834: END IF;
1835: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1836: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'Rollbacked');
1837: END;

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

1831: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1832: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
1833: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1834: END IF;
1835: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1836: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'Rollbacked');
1837: END;
1838:
1839:

Line 1952: FND_MSG_PUB.initialize;

1948: END IF;
1949:
1950: -- Initialize message list if p_init_msg_list is set to TRUE
1951: IF FND_API.To_Boolean(p_init_msg_list) THEN
1952: FND_MSG_PUB.initialize;
1953: END IF;
1954:
1955: -- Initialize API return status to success
1956: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1967: FND_MSG_PUB.Add;

1963: if P_LOAN_AMOUNT_ADJ_ID is null then
1964:
1965: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );
1966: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'P_LOAN_AMOUNT_ADJ_ID' );
1967: FND_MSG_PUB.Add;
1968: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
1969: RAISE FND_API.G_EXC_ERROR;
1970:
1971: end if;

Line 1968: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));

1964:
1965: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );
1966: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'P_LOAN_AMOUNT_ADJ_ID' );
1967: FND_MSG_PUB.Add;
1968: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
1969: RAISE FND_API.G_EXC_ERROR;
1970:
1971: end if;
1972:

Line 1980: FND_MSG_PUB.Add;

1976: close conditions_cur;
1977:
1978: if l_cond_count > 0 then
1979: FND_MESSAGE.SET_NAME('LNS', 'LNS_NOT_ALL_COND_MET');
1980: FND_MSG_PUB.Add;
1981: RAISE FND_API.G_EXC_ERROR;
1982: end if;
1983:
1984: open loan_am_adj_cur(P_LOAN_AMOUNT_ADJ_ID);

Line 1997: FND_MSG_PUB.Add;

1993: FND_MESSAGE.SET_TOKEN('ADJ', l_DESCRIPTION);
1994: FND_MESSAGE.SET_TOKEN('AMOUNT', l_adj_amount_str);
1995: FND_MESSAGE.SET_TOKEN('CURR', l_currency);
1996: FND_MESSAGE.SET_TOKEN('DATE', l_adj_date);
1997: FND_MSG_PUB.Add;
1998: l_agreement_reason := FND_MSG_PUB.Get(p_encoded => 'F');
1999: FND_MSG_PUB.DELETE_MSG(FND_MSG_PUB.COUNT_MSG);
2000:
2001: LNS_REP_UTILS.STORE_LOAN_AGREEMENT_CP(l_loan_id, l_agreement_reason);

Line 1998: l_agreement_reason := FND_MSG_PUB.Get(p_encoded => 'F');

1994: FND_MESSAGE.SET_TOKEN('AMOUNT', l_adj_amount_str);
1995: FND_MESSAGE.SET_TOKEN('CURR', l_currency);
1996: FND_MESSAGE.SET_TOKEN('DATE', l_adj_date);
1997: FND_MSG_PUB.Add;
1998: l_agreement_reason := FND_MSG_PUB.Get(p_encoded => 'F');
1999: FND_MSG_PUB.DELETE_MSG(FND_MSG_PUB.COUNT_MSG);
2000:
2001: LNS_REP_UTILS.STORE_LOAN_AGREEMENT_CP(l_loan_id, l_agreement_reason);
2002:

Line 1999: FND_MSG_PUB.DELETE_MSG(FND_MSG_PUB.COUNT_MSG);

1995: FND_MESSAGE.SET_TOKEN('CURR', l_currency);
1996: FND_MESSAGE.SET_TOKEN('DATE', l_adj_date);
1997: FND_MSG_PUB.Add;
1998: l_agreement_reason := FND_MSG_PUB.Get(p_encoded => 'F');
1999: FND_MSG_PUB.DELETE_MSG(FND_MSG_PUB.COUNT_MSG);
2000:
2001: LNS_REP_UTILS.STORE_LOAN_AGREEMENT_CP(l_loan_id, l_agreement_reason);
2002:
2003: if P_COMMIT = FND_API.G_TRUE then

Line 2014: FND_MSG_PUB.Count_And_Get(

2010:
2011: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'Successfully loan amount adjustment ' || l_DESCRIPTION);
2012:
2013: -- Standard call to get message count and if count is 1, get message info
2014: FND_MSG_PUB.Count_And_Get(
2015: p_encoded => FND_API.G_FALSE,
2016: p_count => x_msg_count,
2017: p_data => x_msg_data);
2018:

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

2021: EXCEPTION
2022: WHEN FND_API.G_EXC_ERROR THEN
2023: ROLLBACK TO APPROVE_LOAN_AM_ADJ;
2024: x_return_status := FND_API.G_RET_STS_ERROR;
2025: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2026: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'Rollbacked');
2027: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2028: ROLLBACK TO APPROVE_LOAN_AM_ADJ;
2029: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

2026: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'Rollbacked');
2027: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2028: ROLLBACK TO APPROVE_LOAN_AM_ADJ;
2029: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2030: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2031: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'Rollbacked');
2032: WHEN OTHERS THEN
2033: ROLLBACK TO APPROVE_LOAN_AM_ADJ;
2034: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2035: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN

2031: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'Rollbacked');
2032: WHEN OTHERS THEN
2033: ROLLBACK TO APPROVE_LOAN_AM_ADJ;
2034: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2035: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
2036: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2037: END IF;
2038: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2039: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'Rollbacked');

Line 2036: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

2032: WHEN OTHERS THEN
2033: ROLLBACK TO APPROVE_LOAN_AM_ADJ;
2034: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2035: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
2036: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2037: END IF;
2038: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2039: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'Rollbacked');
2040: END;

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

2034: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2035: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
2036: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2037: END IF;
2038: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2039: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'Rollbacked');
2040: END;
2041:
2042:

Line 2240: FND_MSG_PUB.Add;

2236: if P_LOAN_NUMBER is null then
2237:
2238: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );
2239: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'P_LOAN_NUMBER' );
2240: FND_MSG_PUB.Add;
2241: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
2242: RAISE FND_API.G_EXC_ERROR;
2243:
2244: end if;

Line 2241: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));

2237:
2238: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );
2239: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'P_LOAN_NUMBER' );
2240: FND_MSG_PUB.Add;
2241: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
2242: RAISE FND_API.G_EXC_ERROR;
2243:
2244: end if;
2245:

Line 2250: FND_MSG_PUB.Add;

2246: if P_ACTION_TYPE is null then
2247:
2248: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );
2249: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'P_ACTION_TYPE' );
2250: FND_MSG_PUB.Add;
2251: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
2252: RAISE FND_API.G_EXC_ERROR;
2253:
2254: end if;

Line 2251: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));

2247:
2248: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );
2249: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'P_ACTION_TYPE' );
2250: FND_MSG_PUB.Add;
2251: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
2252: RAISE FND_API.G_EXC_ERROR;
2253:
2254: end if;
2255:

Line 2260: FND_MSG_PUB.Add;

2256: if P_CURRENT_APPROVER is null then
2257:
2258: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );
2259: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'P_CURRENT_APPROVER' );
2260: FND_MSG_PUB.Add;
2261: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
2262: RAISE FND_API.G_EXC_ERROR;
2263:
2264: end if;

Line 2261: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));

2257:
2258: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );
2259: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'P_CURRENT_APPROVER' );
2260: FND_MSG_PUB.Add;
2261: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
2262: RAISE FND_API.G_EXC_ERROR;
2263:
2264: end if;
2265: