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 102: FND_MSG_PUB.ADD;

98: WHERE action_id = l_action_id;
99:
100: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_DUPLICATE_COLUMN');
101: FND_MESSAGE.SET_TOKEN('COLUMN', 'action_id');
102: FND_MSG_PUB.ADD;
103: RAISE FND_API.G_EXC_ERROR;
104:
105: EXCEPTION
106: 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 540: FND_MSG_PUB.initialize;

536: SAVEPOINT create_approval_action;
537:
538: -- initialize message list if p_init_msg_list is set to TRUE.
539: IF FND_API.to_Boolean(p_init_msg_list) THEN
540: FND_MSG_PUB.initialize;
541: END IF;
542:
543: -- initialize API return status to success.
544: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 579: FND_MSG_PUB.ADD;

575: IF C_Get_Loan_Info%NOTFOUND THEN
576: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
577: FND_MESSAGE.SET_TOKEN('RECORD', 'loan header');
578: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(l_loan_header_rec.loan_id), 'null'));
579: FND_MSG_PUB.ADD;
580: CLOSE C_Get_Loan_Info;
581: l_last_api_called := 'C_Get_Loan_Info';
582: RAISE FND_API.G_EXC_ERROR;
583: END IF;

Line 600: FND_MSG_PUB.ADD;

596: l_loan_header_rec.secondary_status := FND_API.G_MISS_CHAR;
597: ELSE
598: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_INVALID_STATUS');
599: FND_MESSAGE.SET_TOKEN('VALUE', l_status);
600: FND_MSG_PUB.ADD;
601: RAISE FND_API.G_EXC_ERROR;
602: END IF;
603:
604: ELSIF (l_approval_action_rec.action_type = 'SUBMIT_FOR_CONV') THEN

Line 610: FND_MSG_PUB.ADD;

606: l_loan_header_rec.secondary_status := 'PENDING_CONVERSION';
607: ELSE
608: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_INVALID_STATUS');
609: FND_MESSAGE.SET_TOKEN('VALUE', l_status);
610: FND_MSG_PUB.ADD;
611: RAISE FND_API.G_EXC_ERROR;
612: END IF;
613:
614: ELSIF (l_approval_action_rec.action_type = 'SUBMIT_FOR_CNCL') THEN

Line 637: FND_MSG_PUB.ADD;

633: END IF;
634: ELSE
635: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_INVALID_STATUS');
636: FND_MESSAGE.SET_TOKEN('VALUE', l_status);
637: FND_MSG_PUB.ADD;
638: RAISE FND_API.G_EXC_ERROR;
639: END IF;
640:
641: ELSIF (l_approval_action_rec.action_type = 'APPROVE') THEN

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

706: ,x_msg_count => x_msg_count
707: ,x_msg_data => x_msg_data);
708:
709: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
710: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - LNS_FINANCIALS.shiftLoanDates failed with message: ' ||FND_MSG_PUB.Get(p_encoded => 'F'));
711: l_last_api_called := 'LNS_FINANCIALS.shiftLoanDates';
712: RAISE FND_API.G_EXC_ERROR;
713: END IF;
714:

Line 749: FND_MSG_PUB.Add;

745: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
746: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Successfully update LNS_TERMS');
747: ELSE
748: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_TERM_FAIL');
749: FND_MSG_PUB.Add;
750: 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'));
751: l_last_api_called := 'LNS_TERMS_PUB.update_term';
752: RAISE FND_API.G_EXC_ERROR;
753: END IF;

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

746: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Successfully update LNS_TERMS');
747: ELSE
748: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_TERM_FAIL');
749: FND_MSG_PUB.Add;
750: 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'));
751: l_last_api_called := 'LNS_TERMS_PUB.update_term';
752: RAISE FND_API.G_EXC_ERROR;
753: END IF;
754:

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

782:
783: 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');
784:
785: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
786: 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'));
787: l_last_api_called := 'lns_fee_engine.processDisbursementFees';
788: RAISE FND_API.G_EXC_ERROR;
789: END IF;
790: /**********************End Permanent Conversion to Term Phase*************/

Line 795: FND_MSG_PUB.ADD;

791:
792: ELSE
793: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_INVALID_STATUS');
794: FND_MESSAGE.SET_TOKEN('VALUE', l_status);
795: FND_MSG_PUB.ADD;
796: RAISE FND_API.G_EXC_ERROR;
797: END IF;
798:
799: ELSIF (l_approval_action_rec.action_type = 'REJECT') THEN

Line 831: FND_MSG_PUB.ADD;

827: l_loan_header_rec.secondary_status := nvl(l_prev_sec_status,FND_API.G_MISS_CHAR);
828: ELSE
829: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_INVALID_STATUS');
830: FND_MESSAGE.SET_TOKEN('VALUE', l_status);
831: FND_MSG_PUB.ADD;
832: RAISE FND_API.G_EXC_ERROR;
833: END IF;
834:
835: ELSIF (l_approval_action_rec.action_type = 'REQUEST_FOR_INFO') THEN

Line 869: FND_MSG_PUB.ADD;

865: end if;
866: ELSE
867: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_INVALID_STATUS');
868: FND_MESSAGE.SET_TOKEN('VALUE', l_status);
869: FND_MSG_PUB.ADD;
870: RAISE FND_API.G_EXC_ERROR;
871: END IF;
872: END IF;
873:

Line 902: --FND_MSG_PUB.initialize;

898: ,x_msg_count => x_msg_count
899: ,x_msg_data => x_msg_data);
900: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Call to Lns_distributions_pub.budgetary_control return status ' || x_return_status);
901: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'l_budgetary_status' || l_budgetary_status);
902: --FND_MSG_PUB.initialize;
903: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
904:
905: RAISE FND_API.G_EXC_ERROR;
906:

Line 919: FND_MSG_PUB.initialize;

915: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'budget required: NO BUDGET');
916: RAISE FND_API.G_EXC_ERROR;
917: else
918: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'NO BUDGET');
919: FND_MSG_PUB.initialize;
920: l_loan_header_rec.secondary_status := 'NO_BUDGET';
921: end if;
922:
923: end if;

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

1016: ,x_msg_data => x_msg_data);
1017: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'After call to LNS_LOAN_HEADER_PUB.update_loan');
1018:
1019: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1020: 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'));
1021: l_last_api_called := 'LNS_LOAN_HEADER_PUB.update_loan';
1022: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1023: END IF;
1024: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - After call to LNS_LOAN_HEADER_PUB.update_loan proc');

Line 1065: FND_MSG_PUB.Add;

1061:
1062: if l_request_id = 0 then
1063: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1064: FND_MESSAGE.SET_NAME('LNS', 'LNS_AGREEMENT_REQUEST_FAILED');
1065: FND_MSG_PUB.Add;
1066: l_last_api_called := 'FND_REQUEST.SUBMIT_REQUEST for Loan Agreement Report Generation';
1067: RAISE FND_API.G_EXC_ERROR;
1068: else
1069: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Successfully submited Loan Agreement Report Generation Concurrent Program. Request id: ' || l_request_id);

Line 1087: FND_MSG_PUB.ADD;

1083: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'after rollback');
1084: x_return_status := FND_API.G_RET_STS_ERROR;
1085: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
1086: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed API call: ' || l_last_api_called || ' SQLERRM: ' || SQLERRM);
1087: FND_MSG_PUB.ADD;
1088: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1089: p_count => x_msg_count,
1090: p_data => x_msg_data);
1091:

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

1084: x_return_status := FND_API.G_RET_STS_ERROR;
1085: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
1086: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed API call: ' || l_last_api_called || ' SQLERRM: ' || SQLERRM);
1087: FND_MSG_PUB.ADD;
1088: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1089: p_count => x_msg_count,
1090: p_data => x_msg_data);
1091:
1092: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1097: FND_MSG_PUB.ADD;

1093: ROLLBACK TO create_approval_action;
1094: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1095: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
1096: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed API call: ' || l_last_api_called || ' SQLERRM: ' || SQLERRM);
1097: FND_MSG_PUB.ADD;
1098: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1099: p_count => x_msg_count,
1100: p_data => x_msg_data);
1101:

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

1094: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1095: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
1096: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed API call: ' || l_last_api_called || ' SQLERRM: ' || SQLERRM);
1097: FND_MSG_PUB.ADD;
1098: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1099: p_count => x_msg_count,
1100: p_data => x_msg_data);
1101:
1102: WHEN OTHERS THEN

Line 1107: FND_MSG_PUB.ADD;

1103: ROLLBACK TO create_approval_action;
1104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1105: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
1106: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1107: FND_MSG_PUB.ADD;
1108: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1109: p_count => x_msg_count,
1110: p_data => x_msg_data);
1111:

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

1104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1105: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
1106: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1107: FND_MSG_PUB.ADD;
1108: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1109: p_count => x_msg_count,
1110: p_data => x_msg_data);
1111:
1112: END create_approval_action;

Line 1164: FND_MSG_PUB.initialize;

1160: SAVEPOINT update_approval_action;
1161:
1162: -- initialize message list if p_init_msg_list is set to TRUE.
1163: IF FND_API.to_Boolean(p_init_msg_list) THEN
1164: FND_MSG_PUB.initialize;
1165: END IF;
1166:
1167: -- initialize API return status to success.
1168: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1194: EXCEPTION
1195: WHEN FND_API.G_EXC_ERROR THEN
1196: ROLLBACK TO update_approval_action;
1197: x_return_status := FND_API.G_RET_STS_ERROR;
1198: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1199: p_count => x_msg_count,
1200: p_data => x_msg_data);
1201:
1202: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1201:
1202: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1203: ROLLBACK TO update_approval_action;
1204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1205: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1206: p_count => x_msg_count,
1207: p_data => x_msg_data);
1208:
1209: WHEN OTHERS THEN

Line 1214: FND_MSG_PUB.ADD;

1210: ROLLBACK TO update_approval_action;
1211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1212: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
1213: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1214: FND_MSG_PUB.ADD;
1215: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1216: p_count => x_msg_count,
1217: p_data => x_msg_data);
1218:

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

1211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1212: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
1213: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1214: FND_MSG_PUB.ADD;
1215: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1216: p_count => x_msg_count,
1217: p_data => x_msg_data);
1218:
1219: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'End Update_approval_action procedure');

Line 1271: FND_MSG_PUB.initialize;

1267: SAVEPOINT delete_approval_action;
1268:
1269: -- initialize message list if p_init_msg_list is set to TRUE.
1270: IF FND_API.to_Boolean(p_init_msg_list) THEN
1271: FND_MSG_PUB.initialize;
1272: END IF;
1273:
1274: -- initialize API return status to success.
1275: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1286: EXCEPTION
1287: WHEN FND_API.G_EXC_ERROR THEN
1288: ROLLBACK TO delete_approval_action;
1289: x_return_status := FND_API.G_RET_STS_ERROR;
1290: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1291: p_count => x_msg_count,
1292: p_data => x_msg_data);
1293:
1294: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1293:
1294: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1295: ROLLBACK TO delete_approval_action;
1296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1297: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1298: p_count => x_msg_count,
1299: p_data => x_msg_data);
1300:
1301: WHEN OTHERS THEN

Line 1306: FND_MSG_PUB.ADD;

1302: ROLLBACK TO delete_approval_action;
1303: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1304: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
1305: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1306: FND_MSG_PUB.ADD;
1307: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1308: p_count => x_msg_count,
1309: p_data => x_msg_data);
1310:

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

1303: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1304: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
1305: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1306: FND_MSG_PUB.ADD;
1307: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1308: p_count => x_msg_count,
1309: p_data => x_msg_data);
1310:
1311: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'End Delete_approval_action procedure');