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_MESSAGE

Line 101: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_DUPLICATE_COLUMN');

97: INTO l_dummy
98: FROM LNS_APPROVAL_ACTIONS
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:

Line 102: FND_MESSAGE.SET_TOKEN('COLUMN', 'action_id');

98: FROM LNS_APPROVAL_ACTIONS
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

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

204: p_object_version_number = l_object_version_number
205: )
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;

Line 209: FND_MESSAGE.SET_TOKEN('TABLE', 'lns_approval_actions');

205: )
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:

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

213:
214: p_object_version_number := nvl(l_object_version_number, 1) + 1;
215:
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;

Line 218: FND_MESSAGE.SET_TOKEN('RECORD', 'approval action_rec');

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

Line 219: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_approval_action_rec.action_id), 'null'));

215:
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:

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

316: WHERE ACTION_ID = p_action_id;
317:
318: EXCEPTION
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;

Line 321: FND_MESSAGE.SET_TOKEN('RECORD', 'approval action_rec');

317:
318: EXCEPTION
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;

Line 322: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_action_id), 'null'));

318: EXCEPTION
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;

Line 357: FND_MESSAGE.SET_NAME('LNS', 'LNS_NEGATIVE_NUMBER_ERROR');

353: OPEN C_Check_Fee_Violation (p_approval_action_rec.loan_id, l_install_number);
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:

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

617: ,l_loan_needs_approval
618: ,l_secondary_status
619: ,l_customized;
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;

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

618: ,l_secondary_status
619: ,l_customized;
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';

Line 623: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(l_loan_header_rec.loan_id), 'null'));

619: ,l_customized;
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;

Line 682: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_INVALID_STATUS');

678:
679: END IF;
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;

Line 683: FND_MESSAGE.SET_TOKEN('VALUE', l_status);

679: END IF;
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:

Line 692: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_INVALID_STATUS');

688: ELSIF (l_approval_action_rec.action_type = 'SUBMIT_FOR_CONV') THEN
689: IF (l_status = 'ACTIVE' AND l_current_phase = 'OPEN' AND l_multiple_funding_flag = 'Y' AND l_open_to_term_flag = 'Y') THEN
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;

Line 693: FND_MESSAGE.SET_TOKEN('VALUE', l_status);

689: IF (l_status = 'ACTIVE' AND l_current_phase = 'OPEN' AND l_multiple_funding_flag = 'Y' AND l_open_to_term_flag = 'Y') THEN
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:

Line 719: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_INVALID_STATUS');

715: l_last_api_called := 'LNS_FUNDING_PUB.CANCEL_DISB_SCHEDULE';
716: RAISE FND_API.G_EXC_ERROR;
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;

Line 720: FND_MESSAGE.SET_TOKEN('VALUE', l_status);

716: RAISE FND_API.G_EXC_ERROR;
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:

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

832:
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;

Line 885: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_INVALID_STATUS');

881: */
882: /**********************End Permanent Conversion to Term Phase*************/
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;

Line 886: FND_MESSAGE.SET_TOKEN('VALUE', l_status);

882: /**********************End Permanent Conversion to Term Phase*************/
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:

Line 921: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_INVALID_STATUS');

917: fetch prev_sec_status_cur into l_prev_sec_status;
918: close prev_sec_status_cur;
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;

Line 922: FND_MESSAGE.SET_TOKEN('VALUE', l_status);

918: close prev_sec_status_cur;
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:

Line 1021: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_INVALID_STATUS');

1017: if l_current_phase = 'OPEN' AND l_multiple_funding_flag = 'Y' AND l_open_to_term_flag = 'Y' THEN
1018: l_loan_header_rec.secondary_status := 'MORE_INFO_REQUESTED';
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;

Line 1022: FND_MESSAGE.SET_TOKEN('VALUE', l_status);

1018: l_loan_header_rec.secondary_status := 'MORE_INFO_REQUESTED';
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

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

1239: ,l_loan_header_rec.loan_id);
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

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

1321: ROLLBACK TO create_approval_action;
1322: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'after rollback');
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,

