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.AR_PREPAYMENTS dependencies on ARP_UTIL

Line 241: arp_util.debug('process_prepayments: ' ||

237: l_actual_refund_amount ar_receivable_applications.amount_applied%TYPE;
238:
239: BEGIN
240: IF PG_DEBUG in ('Y', 'C') THEN
241: arp_util.debug('process_prepayments: ' ||
242: 'ar_prepayments.process prepayment (+)');
243: END IF;
244:
245: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 267: arp_util.debug('process_prepayments: ' ||

263: l_val_return_status
264: );
265:
266: IF PG_DEBUG in ('Y', 'C') THEN
267: arp_util.debug('process_prepayments: ' ||
268: 'Validate Prepaymet amount return status :'||
269: l_val_return_status);
270: END IF;
271:

Line 282: arp_util.debug('process_prepayments: ' ||

278: l_cr_unapp_amount , /* Bug fix 3569640 */
279: l_def_return_status);
280:
281: IF PG_DEBUG in ('Y', 'C') THEN
282: arp_util.debug('process_prepayments: ' ||
283: 'Derive other accounts ids return status : '||
284: l_def_return_status);
285: END IF;
286:

Line 304: arp_util.debug('process_prepayments: '||

300: IF l_rec_in_doubt = 'Y' then
301: l_refund_type:= 'ON_ACCOUNT';
302:
303: IF PG_DEBUG in ('Y', 'C') THEN
304: arp_util.debug('process_prepayments: '||
305: 'Receipt is in doubt with following reason: '|| l_rid_reason);
306:
307: END IF;
308:

Line 318: arp_util.debug('process_prepayments: ' ||

314: 'CCREFUND',
315: l_receivables_trx_id,
316: l_def_activity_return_status);
317: IF PG_DEBUG in ('Y', 'C') THEN
318: arp_util.debug('process_prepayments: ' ||
319: 'Default Refund Activity Return status :'||
320: l_def_activity_return_status);
321: END IF;
322:

Line 328: arp_util.debug('process_prepayments: Refund type ' ||l_refund_type);

324:
325: END IF; ----l_refund_type = CREDIT_CARD
326:
327: IF PG_DEBUG in ('Y', 'C') THEN
328: arp_util.debug('process_prepayments: Refund type ' ||l_refund_type);
329: END IF;
330:
331:
332:

Line 338: arp_util.debug('process_prepayments: ' ||

334: l_def_return_status <> FND_API.G_RET_STS_SUCCESS OR
335: l_def_activity_return_status <> FND_API.G_RET_STS_SUCCESS THEN
336:
337: IF PG_DEBUG in ('Y', 'C') THEN
338: arp_util.debug('process_prepayments: ' ||
339: 'Validation or Defaulting Failed' );
340: END IF;
341: x_return_status := FND_API.G_RET_STS_ERROR ;
342:

Line 356: arp_util.debug('process_prepayments: ' ||

352: -----------------------------------------------------*/
353: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
354:
355: IF PG_DEBUG in ('Y', 'C') THEN
356: arp_util.debug('process_prepayments: ' ||
357: ' Calling ar_receipt_api_pub.Unapply_other_account' );
358: END IF;
359:
360:

Line 377: arp_util.debug('process_prepayments: ' ||

373: p_reversal_gl_date => p_refund_gl_date
374: );
375:
376: IF PG_DEBUG in ('Y', 'C') THEN
377: arp_util.debug('process_prepayments: ' ||
378: 'Unapply Other Account Return status :'||
379: x_return_status);
380: END IF;
381:

Line 394: arp_util.debug('process_prepayments: ' ||

390: IF x_return_status = FND_API.G_RET_STS_SUCCESS AND
391: l_refund_type = 'CREDIT_CARD' THEN
392:
393: IF PG_DEBUG in ('Y', 'C') THEN
394: arp_util.debug('process_prepayments: ' ||
395: ' Calling ar_receipt_api_pub.Activity_Application' );
396: END IF;
397:
398: -- Issue a credit card Refund

Line 431: arp_util.debug('process_prepayments: ' ||

427: p_payment_set_id => l_ra_rec.payment_set_id
428: );
429:
430: IF PG_DEBUG in ('Y', 'C') THEN
431: arp_util.debug('process_prepayments: ' ||
432: 'Acticvity application return status :'||
433: x_return_status);
434:
435: arp_util.debug('process_prepayments: '||

Line 435: arp_util.debug('process_prepayments: '||

431: arp_util.debug('process_prepayments: ' ||
432: 'Acticvity application return status :'||
433: x_return_status);
434:
435: arp_util.debug('process_prepayments: '||
436: ' Receivable App. ID : '||
437: l_receivable_application_id );
438: END IF;
439:

Line 473: arp_util.debug('process_prepayments: ' ||

469: end if;
470:
471:
472: IF PG_DEBUG in ('Y', 'C') THEN
473: arp_util.debug('process_prepayments: ' ||
474: ' Calling ar_receipt_api_pub.Apply_On_Account' );
475: END IF;
476:
477: --put the amount on account

Line 492: arp_util.debug('process_prepayments: ' ||

488: p_secondary_app_ref_num => l_application_ref_num
489: );
490:
491: IF PG_DEBUG in ('Y', 'C') THEN
492: arp_util.debug('process_prepayments: ' ||
493: ' Apply On Account return status: ' || x_return_status );
494: END IF;
495:
496: /*----------------------------------------------------

Line 524: arp_util.debug('process_prepayments: ' ||

520:
521: IF l_reapply_amount > 0 THEN
522:
523: IF PG_DEBUG in ('Y', 'C') THEN
524: arp_util.debug('process_prepayments: ' ||
525: ' Amount to be re-applied back on Prepayment: '||
526: l_reapply_amount );
527: END IF;
528:

Line 632: arp_util.debug('process_prepayments: ' ||

628: p_comments => l_ra_rec.comments
629: );
630:
631: IF PG_DEBUG in ('Y', 'C') THEN
632: arp_util.debug('process_prepayments: ' ||
633: 'Prepay Application ID :'||
634: p_prepay_application_id);
635: arp_util.debug('process_prepayments: ' ||
636: 'Other account application return status :'||

Line 635: arp_util.debug('process_prepayments: ' ||

631: IF PG_DEBUG in ('Y', 'C') THEN
632: arp_util.debug('process_prepayments: ' ||
633: 'Prepay Application ID :'||
634: p_prepay_application_id);
635: arp_util.debug('process_prepayments: ' ||
636: 'Other account application return status :'||
637: x_return_status);
638: END IF;
639:

Line 661: arp_util.debug('process_prepayments: ' || 'ar_prepayments.process prepayment (-)');

657: RETURN;
658: END IF;
659:
660: IF PG_DEBUG in ('Y', 'C') THEN
661: arp_util.debug('process_prepayments: ' || 'ar_prepayments.process prepayment (-)');
662: END IF;
663:
664: EXCEPTION
665:

Line 673: arp_util.debug('EXCEPTION :ar_prepayments.process_prepayments :'||SQLERRM);

669: p_count => x_msg_count,
670: p_data => x_msg_data);
671:
672: IF PG_DEBUG in ('Y', 'C') THEN
673: arp_util.debug('EXCEPTION :ar_prepayments.process_prepayments :'||SQLERRM);
674: END IF;
675:
676: END Process_Prepayments;
677:

Line 838: arp_util.debug('Create_Prepayment: payment_trxn_extension_id' || to_char(p_payment_trxn_extension_id) );

834: l_receipt_number := p_receipt_number;
835:
836: IF PG_DEBUG in ('Y', 'C') THEN
837: arp_standard.debug('ar_prepayments.Create_Prepayment ()+'|| p_org_id);
838: arp_util.debug('Create_Prepayment: payment_trxn_extension_id' || to_char(p_payment_trxn_extension_id) );
839: END IF;
840:
841:
842: ----Call the AR_PREPAYMENTS_PUB.Create_Prepayment API----

Line 936: arp_util.debug('AR_PREPAYMENTS.Create_Prepayment ()-');

932: p_count => x_msg_count,
933: p_data => x_msg_data);
934:
935: IF PG_DEBUG in ('Y', 'C') THEN
936: arp_util.debug('AR_PREPAYMENTS.Create_Prepayment ()-');
937: END IF;
938:
939:
940: END IF; /* SSA changes */

Line 945: arp_util.debug('EXCEPTION : ar_prepayment.create_prepayment ||SQLERRM');

941:
942: EXCEPTION
943: WHEN others THEN
944: IF PG_DEBUG in ('Y', 'C') THEN
945: arp_util.debug('EXCEPTION : ar_prepayment.create_prepayment ||SQLERRM');
946: END IF;
947: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
948:
949: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 1034: arp_util.debug('ar_prepayment.refund_prepayments (+)');

1030: l_max_refund_amt NUMBER := 0;
1031: l_dummy number := null;
1032: BEGIN
1033: IF PG_DEBUG in ('Y', 'C') THEN
1034: arp_util.debug('ar_prepayment.refund_prepayments (+)');
1035: END IF;
1036:
1037: /*------------------------------------+
1038: | Standard start of API savepoint |

Line 1074: arp_util.debug('Refund_Prepayments: ' || 'Activity_application()+ ');

1070: FND_MSG_PUB.initialize;
1071: END IF;
1072:
1073: IF PG_DEBUG in ('Y', 'C') THEN
1074: arp_util.debug('Refund_Prepayments: ' || 'Activity_application()+ ');
1075: END IF;
1076:
1077:
1078: /*-------------------------------------------------+

Line 1118: arp_util.debug('refund_prepayments: ' || 'Validation or Defaulting Failed' ) ;

1114: IF l_receipt_id_def_status <> FND_API.G_RET_STS_SUCCESS OR
1115: l_cash_receipt_id is NULL THEN
1116:
1117: IF PG_DEBUG in ('Y', 'C') THEN
1118: arp_util.debug('refund_prepayments: ' || 'Validation or Defaulting Failed' ) ;
1119: END IF;
1120:
1121: x_return_status := FND_API.G_RET_STS_ERROR;
1122: RAISE FND_API.G_EXC_ERROR;

Line 1133: arp_util.debug('refund_prepayments: refund using cash_receipt_id: '

1129: -------------------------------------------------------------
1130: IF l_cash_receipt_id is not null then
1131:
1132: IF PG_DEBUG in ('Y', 'C') THEN
1133: arp_util.debug('refund_prepayments: refund using cash_receipt_id: '
1134: || l_cash_receipt_id ) ;
1135: END IF;
1136:
1137: BEGIN

Line 1172: arp_util.debug('refund_prepayments: Refund type : ' ||

1168: l_refund_type := 'CREDIT_CARD';
1169: end if;
1170:
1171: IF PG_DEBUG in ('Y', 'C') THEN
1172: arp_util.debug('refund_prepayments: Refund type : ' ||
1173: l_refund_type);
1174: END IF;
1175:
1176: EXCEPTION

Line 1189: arp_util.debug('refund_prepayments: Calling process_prepayments');

1185: RAISE;
1186: END;
1187:
1188: IF PG_DEBUG in ('Y', 'C') THEN
1189: arp_util.debug('refund_prepayments: Calling process_prepayments');
1190: END IF;
1191:
1192: --call process prepayment
1193: process_prepayments(

Line 1219: arp_util.debug('refund_prepayments: process_prepayments ' ||

1215: );
1216:
1217:
1218: IF PG_DEBUG in ('Y', 'C') THEN
1219: arp_util.debug('refund_prepayments: process_prepayments ' ||
1220: ' return status: '|| x_return_status );
1221: END IF;
1222:
1223: ELSE ---if refund is via payment_set_id

Line 1231: arp_util.debug('refund_prepayments: refund using payment_set_id: ' ||

1227: --receipt_method to a particular credit card bank
1228: IF l_payment_set_id is not null THEN
1229:
1230: IF PG_DEBUG in ('Y', 'C') THEN
1231: arp_util.debug('refund_prepayments: refund using payment_set_id: ' ||
1232: l_payment_set_id ) ;
1233: END IF;
1234:
1235: /*--------------------------------------

Line 1257: arp_util.debug('refund_prepayments: ' ||

1253: if G_REFUND_BANK_ACCOUNT_ID is not NULL then
1254: t_bank_account_id := G_REFUND_BANK_ACCOUNT_ID;
1255:
1256: if PG_DEBUG in ('Y', 'C') THEN
1257: arp_util.debug('refund_prepayments: ' ||
1258: 'refund to the bank account id: ' ||
1259: t_bank_account_id ) ;
1260: end if;
1261:

Line 1286: arp_util.debug('refund_prepayments: '||

1282: if G_REFUND_RECEIPT_METHOD_ID is not null then
1283: t_receipt_method_id := G_REFUND_RECEIPT_METHOD_ID;
1284:
1285: if PG_DEBUG in ('Y', 'C') THEN
1286: arp_util.debug('refund_prepayments: '||
1287: ' refund for the receipt method : ' ||
1288: t_receipt_method_id ) ;
1289: end if;
1290:

Line 1336: arp_util.debug('refund_prepayments: refund amount : ' ||

1332: RETURN;
1333: end if;
1334:
1335: if PG_DEBUG in ('Y', 'C') THEN
1336: arp_util.debug('refund_prepayments: refund amount : ' ||
1337: l_refund_amount);
1338: end if;
1339:
1340:

Line 1363: arp_util.debug('Refund_Prepayments: ' || 'Could not find payment type()+ ');

1359: ----- If there are no payment types-------
1360: IF l_total_pmt_types = 0 THEN
1361:
1362: IF PG_DEBUG in ('Y', 'C') THEN
1363: arp_util.debug('Refund_Prepayments: ' || 'Could not find payment type()+ ');
1364: END IF;
1365: x_return_status := FND_API.G_RET_STS_ERROR;
1366: RETURN;
1367:

Line 1375: arp_util.debug('Refund_Prepayments: '||'One Payment type '||

1371:
1372: l_refund_type := 'CREDIT_CARD';
1373:
1374: if PG_DEBUG in ('Y', 'C') THEN
1375: arp_util.debug('Refund_Prepayments: '||'One Payment type '||
1376: ' Refund: '|| l_refund_type);
1377: end if;
1378:
1379: ELSE --- Greater than 1 payment types

Line 1383: arp_util.debug('Refund_Prepayments: ' || 'Many Payment types '||

1379: ELSE --- Greater than 1 payment types
1380: l_refund_type := 'ON_ACCOUNT'; -- No CC Applications
1381:
1382: if PG_DEBUG in ('Y', 'C') THEN
1383: arp_util.debug('Refund_Prepayments: ' || 'Many Payment types '||
1384: ' Refund: '|| l_refund_type);
1385: end if;
1386:
1387: END IF; -- total_pmt_types

Line 1404: arp_util.debug('Refund_Prepayments: ' ||

1400: l_rcpt_refund_amount := prepay_rcpt_rec.prepayment_amount;
1401: END IF;
1402:
1403: if PG_DEBUG in ('Y', 'C') THEN
1404: arp_util.debug('Refund_Prepayments: ' ||
1405: ' Calling process_prepayments' ||
1406: ' For Receipt ID: '|| l_cash_receipt_id ||
1407: ' To issue Refund of type '|| l_refund_type ||
1408: 'For Amount: '|| l_rcpt_refund_amount);

Line 1441: arp_util.debug('Refund_Prepayments: ' || 'Receivable App ID : '||p_prepay_application_id);

1437: p_prepay_application_id => p_prepay_application_id
1438: );
1439:
1440: IF PG_DEBUG in ('Y', 'C') THEN
1441: arp_util.debug('Refund_Prepayments: ' || 'Receivable App ID : '||p_prepay_application_id);
1442: arp_util.debug('Refund_Prepayments: ' || 'Process Payments status : '||x_return_status);
1443: END IF;
1444:
1445: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 1442: arp_util.debug('Refund_Prepayments: ' || 'Process Payments status : '||x_return_status);

1438: );
1439:
1440: IF PG_DEBUG in ('Y', 'C') THEN
1441: arp_util.debug('Refund_Prepayments: ' || 'Receivable App ID : '||p_prepay_application_id);
1442: arp_util.debug('Refund_Prepayments: ' || 'Process Payments status : '||x_return_status);
1443: END IF;
1444:
1445: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1446: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1462: arp_util.debug('Refund_Prepayments: ' || 'Process Payments status : '||x_return_status);

1458:
1459: END IF; ---payment_set_id not null
1460:
1461: IF PG_DEBUG in ('Y', 'C') THEN
1462: arp_util.debug('Refund_Prepayments: ' || 'Process Payments status : '||x_return_status);
1463: END IF;
1464:
1465: l_number_of_refund_receipts := 1;
1466:

Line 1491: arp_util.debug('Refund_Prepayments: ' || 'committing');

1487:
1488: IF FND_API.To_Boolean( p_commit )
1489: THEN
1490: IF PG_DEBUG in ('Y', 'C') THEN
1491: arp_util.debug('Refund_Prepayments: ' || 'committing');
1492: END IF;
1493: Commit;
1494: END IF;
1495:

Line 1501: arp_util.debug('ar_prepayments.refund_prepayments(-)');

1497: p_count => x_msg_count,
1498: p_data => x_msg_data);
1499:
1500: IF PG_DEBUG in ('Y', 'C') THEN
1501: arp_util.debug('ar_prepayments.refund_prepayments(-)');
1502: END IF;
1503:
1504:
1505: EXCEPTION

Line 1510: arp_util.debug( SQLCODE, G_MSG_ERROR);

1506:
1507: WHEN FND_API.G_EXC_ERROR THEN
1508:
1509: IF PG_DEBUG in ('Y', 'C') THEN
1510: arp_util.debug( SQLCODE, G_MSG_ERROR);
1511: arp_util.debug( SQLERRM, G_MSG_ERROR);
1512: END IF;
1513:
1514: ROLLBACK TO refund_prepay_PVT;

Line 1511: arp_util.debug( SQLERRM, G_MSG_ERROR);

1507: WHEN FND_API.G_EXC_ERROR THEN
1508:
1509: IF PG_DEBUG in ('Y', 'C') THEN
1510: arp_util.debug( SQLCODE, G_MSG_ERROR);
1511: arp_util.debug( SQLERRM, G_MSG_ERROR);
1512: END IF;
1513:
1514: ROLLBACK TO refund_prepay_PVT;
1515: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 1551: arp_util.debug('Refund_Prepayment: ' || SQLCODE, G_MSG_ERROR);

1547: FND_MSG_PUB.Add;
1548: END IF;
1549:
1550: IF PG_DEBUG in ('Y', 'C') THEN
1551: arp_util.debug('Refund_Prepayment: ' || SQLCODE, G_MSG_ERROR);
1552: arp_util.debug('Refund_Prepayment: ' || SQLERRM, G_MSG_ERROR);
1553: END IF;
1554:
1555: ROLLBACK TO refund_prepay_PVT;

Line 1552: arp_util.debug('Refund_Prepayment: ' || SQLERRM, G_MSG_ERROR);

1548: END IF;
1549:
1550: IF PG_DEBUG in ('Y', 'C') THEN
1551: arp_util.debug('Refund_Prepayment: ' || SQLCODE, G_MSG_ERROR);
1552: arp_util.debug('Refund_Prepayment: ' || SQLERRM, G_MSG_ERROR);
1553: END IF;
1554:
1555: ROLLBACK TO refund_prepay_PVT;
1556:

Line 1615: arp_util.debug('ar_prepayments.match_prepayment (+)');

1611: BEGIN
1612: SAVEPOINT match_prepayment_PVT;
1613:
1614: IF PG_DEBUG in ('Y', 'C') THEN
1615: arp_util.debug('ar_prepayments.match_prepayment (+)');
1616: END IF;
1617: x_return_status := FND_API.G_RET_STS_SUCCESS;
1618: l_payment_schedule_id := p_payment_schedule_id;
1619:

Line 1632: arp_util.debug('ar_prepayments.match_prepayment No prepayment exists');

1628:
1629: EXCEPTION
1630: WHEN no_data_found THEN
1631: IF PG_DEBUG in ('Y', 'C') THEN
1632: arp_util.debug('ar_prepayments.match_prepayment No prepayment exists');
1633: END IF;
1634: x_return_status := FND_API.G_RET_STS_SUCCESS;
1635: RETURN;
1636: WHEN others THEN

Line 1638: arp_util.debug('EXCEPTION :ar_prepayments.match_prepayment Check ');

1634: x_return_status := FND_API.G_RET_STS_SUCCESS;
1635: RETURN;
1636: WHEN others THEN
1637: IF PG_DEBUG in ('Y', 'C') THEN
1638: arp_util.debug('EXCEPTION :ar_prepayments.match_prepayment Check ');
1639: END IF;
1640: x_return_status := FND_API.G_RET_STS_ERROR;
1641: RETURN;
1642: END;

Line 1667: arp_util.debug('match_prepayment: ' || 'unapply_other_account retun status : '||l_return_status);

1663: p_reversal_gl_date => p_apply_gl_date
1664: );
1665:
1666: IF PG_DEBUG in ('Y', 'C') THEN
1667: arp_util.debug('match_prepayment: ' || 'unapply_other_account retun status : '||l_return_status);
1668: END IF;
1669: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1670: x_return_status := FND_API.G_RET_STS_ERROR;
1671: EXIT;

Line 1702: arp_util.debug('match_prepayment: ' || 'Apply retun status : '||l_return_status);

1698:
1699: l_ps_rec.amount_due_remaining := (l_ps_rec.amount_due_remaining - l_amount_applied);
1700:
1701: IF PG_DEBUG in ('Y', 'C') THEN
1702: arp_util.debug('match_prepayment: ' || 'Apply retun status : '||l_return_status);
1703: END IF;
1704:
1705: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1706: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1777: arp_util.debug('match_prepayment: ' || 'apply_other_account retun status : '||l_return_status);

1773: p_global_attribute_rec => l_global_attribute_rec
1774: );
1775:
1776: IF PG_DEBUG in ('Y', 'C') THEN
1777: arp_util.debug('match_prepayment: ' || 'apply_other_account retun status : '||l_return_status);
1778: END IF;
1779:
1780: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1781: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1815: arp_util.debug('match_prepayment: ' || l_msg_data);

1811: ROLLBACK to match_prepayment_PVT;
1812: IF NVL(l_msg_count,0) > 0 Then
1813: IF l_msg_count = 1 Then
1814: IF PG_DEBUG in ('Y', 'C') THEN
1815: arp_util.debug('match_prepayment: ' || l_msg_data);
1816: END IF;
1817:
1818: ELSIF l_msg_count > 1 Then
1819: FOR l_count IN 1..l_msg_count LOOP

Line 1823: arp_util.debug('match_prepayment: ' || to_char(l_count)||' : '||l_msg_data);

1819: FOR l_count IN 1..l_msg_count LOOP
1820:
1821: l_msg_data := FND_MSG_PUB.Get(FND_MSG_PUB.G_NEXT,FND_API.G_FALSE);
1822: IF PG_DEBUG in ('Y', 'C') THEN
1823: arp_util.debug('match_prepayment: ' || to_char(l_count)||' : '||l_msg_data);
1824: END IF;
1825: END LOOP;
1826:
1827: END IF; -- l_msg_count

Line 1834: arp_util.debug('ar_prepayments.match_prepayment (-)');

1830: x_return_status := FND_API.G_RET_STS_SUCCESS;
1831: END IF;
1832:
1833: IF PG_DEBUG in ('Y', 'C') THEN
1834: arp_util.debug('ar_prepayments.match_prepayment (-)');
1835: END IF;
1836:
1837: EXCEPTION
1838: WHEN others THEN

Line 1840: arp_util.debug('EXCEPTION : ar_prepayments.match_prepayment ||SQLERRM');

1836:
1837: EXCEPTION
1838: WHEN others THEN
1839: IF PG_DEBUG in ('Y', 'C') THEN
1840: arp_util.debug('EXCEPTION : ar_prepayments.match_prepayment ||SQLERRM');
1841: END IF;
1842: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1843: END match_prepayment;
1844:

Line 1894: arp_util.CurrRound( (relative_amount/base_amount ) * l_amount ,

1890: --on the functional currency
1891: CURSOR get_installment_amount (l_term_id IN NUMBER, l_amount IN NUMBER ,
1892: l_currency_code IN VARCHAR2) IS
1893: select sequence_num as installment_number,
1894: arp_util.CurrRound( (relative_amount/base_amount ) * l_amount ,
1895: l_currency_code) as installment_amount
1896: from ra_terms t , ra_terms_lines tl
1897: where t.term_id = tl.term_id
1898: and t.term_id = l_term_id;

Line 1903: arp_util.debug('ar_prepayment.get_installment (+)');

1899:
1900: BEGIN
1901:
1902: IF PG_DEBUG in ('Y', 'C') THEN
1903: arp_util.debug('ar_prepayment.get_installment (+)');
1904: END IF;
1905:
1906: ---- first reinitialize ARP_GLOBAL
1907: arp_global.init_global;

Line 1977: arp_util.debug('ar_prepayment.get_installment (-)');

1973: end loop;
1974: close get_installment_amount;
1975:
1976: IF PG_DEBUG in ('Y', 'C') THEN
1977: arp_util.debug('ar_prepayment.get_installment (-)');
1978: END IF;
1979:
1980: EXCEPTION
1981: WHEN fnd_api.g_exc_error THEN

Line 2048: arp_util.debug('The rule_select_prepayments Subscription to AutoInvoice ''');

2044: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
2045:
2046:
2047: IF PG_DEBUG in ('Y', 'C') THEN
2048: arp_util.debug('The rule_select_prepayments Subscription to AutoInvoice ''');
2049: arp_util.debug('Start Time ' || TO_CHAR(SYSDATE, 'MM-DD-YY HH24:MI:SS'));
2050: END IF;
2051:
2052:

Line 2049: arp_util.debug('Start Time ' || TO_CHAR(SYSDATE, 'MM-DD-YY HH24:MI:SS'));

2045:
2046:
2047: IF PG_DEBUG in ('Y', 'C') THEN
2048: arp_util.debug('The rule_select_prepayments Subscription to AutoInvoice ''');
2049: arp_util.debug('Start Time ' || TO_CHAR(SYSDATE, 'MM-DD-YY HH24:MI:SS'));
2050: END IF;
2051:
2052:
2053: ---get the parameter request_id

Line 2200: arp_util.debug('AR-ARZPREPAY-bef: Payment Schedule Id '||

2196: ---Ajay, since there is no report exposing what happened? should be have them
2197: ---as regular log messages as fnd_file.put_line or this?
2198:
2199: IF PG_DEBUG in ('Y', 'C') THEN
2200: arp_util.debug('AR-ARZPREPAY-bef: Payment Schedule Id '||
2201: l_payment_schedule_id);
2202: arp_util.debug('AR-ARZPREPAY-bef: PS Amt Due Remaining' ||
2203: l_amt_due_remaining);
2204: END IF;

Line 2202: arp_util.debug('AR-ARZPREPAY-bef: PS Amt Due Remaining' ||

2198:
2199: IF PG_DEBUG in ('Y', 'C') THEN
2200: arp_util.debug('AR-ARZPREPAY-bef: Payment Schedule Id '||
2201: l_payment_schedule_id);
2202: arp_util.debug('AR-ARZPREPAY-bef: PS Amt Due Remaining' ||
2203: l_amt_due_remaining);
2204: END IF;
2205:
2206: /*-------------------------------------------------------------------------+

Line 2210: arp_util.debug('Starting ar_prepayments.match_prepayment Routine(+) ');

2206: /*-------------------------------------------------------------------------+
2207: |Call the match prepay routine
2208: +-------------------------------------------------------------------------*/
2209: IF PG_DEBUG in ('Y', 'C') THEN
2210: arp_util.debug('Starting ar_prepayments.match_prepayment Routine(+) ');
2211: END IF;
2212:
2213: begin
2214: SAVEPOINT match_start;

Line 2230: arp_util.debug('ar_prepayments.match_prepayment-after: P Cash Receipt Id >' || l_cash_receipt_id);

2226: l_retcode := 10;
2227: END IF;
2228:
2229: IF PG_DEBUG in ('Y', 'C') then
2230: arp_util.debug('ar_prepayments.match_prepayment-after: P Cash Receipt Id >' || l_cash_receipt_id);
2231: arp_util.debug('AR-ARZPREPAY-after: PS Amt Due Remaining>'
2232: || l_ps_amt_due_remain);
2233: END IF;
2234:

Line 2231: arp_util.debug('AR-ARZPREPAY-after: PS Amt Due Remaining>'

2227: END IF;
2228:
2229: IF PG_DEBUG in ('Y', 'C') then
2230: arp_util.debug('ar_prepayments.match_prepayment-after: P Cash Receipt Id >' || l_cash_receipt_id);
2231: arp_util.debug('AR-ARZPREPAY-after: PS Amt Due Remaining>'
2232: || l_ps_amt_due_remain);
2233: END IF;
2234:
2235:

Line 2255: arp_util.debug('End ar_prepayments.match_prepayment Routine (-)');

2251:
2252: END LOOP;
2253: close get_prepay_invoices;
2254: IF PG_DEBUG in ('Y', 'C') THEN
2255: arp_util.debug('End ar_prepayments.match_prepayment Routine (-)');
2256: END IF;
2257:
2258: if (l_retcode <> 0) then
2259: RAISE FND_API.G_EXC_ERROR;