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_DISTRIBUTIONS_PUB dependencies on FND_MSG_PUB

Line 94: FND_MSG_PUB.initialize;

90: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_loan_id ' || p_loan_id);
91:
92: -- Initialize message list IF p_init_msg_list is set to TRUE.
93: IF FND_API.to_Boolean( p_init_msg_list ) THEN
94: FND_MSG_PUB.initialize;
95: END IF;
96:
97: -- Initialize API return status to SUCCESS
98: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 150: FND_MSG_PUB.ADD;

146: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_event_id = ' || l_event_id);
147:
148: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
149: FND_MESSAGE.SET_NAME('LNS', 'LNS_ACCOUNTING_EVENT_ERROR');
150: FND_MSG_PUB.ADD;
151: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
152: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
153: END IF;
154:

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

147:
148: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
149: FND_MESSAGE.SET_NAME('LNS', 'LNS_ACCOUNTING_EVENT_ERROR');
150: FND_MSG_PUB.ADD;
151: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
152: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
153: END IF;
154:
155: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'stamping new event_id on distributions');

Line 196: FND_MSG_PUB.ADD;

192:
193: x_return_status := FND_API.G_RET_STS_ERROR;
194: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
195: FND_MESSAGE.SET_TOKEN('ERROR' ,'Call to PSA_BC_XLA_PUB.Budgetary_Control failed with Status Code = ' || l_status_code);
196: FND_MSG_PUB.ADD;
197: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
198: RAISE FND_API.G_EXC_ERROR;
199:
200: else

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

193: x_return_status := FND_API.G_RET_STS_ERROR;
194: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
195: FND_MESSAGE.SET_TOKEN('ERROR' ,'Call to PSA_BC_XLA_PUB.Budgetary_Control failed with Status Code = ' || l_status_code);
196: FND_MSG_PUB.ADD;
197: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
198: RAISE FND_API.G_EXC_ERROR;
199:
200: else
201: -- caller handle success status

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

220: WHEN FND_API.G_EXC_ERROR THEN
221: ROLLBACK TO cancel_disbursements;
222: x_return_status := FND_API.G_RET_STS_ERROR;
223: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
224: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
225:
226: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
227: ROLLBACK TO cancel_disbursements;
228: x_return_status := FND_API.G_RET_STS_ERROR;

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

226: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
227: ROLLBACK TO cancel_disbursements;
228: x_return_status := FND_API.G_RET_STS_ERROR;
229: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
230: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
231:
232: WHEN OTHERS THEN
233: ROLLBACK TO cancel_disbursements;
234: x_return_status := FND_API.G_RET_STS_ERROR;

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

232: WHEN OTHERS THEN
233: ROLLBACK TO cancel_disbursements;
234: x_return_status := FND_API.G_RET_STS_ERROR;
235: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
236: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
237:
238: end cancel_disbursements;
239:
240: /*=========================================================================

Line 457: FND_MSG_PUB.initialize;

453: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_budgetary_control_mode = ' || p_budgetary_control_mode);
454:
455: -- Initialize message list IF p_init_msg_list is set to TRUE.
456: IF FND_API.to_Boolean( p_init_msg_list ) THEN
457: FND_MSG_PUB.initialize;
458: END IF;
459:
460: -- Initialize API return status to SUCCESS
461: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 472: FND_MSG_PUB.ADD;

468:
469: -- Bug#6711479 We can't check funds without valid disbursement
470: IF (l_disbursement_id IS NULL) THEN
471: FND_MESSAGE.SET_NAME('LNS', 'LNS_CHK_FUND_DISB_INVALID');
472: FND_MSG_PUB.ADD;
473: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
474: FND_MESSAGE.SET_NAME('LNS', 'LNS_CREATE_DISB_SCHED');
475: FND_MSG_PUB.ADD;
476: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));

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

469: -- Bug#6711479 We can't check funds without valid disbursement
470: IF (l_disbursement_id IS NULL) THEN
471: FND_MESSAGE.SET_NAME('LNS', 'LNS_CHK_FUND_DISB_INVALID');
472: FND_MSG_PUB.ADD;
473: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
474: FND_MESSAGE.SET_NAME('LNS', 'LNS_CREATE_DISB_SCHED');
475: FND_MSG_PUB.ADD;
476: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
477: RAISE FND_API.G_EXC_ERROR;

Line 475: FND_MSG_PUB.ADD;

471: FND_MESSAGE.SET_NAME('LNS', 'LNS_CHK_FUND_DISB_INVALID');
472: FND_MSG_PUB.ADD;
473: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
474: FND_MESSAGE.SET_NAME('LNS', 'LNS_CREATE_DISB_SCHED');
475: FND_MSG_PUB.ADD;
476: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
477: RAISE FND_API.G_EXC_ERROR;
478: END IF;
479:

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

472: FND_MSG_PUB.ADD;
473: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
474: FND_MESSAGE.SET_NAME('LNS', 'LNS_CREATE_DISB_SCHED');
475: FND_MSG_PUB.ADD;
476: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
477: RAISE FND_API.G_EXC_ERROR;
478: END IF;
479:
480: if (lns_utility_pub.IS_FED_FIN_ENABLED = 'Y' AND l_disbursement_id IS NOT NULL) then

Line 515: FND_MSG_PUB.ADD;

511: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'x_event_id ' || x_event_id);
512:
513: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
514: FND_MESSAGE.SET_NAME('LNS', 'LNS_ACCOUNTING_EVENT_ERROR');
515: FND_MSG_PUB.ADD;
516: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
517: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
518: END IF;
519:

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

512:
513: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
514: FND_MESSAGE.SET_NAME('LNS', 'LNS_ACCOUNTING_EVENT_ERROR');
515: FND_MSG_PUB.ADD;
516: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
517: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
518: END IF;
519:
520: -- stamp the eventID onto the lns_distributions table

Line 573: FND_MSG_PUB.ADD;

569:
570: l_return_status := FND_API.G_RET_STS_ERROR;
571: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
572: FND_MESSAGE.SET_TOKEN('ERROR' ,'Call to PSA_BC_XLA_PUB.Budgetary_Control failed with Status Code = ' || l_status_code);
573: FND_MSG_PUB.ADD;
574: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
575: RAISE FND_API.G_EXC_ERROR;
576:
577: else

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

570: l_return_status := FND_API.G_RET_STS_ERROR;
571: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
572: FND_MESSAGE.SET_TOKEN('ERROR' ,'Call to PSA_BC_XLA_PUB.Budgetary_Control failed with Status Code = ' || l_status_code);
573: FND_MSG_PUB.ADD;
574: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
575: RAISE FND_API.G_EXC_ERROR;
576:
577: else
578: if l_status_code NOT IN ('SUCCESS','ADVISORY') then

Line 581: FND_MSG_PUB.ADD;

577: else
578: if l_status_code NOT IN ('SUCCESS','ADVISORY') then
579: IF (l_status_code = 'PARTIAL') THEN
580: FND_MESSAGE.SET_NAME('LNS', 'LNS_FUND_CHK_PARTIAL');
581: FND_MSG_PUB.ADD;
582: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
583: RAISE FND_API.G_EXC_ERROR;
584: ELSE
585: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');

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

578: if l_status_code NOT IN ('SUCCESS','ADVISORY') then
579: IF (l_status_code = 'PARTIAL') THEN
580: FND_MESSAGE.SET_NAME('LNS', 'LNS_FUND_CHK_PARTIAL');
581: FND_MSG_PUB.ADD;
582: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
583: RAISE FND_API.G_EXC_ERROR;
584: ELSE
585: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
586: FND_MESSAGE.SET_TOKEN('ERROR' ,'Call to PSA_BC_XLA_PUB.Budgetary_Control failed with Status Code = ' || l_status_code);

Line 587: FND_MSG_PUB.ADD;

583: RAISE FND_API.G_EXC_ERROR;
584: ELSE
585: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
586: FND_MESSAGE.SET_TOKEN('ERROR' ,'Call to PSA_BC_XLA_PUB.Budgetary_Control failed with Status Code = ' || l_status_code);
587: FND_MSG_PUB.ADD;
588: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
589: RAISE FND_API.G_EXC_ERROR;
590: END IF;
591: end if;

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

584: ELSE
585: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
586: FND_MESSAGE.SET_TOKEN('ERROR' ,'Call to PSA_BC_XLA_PUB.Budgetary_Control failed with Status Code = ' || l_status_code);
587: FND_MSG_PUB.ADD;
588: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
589: RAISE FND_API.G_EXC_ERROR;
590: END IF;
591: end if;
592:

Line 614: FND_MSG_PUB.ADD;

610: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'update loan status = ' || l_return_status);
611:
612: if l_return_status <> 'S' then
613: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
614: FND_MSG_PUB.ADD;
615: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
616: RAISE FND_API.G_EXC_ERROR;
617: end if;
618:

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

611:
612: if l_return_status <> 'S' then
613: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
614: FND_MSG_PUB.ADD;
615: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
616: RAISE FND_API.G_EXC_ERROR;
617: end if;
618:
619: end if; -- BC_API.RETURN_STATUS

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

636: WHEN FND_API.G_EXC_ERROR THEN
637: ROLLBACK TO budgetary_control_pvt;
638: x_return_status := FND_API.G_RET_STS_ERROR;
639: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
640: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
641:
642: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
643: ROLLBACK TO budgetary_control_pvt;
644: x_return_status := FND_API.G_RET_STS_ERROR;

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

642: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
643: ROLLBACK TO budgetary_control_pvt;
644: x_return_status := FND_API.G_RET_STS_ERROR;
645: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
646: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
647:
648: WHEN OTHERS THEN
649: ROLLBACK TO budgetary_control_pvt;
650: x_return_status := FND_API.G_RET_STS_ERROR;

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

648: WHEN OTHERS THEN
649: ROLLBACK TO budgetary_control_pvt;
650: x_return_status := FND_API.G_RET_STS_ERROR;
651: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
652: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
653:
654: end budgetary_control;
655:
656:

Line 747: FND_MSG_PUB.ADD;

743:
744: else
745:
746: FND_MESSAGE.SET_NAME('LNS', 'LNS_DEFAULT_DIST_NOT_FOUND');
747: FND_MSG_PUB.ADD;
748: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
749: RAISE FND_API.G_EXC_ERROR;
750:
751: end if;

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

744: else
745:
746: FND_MESSAGE.SET_NAME('LNS', 'LNS_DEFAULT_DIST_NOT_FOUND');
747: FND_MSG_PUB.ADD;
748: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
749: RAISE FND_API.G_EXC_ERROR;
750:
751: end if;
752: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');

Line 894: FND_MSG_PUB.initialize;

890: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_distribution_type = ' || p_distribution_type);
891:
892: -- Initialize message list IF p_init_msg_list is set to TRUE.
893: IF FND_API.to_Boolean( p_init_msg_list ) THEN
894: FND_MSG_PUB.initialize;
895: END IF;
896:
897: -- Initialize API return status to SUCCESS
898: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1037: FND_MSG_PUB.ADD;

1033:
1034: exception
1035: when no_data_found then
1036: FND_MESSAGE.SET_NAME('LNS', 'LNS_DEFAULT_DIST_NOT_FOUND');
1037: FND_MSG_PUB.ADD;
1038: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
1039: RAISE FND_API.G_EXC_ERROR;
1040: End; -- c_default_info cursor
1041:

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

1034: exception
1035: when no_data_found then
1036: FND_MESSAGE.SET_NAME('LNS', 'LNS_DEFAULT_DIST_NOT_FOUND');
1037: FND_MSG_PUB.ADD;
1038: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
1039: RAISE FND_API.G_EXC_ERROR;
1040: End; -- c_default_info cursor
1041:
1042: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'distribs2 count is ' || l_distributions.count);

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

1046: THEN
1047: COMMIT WORK;
1048: END IF;
1049:
1050: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1051:
1052: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
1053:
1054: EXCEPTION

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

1055: WHEN FND_API.G_EXC_ERROR THEN
1056: ROLLBACK TO defaultDistributionsCatch;
1057: x_return_status := FND_API.G_RET_STS_ERROR;
1058: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
1059: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1060:
1061: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1062: ROLLBACK TO defaultDistributionsCatch;
1063: x_return_status := FND_API.G_RET_STS_ERROR;

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

1061: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1062: ROLLBACK TO defaultDistributionsCatch;
1063: x_return_status := FND_API.G_RET_STS_ERROR;
1064: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
1065: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1066:
1067: WHEN OTHERS THEN
1068: ROLLBACK TO defaultDistributionsCatch;
1069: x_return_status := FND_API.G_RET_STS_ERROR;

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

1067: WHEN OTHERS THEN
1068: ROLLBACK TO defaultDistributionsCatch;
1069: x_return_status := FND_API.G_RET_STS_ERROR;
1070: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
1071: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1072:
1073: end defaultDistributionsCatch;
1074:
1075:

Line 1139: FND_MSG_PUB.initialize;

1135: SAVEPOINT create_event;
1136:
1137: -- Initialize message list IF p_init_msg_list is set to TRUE.
1138: IF FND_API.to_Boolean(p_init_msg_list) THEN
1139: FND_MSG_PUB.initialize;
1140: END IF;
1141:
1142: -- Initialize API return status to SUCCESS
1143: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1174: FND_MSG_PUB.ADD;

1170: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'x_return_status = ' || x_return_status);
1171:
1172: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1173: FND_MESSAGE.SET_NAME('LNS', 'LNS_ACCOUNTING_EVENT_ERROR');
1174: FND_MSG_PUB.ADD;
1175: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
1176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1177: ELSE
1178: -- update the distributions table with proper event_id for valid disb_header_id

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

1171:
1172: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1173: FND_MESSAGE.SET_NAME('LNS', 'LNS_ACCOUNTING_EVENT_ERROR');
1174: FND_MSG_PUB.ADD;
1175: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
1176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1177: ELSE
1178: -- update the distributions table with proper event_id for valid disb_header_id
1179: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updating lns_distributions...');

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

1189: end loop;
1190: -- ---------------------------------------------------------------------
1191: -- End of API body
1192: -- ---------------------------------------------------------------------
1193: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1194:
1195: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
1196:
1197: EXCEPTION

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

1199: ROLLBACK TO create_event;
1200: x_return_status := FND_API.G_RET_STS_ERROR;
1201: x_msg_count := l_msg_count;
1202: x_msg_data := l_msg_data;
1203: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1204: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
1205:
1206: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1207: ROLLBACK TO create_event;

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

1207: ROLLBACK TO create_event;
1208: x_return_status := FND_API.G_RET_STS_ERROR;
1209: x_msg_count := l_msg_count;
1210: x_msg_data := l_msg_data;
1211: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1212: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
1213:
1214: WHEN OTHERS THEN
1215: ROLLBACK TO create_event;

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

1215: ROLLBACK TO create_event;
1216: x_return_status := FND_API.G_RET_STS_ERROR;
1217: x_msg_count := l_msg_count;
1218: x_msg_data := l_msg_data;
1219: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1220: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
1221:
1222: end create_event;
1223:

Line 1282: FND_MSG_PUB.ADD;

1278: Exception
1279: When others then
1280: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'failed to retrieve replacement natural account');
1281: FND_MESSAGE.SET_NAME('LNS', 'LNS_MFAR_CONFIGURATION_ERROR');
1282: FND_MSG_PUB.ADD;
1283: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
1284: RAISE FND_API.G_EXC_ERROR;
1285:
1286: end getNaturalSwapAccount;

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

1279: When others then
1280: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'failed to retrieve replacement natural account');
1281: FND_MESSAGE.SET_NAME('LNS', 'LNS_MFAR_CONFIGURATION_ERROR');
1282: FND_MSG_PUB.ADD;
1283: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
1284: RAISE FND_API.G_EXC_ERROR;
1285:
1286: end getNaturalSwapAccount;
1287:

Line 1349: FND_MSG_PUB.ADD;

1345: ,l_num_segments
1346: ,l_original_segments))
1347: Then
1348: FND_MESSAGE.SET_NAME('LNS', 'LNS_ERR_BUILDING_SEGMENTS');
1349: FND_MSG_PUB.ADD;
1350: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
1351: RAISE FND_API.G_EXC_ERROR;
1352: END IF;
1353:

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

1346: ,l_original_segments))
1347: Then
1348: FND_MESSAGE.SET_NAME('LNS', 'LNS_ERR_BUILDING_SEGMENTS');
1349: FND_MSG_PUB.ADD;
1350: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
1351: RAISE FND_API.G_EXC_ERROR;
1352: END IF;
1353:
1354: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Original segments:');

Line 1386: FND_MSG_PUB.ADD;

1382: l_new_segments,
1383: l_new_cc_id))
1384: Then
1385: FND_MESSAGE.SET_NAME('LNS', 'LNS_CODE_COMBINATION_ERROR');
1386: FND_MSG_PUB.ADD;
1387: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
1388: RAISE FND_API.G_EXC_ERROR;
1389:
1390: END IF;

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

1383: l_new_cc_id))
1384: Then
1385: FND_MESSAGE.SET_NAME('LNS', 'LNS_CODE_COMBINATION_ERROR');
1386: FND_MSG_PUB.ADD;
1387: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
1388: RAISE FND_API.G_EXC_ERROR;
1389:
1390: END IF;
1391: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'new cc_id = ' || l_new_cc_id);

Line 1466: FND_MSG_PUB.ADD;

1462:
1463: Exception
1464: When others then
1465: FND_MESSAGE.SET_NAME('LNS', 'LNS_MFAR_CONFIGURATION_ERROR');
1466: FND_MSG_PUB.ADD;
1467: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
1468: RAISE FND_API.G_EXC_ERROR;
1469: End;
1470: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'swap natural account with ' || l_natural_account_rec);

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

1463: Exception
1464: When others then
1465: FND_MESSAGE.SET_NAME('LNS', 'LNS_MFAR_CONFIGURATION_ERROR');
1466: FND_MSG_PUB.ADD;
1467: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
1468: RAISE FND_API.G_EXC_ERROR;
1469: End;
1470: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'swap natural account with ' || l_natural_account_rec);
1471: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'COA ' || l_ledger_details.chart_of_accounts_id);

Line 1482: FND_MSG_PUB.ADD;

1478: ,flex_qual_name => 'GL_ACCOUNT'
1479: ,segment_number => l_nat_acct_seg_number))
1480: THEN
1481: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_NATURAL_ACCOUNT_SEGMENT');
1482: FND_MSG_PUB.ADD;
1483: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
1484: RAISE FND_API.G_EXC_ERROR;
1485:
1486: END IF;

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

1479: ,segment_number => l_nat_acct_seg_number))
1480: THEN
1481: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_NATURAL_ACCOUNT_SEGMENT');
1482: FND_MSG_PUB.ADD;
1483: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
1484: RAISE FND_API.G_EXC_ERROR;
1485:
1486: END IF;
1487: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'natural acct segment is ' || l_nat_acct_seg_number);

Line 1951: FND_MSG_PUB.ADD;

1947:
1948: exception
1949: when others then
1950: FND_MESSAGE.SET_NAME('LNS', 'LNS_LEDGER_DETAILS_FAIL');
1951: FND_MSG_PUB.ADD;
1952: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
1953: RAISE FND_API.G_EXC_ERROR;
1954: end;
1955:

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

1948: exception
1949: when others then
1950: FND_MESSAGE.SET_NAME('LNS', 'LNS_LEDGER_DETAILS_FAIL');
1951: FND_MSG_PUB.ADD;
1952: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
1953: RAISE FND_API.G_EXC_ERROR;
1954: end;
1955:
1956: end getLedgerDetails;

Line 2483: FND_MSG_PUB.initialize;

2479: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
2480:
2481: -- Initialize message list IF p_init_msg_list is set to TRUE.
2482: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2483: FND_MSG_PUB.initialize;
2484: END IF;
2485:
2486: -- Initialize API return status to SUCCESS
2487: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2579: FND_MSG_PUB.Add;

2575: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'num is: ' || l_num_receivables_acc);
2576:
2577: if l_num_receivables_acc <> l_num_receivables_ers then
2578: FND_MESSAGE.Set_Name('LNS', 'LNS_AR_RECEIVABLES_UNACC');
2579: FND_MSG_PUB.Add;
2580: RAISE FND_API.G_EXC_ERROR;
2581: end if;
2582: */
2583:

Line 2589: FND_MSG_PUB.Add;

2585: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'loan recivables origination Count = ' || l_loan_receivables_orig.count );
2586: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'loan recivables billing Count = ' || l_loan_receivables_bill.count);
2587: if l_loan_receivables_orig.count <> l_loan_receivables_bill.count then
2588: FND_MESSAGE.Set_Name('LNS', 'LNS_ACC_INVALID_RECEIVABLES');
2589: FND_MSG_PUB.Add;
2590: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
2591: RAISE FND_API.G_EXC_ERROR;
2592: end if;
2593:

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

2586: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'loan recivables billing Count = ' || l_loan_receivables_bill.count);
2587: if l_loan_receivables_orig.count <> l_loan_receivables_bill.count then
2588: FND_MESSAGE.Set_Name('LNS', 'LNS_ACC_INVALID_RECEIVABLES');
2589: FND_MSG_PUB.Add;
2590: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
2591: RAISE FND_API.G_EXC_ERROR;
2592: end if;
2593:
2594: -- B. The account code combinations for the Loans Receivable accounts within

Line 2604: FND_MSG_PUB.Add;

2600: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'loan recivables origination cc_id = ' || l_loan_receivables_orig(j).code_combination_id );
2601: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'loan recivables billing cc_id = ' || l_loan_receivables_bill(j).code_combination_id);
2602: if l_loan_receivables_orig(j).code_combination_id <> l_loan_receivables_bill(j).code_combination_id then
2603: FND_MESSAGE.Set_Name('LNS', 'LNS_ACC_LOAN_REC_CCIDS_UNMATCH');
2604: FND_MSG_PUB.Add;
2605: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
2606: RAISE FND_API.G_EXC_ERROR;
2607: end if;
2608:

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

2601: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'loan recivables billing cc_id = ' || l_loan_receivables_bill(j).code_combination_id);
2602: if l_loan_receivables_orig(j).code_combination_id <> l_loan_receivables_bill(j).code_combination_id then
2603: FND_MESSAGE.Set_Name('LNS', 'LNS_ACC_LOAN_REC_CCIDS_UNMATCH');
2604: FND_MSG_PUB.Add;
2605: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
2606: RAISE FND_API.G_EXC_ERROR;
2607: end if;
2608:
2609: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'checking for duplicate IDs');

Line 2616: FND_MSG_PUB.Add;

2612: (l_loan_clearing_orig(j).code_combination_id = l_loan_clearing_orig(j+1).code_combination_id)
2613: then
2614: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'found duplicate IDs');
2615: FND_MESSAGE.Set_Name('LNS', 'LNS_UNIQUE_CC_IDS');
2616: FND_MSG_PUB.Add;
2617: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
2618: RAISE FND_API.G_EXC_ERROR;
2619: end if;
2620: end if;

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

2613: then
2614: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'found duplicate IDs');
2615: FND_MESSAGE.Set_Name('LNS', 'LNS_UNIQUE_CC_IDS');
2616: FND_MSG_PUB.Add;
2617: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
2618: RAISE FND_API.G_EXC_ERROR;
2619: end if;
2620: end if;
2621:

Line 2630: FND_MSG_PUB.Add;

2626: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'loan recivables origination percent = ' || l_loan_receivables_orig(j).distribution_percent );
2627: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'loan recivables billing percent = ' || l_loan_receivables_bill(j).distribution_percent);
2628: if l_loan_receivables_orig(j).distribution_percent <> l_loan_receivables_bill(j).distribution_percent then
2629: FND_MESSAGE.Set_Name('LNS', 'LNS_ACC_LOAN_REC_PER_UNMATCH');
2630: FND_MSG_PUB.Add;
2631: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
2632: RAISE FND_API.G_EXC_ERROR;
2633: end if;
2634:

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

2627: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'loan recivables billing percent = ' || l_loan_receivables_bill(j).distribution_percent);
2628: if l_loan_receivables_orig(j).distribution_percent <> l_loan_receivables_bill(j).distribution_percent then
2629: FND_MESSAGE.Set_Name('LNS', 'LNS_ACC_LOAN_REC_PER_UNMATCH');
2630: FND_MSG_PUB.Add;
2631: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
2632: RAISE FND_API.G_EXC_ERROR;
2633: end if;
2634:
2635: l_dist_percent_rec_orig := l_dist_percent_rec_orig + l_loan_receivables_orig(j).distribution_percent;

Line 2648: FND_MSG_PUB.Add;

2644: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'checking origination receivables total percentages');
2645: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'loan recivables total percent = ' || l_dist_percent_rec_orig);
2646: if l_dist_percent_rec_orig <> 100 then
2647: FND_MESSAGE.Set_Name('LNS', 'LNS_ACC_ORIG_REC_PER_INVALID');
2648: FND_MSG_PUB.Add;
2649: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
2650: RAISE FND_API.G_EXC_ERROR;
2651: end if;
2652: end if;

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

2645: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'loan recivables total percent = ' || l_dist_percent_rec_orig);
2646: if l_dist_percent_rec_orig <> 100 then
2647: FND_MESSAGE.Set_Name('LNS', 'LNS_ACC_ORIG_REC_PER_INVALID');
2648: FND_MSG_PUB.Add;
2649: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
2650: RAISE FND_API.G_EXC_ERROR;
2651: end if;
2652: end if;
2653:

Line 2659: FND_MSG_PUB.Add;

2655: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'checking billing receivables total percentages');
2656: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'loan recivables total percent: ' || l_dist_percent_rec_bill);
2657: if l_dist_percent_rec_bill <> 100 then
2658: FND_MESSAGE.Set_Name('LNS', 'LNS_ACC_BILL_REC_PER_INVALID');
2659: FND_MSG_PUB.Add;
2660: RAISE FND_API.G_EXC_ERROR;
2661: end if;
2662: */
2663:

Line 2669: FND_MSG_PUB.Add;

2665: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'loan clearing total percent = ' || l_dist_percent_clear_orig);
2666: /*
2667: if l_dist_percent_clear_orig <> 100 then
2668: FND_MESSAGE.Set_Name('LNS', 'LNS_ACC_ORIG_CLR_PER_INVALID');
2669: FND_MSG_PUB.Add;
2670: RAISE FND_API.G_EXC_ERROR;
2671: end if;
2672: */
2673: -- G. In the current release of 11i, there must be only one Principal Receivable

Line 2679: FND_MSG_PUB.Add;

2675: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'checking principal receivables count');
2676: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'principal receivables count = ' || l_prin_receivables_bill.count);
2677: if l_prin_receivables_bill.count <> 1 then
2678: FND_MESSAGE.Set_Name('LNS', 'LNS_ACC_MULT_PRIN_RECEIVABLE');
2679: FND_MSG_PUB.Add;
2680: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
2681: RAISE FND_API.G_EXC_ERROR;
2682: end if;
2683:

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

2676: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'principal receivables count = ' || l_prin_receivables_bill.count);
2677: if l_prin_receivables_bill.count <> 1 then
2678: FND_MESSAGE.Set_Name('LNS', 'LNS_ACC_MULT_PRIN_RECEIVABLE');
2679: FND_MSG_PUB.Add;
2680: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
2681: RAISE FND_API.G_EXC_ERROR;
2682: end if;
2683:
2684: -- H. In the current release of 11i, there must be only one Interest Receivable

Line 2690: FND_MSG_PUB.Add;

2686: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'checking Interest receivables count');
2687: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Interest receivables count = ' || l_int_receivables_bill.count);
2688: if l_int_receivables_bill.count <> 1 then
2689: FND_MESSAGE.Set_Name('LNS', 'LNS_ACC_MULT_INT_RECEIVABLE');
2690: FND_MSG_PUB.Add;
2691: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
2692: RAISE FND_API.G_EXC_ERROR;
2693: end if;
2694:

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

2687: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Interest receivables count = ' || l_int_receivables_bill.count);
2688: if l_int_receivables_bill.count <> 1 then
2689: FND_MESSAGE.Set_Name('LNS', 'LNS_ACC_MULT_INT_RECEIVABLE');
2690: FND_MSG_PUB.Add;
2691: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
2692: RAISE FND_API.G_EXC_ERROR;
2693: end if;
2694:
2695: -- I. There may be multiple Interest Income accounts

Line 2700: FND_MSG_PUB.Add;

2696: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'checking Interest Income count');
2697: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Interest Income count = ' || l_int_income_bill.count);
2698: if l_int_income_bill.count < 1 then
2699: FND_MESSAGE.Set_Name('LNS', 'LNS_ACC_NO_INTEREST_INCOME');
2700: FND_MSG_PUB.Add;
2701: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
2702: RAISE FND_API.G_EXC_ERROR;
2703: end if;
2704:

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

2697: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Interest Income count = ' || l_int_income_bill.count);
2698: if l_int_income_bill.count < 1 then
2699: FND_MESSAGE.Set_Name('LNS', 'LNS_ACC_NO_INTEREST_INCOME');
2700: FND_MSG_PUB.Add;
2701: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
2702: RAISE FND_API.G_EXC_ERROR;
2703: end if;
2704:
2705: -- J. The distribution percentages for Interest Income must add to 100%

Line 2714: FND_MSG_PUB.Add;

2710: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'checking Interest Income percentage');
2711: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Interest Income percentage = ' || l_dist_percent_int_income);
2712: if l_dist_percent_int_income <> 100 then
2713: FND_MESSAGE.Set_Name('LNS', 'LNS_ACC_INT_INCOME_PER_INVALID');
2714: FND_MSG_PUB.Add;
2715: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
2716: RAISE FND_API.G_EXC_ERROR;
2717: end if;
2718:

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

2711: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Interest Income percentage = ' || l_dist_percent_int_income);
2712: if l_dist_percent_int_income <> 100 then
2713: FND_MESSAGE.Set_Name('LNS', 'LNS_ACC_INT_INCOME_PER_INVALID');
2714: FND_MSG_PUB.Add;
2715: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
2716: RAISE FND_API.G_EXC_ERROR;
2717: end if;
2718:
2719: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

Line 2719: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

2715: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
2716: RAISE FND_API.G_EXC_ERROR;
2717: end if;
2718:
2719: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
2720: ,p_data => x_msg_data);
2721:
2722: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
2723:

Line 2727: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

2723:
2724: Exception
2725: WHEN FND_API.G_EXC_ERROR THEN
2726: x_return_status := FND_API.G_RET_STS_ERROR;
2727: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
2728: ,p_data => x_msg_data);
2729: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
2730:
2731: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2733: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

2729: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
2730:
2731: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2732: x_return_status := FND_API.G_RET_STS_ERROR;
2733: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
2734: ,p_data => x_msg_data);
2735: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
2736:
2737: WHEN OTHERS THEN

Line 2739: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

2735: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
2736:
2737: WHEN OTHERS THEN
2738: x_return_status := FND_API.G_RET_STS_ERROR;
2739: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
2740: ,p_data => x_msg_data);
2741: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
2742:
2743: end validateAccounting;

Line 2882: FND_MSG_PUB.initialize;

2878: SAVEPOINT validateLoanLines;
2879:
2880: -- Initialize message list IF p_init_msg_list is set to TRUE.
2881: IF FND_API.to_Boolean(p_init_msg_list) THEN
2882: FND_MSG_PUB.initialize;
2883: END IF;
2884:
2885: -- Initialize API return status to SUCCESS
2886: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

2970: -- ---------------------------------------------------------------------
2971: -- End of API body
2972: -- ---------------------------------------------------------------------
2973:
2974: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2975:
2976: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
2977:
2978: EXCEPTION

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

2980: ROLLBACK TO validateLoanLines;
2981: x_return_status := FND_API.G_RET_STS_ERROR;
2982: x_msg_count := l_msg_count;
2983: x_msg_data := l_msg_data;
2984: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2985: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
2986:
2987: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2988: ROLLBACK TO validateLoanLines;

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

2988: ROLLBACK TO validateLoanLines;
2989: x_return_status := FND_API.G_RET_STS_ERROR;
2990: x_msg_count := l_msg_count;
2991: x_msg_data := l_msg_data;
2992: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2993: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
2994:
2995: WHEN OTHERS THEN
2996: ROLLBACK TO validateLoanLines;

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

2996: ROLLBACK TO validateLoanLines;
2997: x_return_status := FND_API.G_RET_STS_ERROR;
2998: x_msg_count := l_msg_count;
2999: x_msg_data := l_msg_data;
3000: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3001: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
3002:
3003: end validateLoanLines;
3004:

Line 3073: FND_MSG_PUB.initialize;

3069: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_loan_id = ' || p_loan_id);
3070:
3071: -- Initialize message list IF p_init_msg_list is set to TRUE.
3072: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3073: FND_MSG_PUB.initialize;
3074: END IF;
3075:
3076: -- Initialize API return status to SUCCESS
3077: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

3182: THEN
3183: COMMIT WORK;
3184: END IF;
3185:
3186: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3187: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
3188:
3189: EXCEPTION
3190:

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

3191: WHEN FND_API.G_EXC_ERROR THEN
3192: ROLLBACK TO create_DisbursementDistribs;
3193: x_return_status := FND_API.G_RET_STS_ERROR;
3194: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
3195: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3196:
3197: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3198: ROLLBACK TO create_DisbursementDistribs;
3199: x_return_status := FND_API.G_RET_STS_ERROR;

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

3197: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3198: ROLLBACK TO create_DisbursementDistribs;
3199: x_return_status := FND_API.G_RET_STS_ERROR;
3200: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
3201: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3202:
3203: WHEN OTHERS THEN
3204: ROLLBACK TO create_DisbursementDistribs;
3205: x_return_status := FND_API.G_RET_STS_ERROR;

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

3203: WHEN OTHERS THEN
3204: ROLLBACK TO create_DisbursementDistribs;
3205: x_return_status := FND_API.G_RET_STS_ERROR;
3206: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
3207: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3208:
3209: end create_DisbursementDistribs;
3210:
3211: /*=========================================================================

Line 3477: FND_MSG_PUB.initialize;

3473: logMessage(FND_LOG.level_statement, G_PKG_NAME, 'p_loan_class_code = ' || p_loan_class_code);
3474:
3475: -- Initialize message list IF p_init_msg_list is set to TRUE.
3476: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3477: FND_MSG_PUB.initialize;
3478: END IF;
3479:
3480: -- Initialize API return status to SUCCESS
3481: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3533: FND_MSG_PUB.ADD;

3529:
3530: logMessage(FND_LOG.level_statement, G_PKG_NAME, 'l_return_status = ' || l_return_status);
3531: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
3532: FND_MESSAGE.SET_NAME('LNS', 'LNS_DEFAULT_DIST_NOT_FOUND');
3533: FND_MSG_PUB.ADD;
3534: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
3535: RAISE FND_API.G_EXC_ERROR;
3536: end if;
3537:

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

3530: logMessage(FND_LOG.level_statement, G_PKG_NAME, 'l_return_status = ' || l_return_status);
3531: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
3532: FND_MESSAGE.SET_NAME('LNS', 'LNS_DEFAULT_DIST_NOT_FOUND');
3533: FND_MSG_PUB.ADD;
3534: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
3535: RAISE FND_API.G_EXC_ERROR;
3536: end if;
3537:
3538: /* delete any rows for this loan before inheritance do not delete FEE_RECEIVABLE or FEE_INCOME rows*/

Line 3563: FND_MSG_PUB.ADD;

3559: close c_subsidy_rate;
3560: exception
3561: when no_data_found then
3562: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_SUBSIDY_RATE');
3563: FND_MSG_PUB.ADD;
3564: RAISE FND_API.G_EXC_ERROR;
3565: end;
3566:
3567: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' l_subsidy_rate ' || l_subsidy_rate );

Line 3585: FND_MSG_PUB.ADD;

3581: ,X_MSG_DATA => l_msg_data);
3582: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' update loan status = ' || l_return_status);
3583: if l_return_status <> 'S' then
3584: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
3585: FND_MSG_PUB.ADD;
3586: RAISE FND_API.G_EXC_ERROR;
3587: end if;
3588: */
3589: logMessage(FND_LOG.level_statement, G_PKG_NAME, 'DIRECT LOAN INHERITANCE');

Line 3660: FND_MSG_PUB.ADD;

3656:
3657: if l_return_status <> 'S' then
3658: FND_MESSAGE.SET_NAME('LNS', 'LNS_CHK_UPG_FAIL');
3659: FND_MESSAGE.SET_TOKEN('DOC_NUM', l_trx_number);
3660: FND_MSG_PUB.ADD;
3661: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
3662: RAISE FND_API.G_EXC_ERROR;
3663: else
3664: if l_upgrade_status <> 'Y' then

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

3657: if l_return_status <> 'S' then
3658: FND_MESSAGE.SET_NAME('LNS', 'LNS_CHK_UPG_FAIL');
3659: FND_MESSAGE.SET_TOKEN('DOC_NUM', l_trx_number);
3660: FND_MSG_PUB.ADD;
3661: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
3662: RAISE FND_API.G_EXC_ERROR;
3663: else
3664: if l_upgrade_status <> 'Y' then
3665: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_TRX');

Line 3667: FND_MSG_PUB.ADD;

3663: else
3664: if l_upgrade_status <> 'Y' then
3665: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_TRX');
3666: FND_MESSAGE.SET_TOKEN('DOC_NUM', l_trx_number);
3667: FND_MSG_PUB.ADD;
3668: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
3669: RAISE FND_API.G_EXC_ERROR;
3670: end if;
3671: end if;

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

3664: if l_upgrade_status <> 'Y' then
3665: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_TRX');
3666: FND_MESSAGE.SET_TOKEN('DOC_NUM', l_trx_number);
3667: FND_MSG_PUB.ADD;
3668: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
3669: RAISE FND_API.G_EXC_ERROR;
3670: end if;
3671: end if;
3672:

Line 3730: FND_MSG_PUB.Add;

3726: l_error_counter := l_error_counter + 1;
3727:
3728: if l_error_counter = 1 then
3729: FND_MESSAGE.SET_NAME('LNS', 'LNS_ONLINE_ACCOUNTING_FAILED');
3730: FND_MSG_PUB.Add;
3731: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
3732: end if;
3733:
3734: FND_MESSAGE.SET_NAME('LNS', 'LNS_ACC_DOC_FAIL');

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

3727:
3728: if l_error_counter = 1 then
3729: FND_MESSAGE.SET_NAME('LNS', 'LNS_ONLINE_ACCOUNTING_FAILED');
3730: FND_MSG_PUB.Add;
3731: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
3732: end if;
3733:
3734: FND_MESSAGE.SET_NAME('LNS', 'LNS_ACC_DOC_FAIL');
3735: FND_MESSAGE.SET_TOKEN('DOC_NUM', l_invoice_number);

Line 3738: FND_MSG_PUB.Add;

3734: FND_MESSAGE.SET_NAME('LNS', 'LNS_ACC_DOC_FAIL');
3735: FND_MESSAGE.SET_TOKEN('DOC_NUM', l_invoice_number);
3736: FND_MESSAGE.SET_TOKEN('DOC_TYPE', l_entity_code);
3737: FND_MESSAGE.SET_TOKEN('ACC_ERR', l_error_message);
3738: FND_MSG_PUB.Add;
3739: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
3740:
3741: END LOOP;
3742:

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

3735: FND_MESSAGE.SET_TOKEN('DOC_NUM', l_invoice_number);
3736: FND_MESSAGE.SET_TOKEN('DOC_TYPE', l_entity_code);
3737: FND_MESSAGE.SET_TOKEN('ACC_ERR', l_error_message);
3738: FND_MSG_PUB.Add;
3739: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
3740:
3741: END LOOP;
3742:
3743: close c_acc_errors;

Line 3763: FND_MSG_PUB.ADD;

3759: ,flex_qual_name => 'GL_ACCOUNT'
3760: ,segment_number => l_nat_acct_seg_number))
3761: THEN
3762: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_NATURAL_ACCOUNT_SEGMENT');
3763: FND_MSG_PUB.ADD;
3764: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
3765: RAISE FND_API.G_EXC_ERROR;
3766: END IF;
3767: logMessage(FND_LOG.level_statement, G_PKG_NAME, 'Natural acct segment = ' || l_nat_acct_seg_number);

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

3760: ,segment_number => l_nat_acct_seg_number))
3761: THEN
3762: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_NATURAL_ACCOUNT_SEGMENT');
3763: FND_MSG_PUB.ADD;
3764: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
3765: RAISE FND_API.G_EXC_ERROR;
3766: END IF;
3767: logMessage(FND_LOG.level_statement, G_PKG_NAME, 'Natural acct segment = ' || l_nat_acct_seg_number);
3768:

Line 3807: FND_MSG_PUB.ADD;

3803: exception
3804: when others then
3805: --logMessage(FND_LOG.LEVEL_UNEX, G_PKG_NAME, 'Failed to inherit receivables distributions');
3806: FND_MESSAGE.SET_NAME('LNS', 'LNS_INHERIT_DIST_NOT_FOUND');
3807: FND_MSG_PUB.ADD;
3808: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
3809: RAISE FND_API.G_EXC_ERROR;
3810: end;
3811:

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

3804: when others then
3805: --logMessage(FND_LOG.LEVEL_UNEX, G_PKG_NAME, 'Failed to inherit receivables distributions');
3806: FND_MESSAGE.SET_NAME('LNS', 'LNS_INHERIT_DIST_NOT_FOUND');
3807: FND_MSG_PUB.ADD;
3808: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
3809: RAISE FND_API.G_EXC_ERROR;
3810: end;
3811:
3812: --logMessage(FND_LOG.level_statement, G_PKG_NAME, 'After loan clearing lines calculated. total amount due = ' || l_total_amount_due);

Line 3885: FND_MSG_PUB.ADD;

3881: exception
3882: when others then
3883: -- logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'failed to inherit receivables distributions');
3884: FND_MESSAGE.SET_NAME('LNS', 'LNS_INHERIT_DIST_NOT_FOUND');
3885: FND_MSG_PUB.ADD;
3886: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
3887: RAISE FND_API.G_EXC_ERROR;
3888: end;
3889:

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

3882: when others then
3883: -- logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'failed to inherit receivables distributions');
3884: FND_MESSAGE.SET_NAME('LNS', 'LNS_INHERIT_DIST_NOT_FOUND');
3885: FND_MSG_PUB.ADD;
3886: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
3887: RAISE FND_API.G_EXC_ERROR;
3888: end;
3889:
3890: else

Line 4041: FND_MSG_PUB.ADD;

4037:
4038: logMessage(FND_LOG.level_statement, G_PKG_NAME, 'l_return_status = ' || l_return_status);
4039: if l_return_status <> 'S' then
4040: FND_MESSAGE.SET_NAME('LNS', 'LNS_DEFAULT_DIST_NOT_FOUND');
4041: FND_MSG_PUB.ADD;
4042: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
4043: RAISE FND_API.G_EXC_ERROR;
4044: end if;
4045:

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

4038: logMessage(FND_LOG.level_statement, G_PKG_NAME, 'l_return_status = ' || l_return_status);
4039: if l_return_status <> 'S' then
4040: FND_MESSAGE.SET_NAME('LNS', 'LNS_DEFAULT_DIST_NOT_FOUND');
4041: FND_MSG_PUB.ADD;
4042: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
4043: RAISE FND_API.G_EXC_ERROR;
4044: end if;
4045:
4046: IF FND_API.to_Boolean(p_commit) THEN

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

4046: IF FND_API.to_Boolean(p_commit) THEN
4047: COMMIT WORK;
4048: END IF;
4049:
4050: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
4051: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
4052:
4053: EXCEPTION
4054:

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

4054:
4055: WHEN FND_API.G_EXC_ERROR THEN
4056: ROLLBACK TO defaultDistributions;
4057: x_return_status := FND_API.G_RET_STS_ERROR;
4058: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
4059: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
4060:
4061: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4062: ROLLBACK TO defaultDistributions;

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

4060:
4061: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4062: ROLLBACK TO defaultDistributions;
4063: x_return_status := FND_API.G_RET_STS_ERROR;
4064: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
4065: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
4066:
4067: WHEN OTHERS THEN
4068: ROLLBACK TO defaultDistributions;

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

4066:
4067: WHEN OTHERS THEN
4068: ROLLBACK TO defaultDistributions;
4069: x_return_status := FND_API.G_RET_STS_ERROR;
4070: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
4071: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
4072:
4073: end defaultDistributions;
4074:

Line 4177: FND_MSG_PUB.initialize;

4173: -- Initialize API return status to SUCCESS
4174: x_return_status := FND_API.G_RET_STS_SUCCESS;
4175: -- Initialize message list IF p_init_msg_list is set to TRUE.
4176: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4177: FND_MSG_PUB.initialize;
4178: END IF;
4179:
4180: open c_loan_info(p_loan_id);
4181: fetch c_loan_info into l_legal_entity_id, l_loan_class;

Line 4252: --FND_MSG_PUB.Add;

4248:
4249: if l_retcode = 0 then
4250:
4251: --FND_MESSAGE.SET_NAME('XLA', 'XLA_ONLINE_ACCT_SUCCESS');
4252: --FND_MSG_PUB.Add;
4253: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'online accounting SUCCESS! ');
4254:
4255: elsif l_retcode = 2 then
4256:

Line 4258: FND_MSG_PUB.Add;

4254:
4255: elsif l_retcode = 2 then
4256:
4257: FND_MESSAGE.SET_NAME('XLA', 'XLA_ONLINE_ACCTG_ERROR');
4258: FND_MSG_PUB.Add;
4259: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
4260: RAISE FND_API.G_EXC_ERROR;
4261:
4262: elsif l_retcode = 1 then

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

4255: elsif l_retcode = 2 then
4256:
4257: FND_MESSAGE.SET_NAME('XLA', 'XLA_ONLINE_ACCTG_ERROR');
4258: FND_MSG_PUB.Add;
4259: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
4260: RAISE FND_API.G_EXC_ERROR;
4261:
4262: elsif l_retcode = 1 then
4263:

Line 4281: FND_MSG_PUB.Add;

4277: l_error_counter := l_error_counter + 1;
4278:
4279: if l_error_counter = 1 then
4280: FND_MESSAGE.SET_NAME('XLA', 'XLA_ONLINE_ACCT_WARNING');
4281: FND_MSG_PUB.Add;
4282: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
4283: end if;
4284:
4285: FND_MESSAGE.SET_NAME('LNS', 'LNS_ACC_DOC_FAIL');

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

4278:
4279: if l_error_counter = 1 then
4280: FND_MESSAGE.SET_NAME('XLA', 'XLA_ONLINE_ACCT_WARNING');
4281: FND_MSG_PUB.Add;
4282: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
4283: end if;
4284:
4285: FND_MESSAGE.SET_NAME('LNS', 'LNS_ACC_DOC_FAIL');
4286: FND_MESSAGE.SET_TOKEN('DOC_NUM', l_invoice_number);

Line 4289: FND_MSG_PUB.Add;

4285: FND_MESSAGE.SET_NAME('LNS', 'LNS_ACC_DOC_FAIL');
4286: FND_MESSAGE.SET_TOKEN('DOC_NUM', l_invoice_number);
4287: FND_MESSAGE.SET_TOKEN('DOC_TYPE', l_entity_code);
4288: FND_MESSAGE.SET_TOKEN('ACC_ERR', l_error_message);
4289: FND_MSG_PUB.Add;
4290: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
4291:
4292: END LOOP;
4293:

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

4286: FND_MESSAGE.SET_TOKEN('DOC_NUM', l_invoice_number);
4287: FND_MESSAGE.SET_TOKEN('DOC_TYPE', l_entity_code);
4288: FND_MESSAGE.SET_TOKEN('ACC_ERR', l_error_message);
4289: FND_MSG_PUB.Add;
4290: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
4291:
4292: END LOOP;
4293:
4294: close c_acc_errors;

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

4295:
4296: RAISE FND_API.G_EXC_ERROR;
4297: end if;
4298:
4299: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
4300: commit;
4301: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
4302:
4303: EXCEPTION

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

4305: WHEN FND_API.G_EXC_ERROR THEN
4306: ROLLBACK TO onlineAccounting;
4307: x_return_status := FND_API.G_RET_STS_ERROR;
4308: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
4309: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
4310:
4311: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4312: ROLLBACK TO onlineAccounting;
4313: x_return_status := FND_API.G_RET_STS_ERROR;

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

4311: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4312: ROLLBACK TO onlineAccounting;
4313: x_return_status := FND_API.G_RET_STS_ERROR;
4314: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
4315: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
4316:
4317: WHEN OTHERS THEN
4318: ROLLBACK TO onlineAccounting;
4319: x_return_status := FND_API.G_RET_STS_ERROR;

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

4317: WHEN OTHERS THEN
4318: ROLLBACK TO onlineAccounting;
4319: x_return_status := FND_API.G_RET_STS_ERROR;
4320: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
4321: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
4322:
4323: end onlineAccounting;
4324:
4325:

Line 4404: FND_MSG_PUB.Add;

4400: if P_LOAN_ID is null then
4401:
4402: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Loan must be set.');
4403: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_LOAN');
4404: FND_MSG_PUB.Add;
4405: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
4406: RAISE FND_API.G_EXC_ERROR;
4407:
4408: end if;

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

4401:
4402: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Loan must be set.');
4403: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_LOAN');
4404: FND_MSG_PUB.Add;
4405: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
4406: RAISE FND_API.G_EXC_ERROR;
4407:
4408: end if;
4409:

Line 4442: FND_MSG_PUB.ADD;

4438: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_return_status = ' || l_return_status);
4439:
4440: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4441: FND_MESSAGE.SET_NAME('LNS', 'LNS_ACCOUNTING_EVENT_ERROR');
4442: FND_MSG_PUB.ADD;
4443: --l_last_api_called := 'LNS_XLA_EVENTS.create_event';
4444: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
4445: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4446: END IF;

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

4440: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4441: FND_MESSAGE.SET_NAME('LNS', 'LNS_ACCOUNTING_EVENT_ERROR');
4442: FND_MSG_PUB.ADD;
4443: --l_last_api_called := 'LNS_XLA_EVENTS.create_event';
4444: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
4445: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4446: END IF;
4447:
4448:

Line 4542: FND_MSG_PUB.Add;

4538:
4539: if l_request_id = 0 then
4540: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4541: FND_MESSAGE.SET_NAME('LNS', 'LNS_BILLING_REQUEST_FAILED');
4542: FND_MSG_PUB.Add;
4543: l_last_api_called := 'FND_REQUEST.SUBMIT_REQUEST for 0th installment billing';
4544: RAISE FND_API.G_EXC_ERROR;
4545: else
4546: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Successfully submited Billing Concurrent Program to bill 0-th installment. Request id = ' || l_request_id);

Line 4565: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => ERRBUF);

4561: l_return := FND_CONCURRENT.SET_COMPLETION_STATUS(
4562: status => 'ERROR',
4563: message => 'Generate Distributions process has failed. Please review log file.');
4564: RETCODE := FND_API.G_RET_STS_ERROR;
4565: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => ERRBUF);
4566: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, ' ');
4567: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, '-------------------');
4568: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'Generate Distributions process has failed!');
4569:

Line 4597: FND_MSG_PUB.initialize;

4593: logmessage(fnd_log.level_statement, G_PKG_NAME, 'p_loan_class_code = ' || p_loan_class_code);
4594:
4595: -- Initialize message list IF p_init_msg_list is set to TRUE.
4596: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4597: FND_MSG_PUB.initialize;
4598: END IF;
4599:
4600: logMessage(FND_LOG.level_statement, G_PKG_NAME, 'Calling defaultDistributionsCatch...');
4601: LNS_DISTRIBUTIONS_PUB.defaultDistributionsCatch(

Line 4639: FND_MSG_PUB.ADD;

4635:
4636: logMessage(FND_LOG.level_statement, G_PKG_NAME, 'l_return_status = ' || l_return_status);
4637: if l_return_status <> 'S' then
4638: FND_MESSAGE.SET_NAME('LNS', 'LNS_DEFAULT_DIST_NOT_FOUND');
4639: FND_MSG_PUB.ADD;
4640: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
4641: RAISE FND_API.G_EXC_ERROR;
4642: end if;
4643:

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

4636: logMessage(FND_LOG.level_statement, G_PKG_NAME, 'l_return_status = ' || l_return_status);
4637: if l_return_status <> 'S' then
4638: FND_MESSAGE.SET_NAME('LNS', 'LNS_DEFAULT_DIST_NOT_FOUND');
4639: FND_MSG_PUB.ADD;
4640: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
4641: RAISE FND_API.G_EXC_ERROR;
4642: end if;
4643:
4644: x_return_status := fnd_api.g_ret_sts_success;

Line 4650: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

4646:
4647: EXCEPTION
4648: WHEN others THEN
4649: x_return_status := fnd_api.g_ret_sts_unexp_error;
4650: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4651: END;
4652:
4653:
4654: