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

Line 222: FND_MSG_PUB.initialize;

218: END IF;
219:
220: -- Initialize message list IF p_init_msg_list is set to TRUE.
221: IF FND_API.to_Boolean(p_init_msg_list) THEN
222: FND_MSG_PUB.initialize;
223: END IF;
224:
225: -- Initialize API return status to SUCCESS
226: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

272: ,x_return_status => l_return_status
273: ,x_msg_count => l_msg_count
274: ,x_msg_data => l_msg_data);
275: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
276: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || FND_MSG_PUB.Get(p_encoded => 'F'));
277: RAISE FND_API.G_EXC_ERROR;
278: END IF;
279: */
280: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - calculating Payoff ');

Line 292: FND_MSG_PUB.Add;

288: ,x_msg_data => l_msg_data);
289:
290: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
291: FND_MESSAGE.SET_NAME('LNS', 'LNS_CALCULATE_PAYOFF_ERROR');
292: FND_MSG_PUB.Add;
293: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || FND_MSG_PUB.Get(p_encoded => 'F'));
294: RAISE FND_API.G_EXC_ERROR;
295: END IF;
296:

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

289:
290: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
291: FND_MESSAGE.SET_NAME('LNS', 'LNS_CALCULATE_PAYOFF_ERROR');
292: FND_MSG_PUB.Add;
293: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || FND_MSG_PUB.Get(p_encoded => 'F'));
294: RAISE FND_API.G_EXC_ERROR;
295: END IF;
296:
297: --2. create payoff document(s) in receivables

Line 376: FND_MSG_PUB.Add;

372: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
373: FND_MESSAGE.SET_NAME('LNS', 'LNS_UNAPPLY_CASH_ERROR');
374: FND_MESSAGE.SET_TOKEN('PARAMETER', 'RECEIPT_NUMBER');
375: FND_MESSAGE.SET_TOKEN('VALUE', l_receipt_number);
376: FND_MSG_PUB.Add;
377: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
378: RAISE FND_API.G_EXC_ERROR;
379: end if;
380:

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

373: FND_MESSAGE.SET_NAME('LNS', 'LNS_UNAPPLY_CASH_ERROR');
374: FND_MESSAGE.SET_TOKEN('PARAMETER', 'RECEIPT_NUMBER');
375: FND_MESSAGE.SET_TOKEN('VALUE', l_receipt_number);
376: FND_MSG_PUB.Add;
377: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
378: RAISE FND_API.G_EXC_ERROR;
379: end if;
380:
381:

Line 434: FND_MSG_PUB.Add;

430: ,X_MSG_DATA => l_msg_data);
431:
432: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
433: FND_MESSAGE.SET_NAME('LNS', 'LNS_CREDIT_MEMO_ERROR');
434: FND_MSG_PUB.Add;
435: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
436: RAISE FND_API.G_EXC_ERROR;
437: end if;
438:

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

431:
432: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
433: FND_MESSAGE.SET_NAME('LNS', 'LNS_CREDIT_MEMO_ERROR');
434: FND_MSG_PUB.Add;
435: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
436: RAISE FND_API.G_EXC_ERROR;
437: end if;
438:
439: -- 4. create new interest and principal document for difference

Line 501: FND_MSG_PUB.Add;

497: ,x_msg_data => l_msg_data);
498:
499: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
500: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVOICE_CREATION_ERROR');
501: FND_MSG_PUB.Add;
502: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
503: RAISE FND_API.G_EXC_ERROR;
504: END IF;
505:

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

498:
499: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
500: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVOICE_CREATION_ERROR');
501: FND_MSG_PUB.Add;
502: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
503: RAISE FND_API.G_EXC_ERROR;
504: END IF;
505:
506: end if;

Line 522: FND_MSG_PUB.Add;

518: ,x_msg_data => l_msg_data);
519:
520: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
521: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVOICE_SUMMARY_ERROR');
522: FND_MSG_PUB.Add;
523: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
524: RAISE FND_API.G_EXC_ERROR;
525: END IF;
526:

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

519:
520: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
521: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVOICE_SUMMARY_ERROR');
522: FND_MSG_PUB.Add;
523: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
524: RAISE FND_API.G_EXC_ERROR;
525: END IF;
526:
527: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - # of unpaid invoices to process = ' || l_invoices_tbl.count);

Line 561: FND_MSG_PUB.Add;

557: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - total payoff amount: ' || l_total_payoff_amount);
558:
559: if l_total_receipts_amount < l_total_payoff_amount then
560: FND_MESSAGE.SET_NAME('LNS', 'LNS_PAYOFF_SHORT_CASH');
561: FND_MSG_PUB.Add;
562: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
563: RAISE FND_API.G_EXC_ERROR;
564: end if;
565:

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

558:
559: if l_total_receipts_amount < l_total_payoff_amount then
560: FND_MESSAGE.SET_NAME('LNS', 'LNS_PAYOFF_SHORT_CASH');
561: FND_MSG_PUB.Add;
562: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
563: RAISE FND_API.G_EXC_ERROR;
564: end if;
565:
566: --5. apply cash

Line 613: FND_MSG_PUB.Add;

609: if j = l_cash_receipt_ids.count then
610: -- we have gone thru all the cash receipts and there is not enough
611: -- open receipts in the list to cover this invoice
612: FND_MESSAGE.SET_NAME('LNS', 'LNS_ALL_RECEIPTS_EXHAUSTED');
613: FND_MSG_PUB.Add;
614: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
615: RAISE FND_API.G_EXC_ERROR;
616: end if;
617:

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

610: -- we have gone thru all the cash receipts and there is not enough
611: -- open receipts in the list to cover this invoice
612: FND_MESSAGE.SET_NAME('LNS', 'LNS_ALL_RECEIPTS_EXHAUSTED');
613: FND_MSG_PUB.Add;
614: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
615: RAISE FND_API.G_EXC_ERROR;
616: end if;
617:
618: else

Line 661: FND_MSG_PUB.Add;

657: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
658: FND_MESSAGE.SET_NAME('LNS', 'LNS_APPLY_CASH_ERROR');
659: FND_MESSAGE.SET_TOKEN('PARAMETER', 'RECEIPT_NUMBER');
660: FND_MESSAGE.SET_TOKEN('VALUE', l_cash_receipt_ids(j).receipt_number);
661: FND_MSG_PUB.Add;
662: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
663: RAISE FND_API.G_EXC_ERROR;
664: END IF;
665:

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

658: FND_MESSAGE.SET_NAME('LNS', 'LNS_APPLY_CASH_ERROR');
659: FND_MESSAGE.SET_TOKEN('PARAMETER', 'RECEIPT_NUMBER');
660: FND_MESSAGE.SET_TOKEN('VALUE', l_cash_receipt_ids(j).receipt_number);
661: FND_MSG_PUB.Add;
662: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
663: RAISE FND_API.G_EXC_ERROR;
664: END IF;
665:
666: l_invoice_amount_remaining := l_invoice_amount_remaining - l_amount_to_apply;

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

739: X_MSG_COUNT => l_msg_count,
740: X_MSG_DATA => l_msg_data);
741: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
742: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPDATE_HEADER_ERROR');
743: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
744: RAISE FND_API.G_EXC_ERROR;
745:
746: update lns_fee_schedules
747: set billed_flag = 'Y'

Line 770: FND_MSG_PUB.Add;

766: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - header update status: ' || l_return_status);
767:
768: else
769: FND_MESSAGE.SET_NAME('LNS', 'LNS_FINAL_BALANCE_ERROR');
770: FND_MSG_PUB.Add;
771: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
772: RAISE FND_API.G_EXC_ERROR;
773: end if;
774: */

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

767:
768: else
769: FND_MESSAGE.SET_NAME('LNS', 'LNS_FINAL_BALANCE_ERROR');
770: FND_MSG_PUB.Add;
771: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
772: RAISE FND_API.G_EXC_ERROR;
773: end if;
774: */
775: -- ---------------------------------------------------------------------

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

775: -- ---------------------------------------------------------------------
776: -- End of API body
777: --
778:
779: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
780:
781: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
782:
783: EXCEPTION

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

785: ROLLBACK TO processPayoff;
786: x_return_status := FND_API.G_RET_STS_ERROR;
787: x_msg_count := l_msg_count;
788: x_msg_data := l_msg_data;
789: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
790: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
791:
792: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
793: ROLLBACK TO processPayoff;

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

793: ROLLBACK TO processPayoff;
794: x_return_status := FND_API.G_RET_STS_ERROR;
795: x_msg_count := l_msg_count;
796: x_msg_data := l_msg_data;
797: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
798: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
799:
800: WHEN OTHERS THEN
801: ROLLBACK TO processPayoff;

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

801: ROLLBACK TO processPayoff;
802: x_return_status := FND_API.G_RET_STS_ERROR;
803: x_msg_count := l_msg_count;
804: x_msg_data := l_msg_data;
805: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
806: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
807:
808: end processPayoff;
809:

Line 942: FND_MSG_PUB.initialize;

938: END IF;
939:
940: -- Initialize message list IF p_init_msg_list is set to TRUE.
941: IF FND_API.to_Boolean(p_init_msg_list) THEN
942: FND_MSG_PUB.initialize;
943: END IF;
944:
945: -- Initialize API return status to SUCCESS
946: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

994: ,x_msg_count => l_msg_count
995: ,x_msg_data => l_msg_data);
996: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
997: --FND_MESSAGE.SET_NAME('LNS', 'LNS_UPDATE_HEADER_ERROR');
998: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
999: RAISE FND_API.G_EXC_ERROR;
1000: END IF;
1001:
1002: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - payoff tbl count ' || l_payoff_tbl2.count);

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

1094: -- --------------------------------------------------------------------
1095: -- End of API body
1096: --
1097:
1098: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1099:
1100: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
1101:
1102: EXCEPTION

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

1104: ROLLBACK TO getLoanInvoices;
1105: x_return_status := FND_API.G_RET_STS_ERROR;
1106: x_msg_count := l_msg_count;
1107: x_msg_data := l_msg_data;
1108: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1109: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
1110:
1111: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1112: ROLLBACK TO getLoanInvoices;

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

1112: ROLLBACK TO getLoanInvoices;
1113: x_return_status := FND_API.G_RET_STS_ERROR;
1114: x_msg_count := l_msg_count;
1115: x_msg_data := l_msg_data;
1116: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1117: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
1118:
1119: WHEN OTHERS THEN
1120: ROLLBACK TO getLoanInvoices;

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

1120: ROLLBACK TO getLoanInvoices;
1121: x_return_status := FND_API.G_RET_STS_ERROR;
1122: x_msg_count := l_msg_count;
1123: x_msg_data := l_msg_data;
1124: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1125: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
1126:
1127: end getLoanInvoices;
1128:

Line 1225: FND_MSG_PUB.Add;

1221:
1222: /* verify input data */
1223: if P_CASH_RECEIPT_ID is null then
1224: FND_MESSAGE.SET_NAME('LNS', 'LNS_CR_NOT_SET');
1225: FND_MSG_PUB.Add;
1226: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
1227: RAISE FND_API.G_EXC_ERROR;
1228: end if;
1229:

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

1222: /* verify input data */
1223: if P_CASH_RECEIPT_ID is null then
1224: FND_MESSAGE.SET_NAME('LNS', 'LNS_CR_NOT_SET');
1225: FND_MSG_PUB.Add;
1226: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
1227: RAISE FND_API.G_EXC_ERROR;
1228: end if;
1229:
1230: if P_APPLY_AMOUNT is null or P_APPLY_AMOUNT <= 0 then

Line 1232: FND_MSG_PUB.Add;

1228: end if;
1229:
1230: if P_APPLY_AMOUNT is null or P_APPLY_AMOUNT <= 0 then
1231: FND_MESSAGE.SET_NAME('LNS', 'LNS_AMOUNT_NOT_SET');
1232: FND_MSG_PUB.Add;
1233: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
1234: RAISE FND_API.G_EXC_ERROR;
1235: end if;
1236:

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

1229:
1230: if P_APPLY_AMOUNT is null or P_APPLY_AMOUNT <= 0 then
1231: FND_MESSAGE.SET_NAME('LNS', 'LNS_AMOUNT_NOT_SET');
1232: FND_MSG_PUB.Add;
1233: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
1234: RAISE FND_API.G_EXC_ERROR;
1235: end if;
1236:
1237: /* verifying requested qpply amount */

Line 1243: FND_MSG_PUB.Add;

1239: fetch receipt_cur into l_receipt_rem_amount;
1240:
1241: if receipt_cur%NOTFOUND then
1242: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_CR_FOUND');
1243: FND_MSG_PUB.Add;
1244: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
1245: RAISE FND_API.G_EXC_ERROR;
1246: end if;
1247:

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

1240:
1241: if receipt_cur%NOTFOUND then
1242: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_CR_FOUND');
1243: FND_MSG_PUB.Add;
1244: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
1245: RAISE FND_API.G_EXC_ERROR;
1246: end if;
1247:
1248: close receipt_cur;

Line 1252: FND_MSG_PUB.Add;

1248: close receipt_cur;
1249: /*
1250: if l_receipt_rem_amount < P_APPLY_AMOUNT then
1251: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_CR_FUNDS');
1252: FND_MSG_PUB.Add;
1253: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
1254: RAISE FND_API.G_EXC_ERROR;
1255: end if;
1256: */

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

1249: /*
1250: if l_receipt_rem_amount < P_APPLY_AMOUNT then
1251: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_CR_FUNDS');
1252: FND_MSG_PUB.Add;
1253: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
1254: RAISE FND_API.G_EXC_ERROR;
1255: end if;
1256: */
1257: select

Line 1295: FND_MSG_PUB.Add;

1291: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' msg_data: ' || substr(l_msg_data,1,225));
1292:
1293: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1294: FND_MESSAGE.SET_NAME('LNS', 'LNS_APPL_CR_FAIL');
1295: FND_MSG_PUB.Add;
1296: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
1297: RAISE FND_API.G_EXC_ERROR;
1298: ELSE
1299: null;

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

1292:
1293: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1294: FND_MESSAGE.SET_NAME('LNS', 'LNS_APPL_CR_FAIL');
1295: FND_MSG_PUB.Add;
1296: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
1297: RAISE FND_API.G_EXC_ERROR;
1298: ELSE
1299: null;
1300: --LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'Successfully applied cash receipt to trx ' || P_TRX_ID || ' line ' || P_TRX_LINE_ID);

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

1308: ROLLBACK TO APPLY_RECEIPT;
1309: x_return_status := FND_API.G_RET_STS_ERROR;
1310: x_msg_count := l_msg_count;
1311: x_msg_data := l_msg_data;
1312: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1313: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
1314:
1315: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1316: ROLLBACK TO APPLY_RECEIPT;

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

1316: ROLLBACK TO APPLY_RECEIPT;
1317: x_return_status := FND_API.G_RET_STS_ERROR;
1318: x_msg_count := l_msg_count;
1319: x_msg_data := l_msg_data;
1320: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1321: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
1322:
1323: WHEN OTHERS THEN
1324: ROLLBACK TO APPLY_RECEIPT;

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

1324: ROLLBACK TO APPLY_RECEIPT;
1325: x_return_status := FND_API.G_RET_STS_ERROR;
1326: x_msg_count := l_msg_count;
1327: x_msg_data := l_msg_data;
1328: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1329: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
1330: END;
1331:
1332: /*=========================================================================