DBA Data[Home] [Help]

APPS.AR_PREPAYMENTS dependencies on FND_FILE

Line 1672: FND_FILE.put_line(fnd_file.log,'Prepayment is not getting unapplied Cash Receipt ID : ' || prepayapp_rec.cash_receipt_id);

1668: IF PG_DEBUG in ('Y', 'C') THEN
1669: arp_util.debug('match_prepayment: ' || 'unapply_other_account retun status : '||l_return_status);
1670: END IF;
1671: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1672: FND_FILE.put_line(fnd_file.log,'Prepayment is not getting unapplied Cash Receipt ID : ' || prepayapp_rec.cash_receipt_id);
1673: x_return_status := FND_API.G_RET_STS_ERROR;
1674: EXIT;
1675: END IF;
1676:

Line 1721: FND_FILE.put_line(fnd_file.log,'Prepayment is not getting applied to Invoice ');

1717: END IF;
1718:
1719: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1720: x_return_status := FND_API.G_RET_STS_ERROR;
1721: FND_FILE.put_line(fnd_file.log,'Prepayment is not getting applied to Invoice ');
1722: FND_FILE.put_line(fnd_file.log,'Cash receipt ID : ' || prepayapp_rec.cash_receipt_id);
1723: FND_FILE.put_line(fnd_file.log,'Customer Trx ID : ' || l_ps_rec.customer_trx_id);
1724: FND_FILE.put_line(fnd_file.log,'Payment Schedule ID: ' || l_ps_rec.payment_schedule_id);
1725: FND_FILE.put_line(fnd_file.log,'Transaction Number: ' || l_ps_rec.trx_number);

Line 1722: FND_FILE.put_line(fnd_file.log,'Cash receipt ID : ' || prepayapp_rec.cash_receipt_id);

1718:
1719: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1720: x_return_status := FND_API.G_RET_STS_ERROR;
1721: FND_FILE.put_line(fnd_file.log,'Prepayment is not getting applied to Invoice ');
1722: FND_FILE.put_line(fnd_file.log,'Cash receipt ID : ' || prepayapp_rec.cash_receipt_id);
1723: FND_FILE.put_line(fnd_file.log,'Customer Trx ID : ' || l_ps_rec.customer_trx_id);
1724: FND_FILE.put_line(fnd_file.log,'Payment Schedule ID: ' || l_ps_rec.payment_schedule_id);
1725: FND_FILE.put_line(fnd_file.log,'Transaction Number: ' || l_ps_rec.trx_number);
1726: FND_FILE.put_line(fnd_file.log,'Payment Set ID: ' || prepayapp_rec.payment_set_id);

Line 1723: FND_FILE.put_line(fnd_file.log,'Customer Trx ID : ' || l_ps_rec.customer_trx_id);

1719: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1720: x_return_status := FND_API.G_RET_STS_ERROR;
1721: FND_FILE.put_line(fnd_file.log,'Prepayment is not getting applied to Invoice ');
1722: FND_FILE.put_line(fnd_file.log,'Cash receipt ID : ' || prepayapp_rec.cash_receipt_id);
1723: FND_FILE.put_line(fnd_file.log,'Customer Trx ID : ' || l_ps_rec.customer_trx_id);
1724: FND_FILE.put_line(fnd_file.log,'Payment Schedule ID: ' || l_ps_rec.payment_schedule_id);
1725: FND_FILE.put_line(fnd_file.log,'Transaction Number: ' || l_ps_rec.trx_number);
1726: FND_FILE.put_line(fnd_file.log,'Payment Set ID: ' || prepayapp_rec.payment_set_id);
1727: END IF;

Line 1724: FND_FILE.put_line(fnd_file.log,'Payment Schedule ID: ' || l_ps_rec.payment_schedule_id);

1720: x_return_status := FND_API.G_RET_STS_ERROR;
1721: FND_FILE.put_line(fnd_file.log,'Prepayment is not getting applied to Invoice ');
1722: FND_FILE.put_line(fnd_file.log,'Cash receipt ID : ' || prepayapp_rec.cash_receipt_id);
1723: FND_FILE.put_line(fnd_file.log,'Customer Trx ID : ' || l_ps_rec.customer_trx_id);
1724: FND_FILE.put_line(fnd_file.log,'Payment Schedule ID: ' || l_ps_rec.payment_schedule_id);
1725: FND_FILE.put_line(fnd_file.log,'Transaction Number: ' || l_ps_rec.trx_number);
1726: FND_FILE.put_line(fnd_file.log,'Payment Set ID: ' || prepayapp_rec.payment_set_id);
1727: END IF;
1728:

Line 1725: FND_FILE.put_line(fnd_file.log,'Transaction Number: ' || l_ps_rec.trx_number);

1721: FND_FILE.put_line(fnd_file.log,'Prepayment is not getting applied to Invoice ');
1722: FND_FILE.put_line(fnd_file.log,'Cash receipt ID : ' || prepayapp_rec.cash_receipt_id);
1723: FND_FILE.put_line(fnd_file.log,'Customer Trx ID : ' || l_ps_rec.customer_trx_id);
1724: FND_FILE.put_line(fnd_file.log,'Payment Schedule ID: ' || l_ps_rec.payment_schedule_id);
1725: FND_FILE.put_line(fnd_file.log,'Transaction Number: ' || l_ps_rec.trx_number);
1726: FND_FILE.put_line(fnd_file.log,'Payment Set ID: ' || prepayapp_rec.payment_set_id);
1727: END IF;
1728:
1729: --Apply rest of the amount back to prepayment

Line 1726: FND_FILE.put_line(fnd_file.log,'Payment Set ID: ' || prepayapp_rec.payment_set_id);

1722: FND_FILE.put_line(fnd_file.log,'Cash receipt ID : ' || prepayapp_rec.cash_receipt_id);
1723: FND_FILE.put_line(fnd_file.log,'Customer Trx ID : ' || l_ps_rec.customer_trx_id);
1724: FND_FILE.put_line(fnd_file.log,'Payment Schedule ID: ' || l_ps_rec.payment_schedule_id);
1725: FND_FILE.put_line(fnd_file.log,'Transaction Number: ' || l_ps_rec.trx_number);
1726: FND_FILE.put_line(fnd_file.log,'Payment Set ID: ' || prepayapp_rec.payment_set_id);
1727: END IF;
1728:
1729: --Apply rest of the amount back to prepayment
1730: IF (l_prepay_amount_reapplied > 0) AND (x_return_status <> FND_API.G_RET_STS_ERROR) THEN

Line 1802: FND_FILE.put_line(fnd_file.log,'Leftover amount is not getting applied back to Prepayment ');

1798: END IF;
1799:
1800: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1801: x_return_status := FND_API.G_RET_STS_ERROR;
1802: FND_FILE.put_line(fnd_file.log,'Leftover amount is not getting applied back to Prepayment ');
1803: FND_FILE.put_line(fnd_file.log,'Cash receipt ID : ' || prepayapp_rec.cash_receipt_id);
1804: FND_FILE.put_line(fnd_file.log,'Payment Set ID: ' || prepayapp_rec.payment_set_id);
1805: END IF;
1806:

Line 1803: FND_FILE.put_line(fnd_file.log,'Cash receipt ID : ' || prepayapp_rec.cash_receipt_id);

1799:
1800: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1801: x_return_status := FND_API.G_RET_STS_ERROR;
1802: FND_FILE.put_line(fnd_file.log,'Leftover amount is not getting applied back to Prepayment ');
1803: FND_FILE.put_line(fnd_file.log,'Cash receipt ID : ' || prepayapp_rec.cash_receipt_id);
1804: FND_FILE.put_line(fnd_file.log,'Payment Set ID: ' || prepayapp_rec.payment_set_id);
1805: END IF;
1806:
1807: END IF;

Line 1804: FND_FILE.put_line(fnd_file.log,'Payment Set ID: ' || prepayapp_rec.payment_set_id);

1800: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1801: x_return_status := FND_API.G_RET_STS_ERROR;
1802: FND_FILE.put_line(fnd_file.log,'Leftover amount is not getting applied back to Prepayment ');
1803: FND_FILE.put_line(fnd_file.log,'Cash receipt ID : ' || prepayapp_rec.cash_receipt_id);
1804: FND_FILE.put_line(fnd_file.log,'Payment Set ID: ' || prepayapp_rec.payment_set_id);
1805: END IF;
1806:
1807: END IF;
1808:

Line 2100: FND_FILE.put_line(fnd_file.log, 'Request id is ' || l_request_id);

2096:
2097: END IF;
2098:
2099: IF PG_DEBUG in ('Y', 'C') THEN
2100: FND_FILE.put_line(fnd_file.log, 'Request id is ' || l_request_id);
2101: arp_util.debug('Request id is' || l_request_id);
2102:
2103: FND_FILE.put_line(fnd_file.log, 'ORGANISATION ID is ' || l_org_id);
2104: arp_util.debug('ORG id is' || l_org_id);

Line 2103: FND_FILE.put_line(fnd_file.log, 'ORGANISATION ID is ' || l_org_id);

2099: IF PG_DEBUG in ('Y', 'C') THEN
2100: FND_FILE.put_line(fnd_file.log, 'Request id is ' || l_request_id);
2101: arp_util.debug('Request id is' || l_request_id);
2102:
2103: FND_FILE.put_line(fnd_file.log, 'ORGANISATION ID is ' || l_org_id);
2104: arp_util.debug('ORG id is' || l_org_id);
2105: END IF;
2106:
2107: IF l_request_id <> 0 AND l_request_id is not null THEN

Line 2226: FND_FILE.put_line(fnd_file.log,'Starting Concurrent Program ''Prepayment Matching ''');

2222: BEGIN
2223:
2224: -- Initialize message stack
2225: FND_MSG_PUB.initialize;
2226: FND_FILE.put_line(fnd_file.log,'Starting Concurrent Program ''Prepayment Matching ''');
2227: FND_FILE.put_line(fnd_file.log,'Start Time ' || TO_CHAR(SYSDATE, 'MM-DD-YY HH24:MI:SS' ));
2228:
2229: ---get the parameter request_id
2230: l_request_id := p_request_id;

Line 2227: FND_FILE.put_line(fnd_file.log,'Start Time ' || TO_CHAR(SYSDATE, 'MM-DD-YY HH24:MI:SS' ));

2223:
2224: -- Initialize message stack
2225: FND_MSG_PUB.initialize;
2226: FND_FILE.put_line(fnd_file.log,'Starting Concurrent Program ''Prepayment Matching ''');
2227: FND_FILE.put_line(fnd_file.log,'Start Time ' || TO_CHAR(SYSDATE, 'MM-DD-YY HH24:MI:SS' ));
2228:
2229: ---get the parameter request_id
2230: l_request_id := p_request_id;
2231:

Line 2289: ---as regular log messages as fnd_file.put_line or this?

2285: l_amt_due_remaining,l_ps_due_date; --Bug7194951
2286: EXIT when get_prepay_invoices%NOTFOUND;
2287:
2288: ---Ajay, since there is no report exposing what happened? should be have them
2289: ---as regular log messages as fnd_file.put_line or this?
2290:
2291: IF PG_DEBUG in ('Y', 'C') THEN
2292: arp_util.debug('AR-ARZPREPAY-bef: Payment Schedule Id '||
2293: l_payment_schedule_id);

Line 2334: fnd_file.put_line(fnd_file.log,'EXCEPTION :AR_PREPAYMENTS_PUB.MATCH_PREPAYMENT Routine'||SQLERRM);

2330:
2331: EXCEPTION
2332:
2333: WHEN others THEN
2334: fnd_file.put_line(fnd_file.log,'EXCEPTION :AR_PREPAYMENTS_PUB.MATCH_PREPAYMENT Routine'||SQLERRM);
2335: l_retcode := 10;
2336: ROLLBACK to match_start;
2337:
2338: end; ---end to call to match_prepayment

Line 2342: fnd_file.put_line(fnd_file.log,' Payment Schedule Id '|| l_payment_schedule_id);

2338: end; ---end to call to match_prepayment
2339:
2340:
2341: if (l_ps_amt_due_remain = -1) then
2342: fnd_file.put_line(fnd_file.log,' Payment Schedule Id '|| l_payment_schedule_id);
2343: end if;
2344:
2345:
2346: END LOOP;

Line 2355: FND_FILE.put_line(fnd_file.log,'There are few prepayments which could not match. Pl check log file for details');

2351: arp_util.debug('End ar_prepayments.match_prepayment Routine (-)');
2352: END IF;
2353:
2354: if (l_retcode <> 0) then
2355: FND_FILE.put_line(fnd_file.log,'There are few prepayments which could not match. Pl check log file for details');
2356: lb_request_status := FND_CONCURRENT.set_completion_status('WARNING', '');
2357: -- RAISE FND_API.G_EXC_ERROR;
2358: end if;
2359:

Line 2372: fnd_file.put_line(fnd_file.log, l_msg_data);

2368: substr(l_msg_data || ' ' || FND_MSG_PUB.Get(p_encoded =>
2369: FND_API.G_FALSE ), 1,255);
2370: END LOOP;
2371:
2372: fnd_file.put_line(fnd_file.log, l_msg_data);
2373: FND_MSG_PUB.Delete_Msg;
2374: retcode := l_retcode;
2375:
2376: END select_prepayments;