Line 1326: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed API call: ' || l_last_api_called || ' SQLERRM: ' || SQLERRM);

1322: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'after rollback');
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,

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

1333: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1334: ROLLBACK TO create_approval_action;
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,

Line 1338: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed API call: ' || l_last_api_called || ' SQLERRM: ' || SQLERRM);

1334: ROLLBACK TO create_approval_action;
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,

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

1345: WHEN OTHERS THEN
1346: ROLLBACK TO create_approval_action;
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,

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

1346: ROLLBACK TO create_approval_action;
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,

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

1453:
1454: WHEN OTHERS THEN
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,

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

1454: WHEN OTHERS THEN
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);

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

1545:
1546: WHEN OTHERS THEN
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,

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

1546: WHEN OTHERS THEN
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);

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

1690:
1691: /* verify input parameters */
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;

Line 1695: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'P_LOAN_LINE_ID' );

1691: /* verify input parameters */
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:

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

1704: fetch conditions_cur into l_cond_count;
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:

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

1779:
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;

Line 1789: FND_MESSAGE.SET_NAME('LNS', 'LNS_ADD_REC_AGR_REASON');

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');
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);

Line 1790: FND_MESSAGE.SET_TOKEN('REC', l_trx_number);

1786: RAISE FND_API.G_EXC_ERROR;
1787: END IF;
1788:
1789: FND_MESSAGE.SET_NAME('LNS', 'LNS_ADD_REC_AGR_REASON');
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;

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

1787: END IF;
1788:
1789: FND_MESSAGE.SET_NAME('LNS', 'LNS_ADD_REC_AGR_REASON');
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');

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

1788:
1789: FND_MESSAGE.SET_NAME('LNS', 'LNS_ADD_REC_AGR_REASON');
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);

Line 1793: FND_MESSAGE.SET_TOKEN('DATE', l_adj_date);

1789: FND_MESSAGE.SET_NAME('LNS', 'LNS_ADD_REC_AGR_REASON');
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:

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

1961:
1962: /* verify input parameters */
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;

Line 1966: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'P_LOAN_AMOUNT_ADJ_ID' );

1962: /* verify input parameters */
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:

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

1975: fetch conditions_cur into l_cond_count;
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:

Line 1992: FND_MESSAGE.SET_NAME('LNS', 'LNS_LOAN_AM_ADJ_AGR_REASON');

1988: l_adj_amount_str,
1989: l_adj_date;
1990: close loan_am_adj_cur;
1991:
1992: FND_MESSAGE.SET_NAME('LNS', 'LNS_LOAN_AM_ADJ_AGR_REASON');
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);

Line 1993: FND_MESSAGE.SET_TOKEN('ADJ', l_DESCRIPTION);

1989: l_adj_date;
1990: close loan_am_adj_cur;
1991:
1992: FND_MESSAGE.SET_NAME('LNS', 'LNS_LOAN_AM_ADJ_AGR_REASON');
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;

Line 1994: FND_MESSAGE.SET_TOKEN('AMOUNT', l_adj_amount_str);

1990: close loan_am_adj_cur;
1991:
1992: FND_MESSAGE.SET_NAME('LNS', 'LNS_LOAN_AM_ADJ_AGR_REASON');
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');

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

1991:
1992: FND_MESSAGE.SET_NAME('LNS', 'LNS_LOAN_AM_ADJ_AGR_REASON');
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);

Line 1996: FND_MESSAGE.SET_TOKEN('DATE', l_adj_date);

1992: FND_MESSAGE.SET_NAME('LNS', 'LNS_LOAN_AM_ADJ_AGR_REASON');
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:

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

2234:
2235: /* verify input parameters */
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;

Line 2239: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'P_LOAN_NUMBER' );

2235: /* verify input parameters */
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:

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

2244: end if;
2245:
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;

Line 2249: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'P_ACTION_TYPE' );

2245:
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:

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

2254: end if;
2255:
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;

Line 2259: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'P_CURRENT_APPROVER' );

2255:
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: