DBA Data[Home] [Help]

APPS.JL_AR_RECEIVABLE_APPLICATIONS dependencies on AR_RECEIVABLE_APPLICATIONS

Line 1: PACKAGE BODY jl_ar_receivable_applications AS

1: PACKAGE BODY jl_ar_receivable_applications AS
2: /* $Header: jlbrrrab.pls 120.19 2006/12/15 22:51:47 appradha ship $ */
3:
4: /*----------------------------------------------------------------------------*
5: | PRIVATE FUNCTIONS/PROCEDURES |

Line 745: arp_util.debug('jl_ar_receivable_applications.Apply_br()+');

741:
742: BEGIN
743:
744: IF PG_DEBUG in ('Y', 'C') THEN
745: arp_util.debug('jl_ar_receivable_applications.Apply_br()+');
746: END IF;
747:
748: p_return_status := FND_API.G_RET_STS_SUCCESS;
749:

Line 1012: arp_util.debug('jl_ar_receivable_applications.Apply_br()-');

1008:
1009: END IF;
1010:
1011: IF PG_DEBUG in ('Y', 'C') THEN
1012: arp_util.debug('jl_ar_receivable_applications.Apply_br()-');
1013: END IF;
1014:
1015: EXCEPTION
1016: WHEN validation_error THEN

Line 1040: arp_util.debug('jl_ar_receivable_applications.Unapply_br()+');

1036:
1037: BEGIN
1038:
1039: IF PG_DEBUG in ('Y', 'C') THEN
1040: arp_util.debug('jl_ar_receivable_applications.Unapply_br()+');
1041: END IF;
1042:
1043: p_return_status := FND_API.G_RET_STS_SUCCESS;
1044:

Line 1048: FROM ar_receivable_applications

1044:
1045: BEGIN
1046: SELECT apply_date
1047: INTO x_apply_date
1048: FROM ar_receivable_applications
1049: WHERE cash_receipt_id = p_cash_receipt_id
1050: AND applied_payment_schedule_id = p_applied_payment_schedule_id;
1051: EXCEPTION
1052: WHEN OTHERS THEN

Line 1109: arp_util.debug('jl_ar_receivable_applications.Unapply_br()-');

1105:
1106: END IF;
1107:
1108: IF PG_DEBUG in ('Y', 'C') THEN
1109: arp_util.debug('jl_ar_receivable_applications.Unapply_br()-');
1110: END IF;
1111:
1112: END Unapply_br;
1113:

Line 1122: from ar_receivable_applications

1118: Cursor pay_sched is
1119: Select applied_payment_schedule_id pay_sched_id,
1120: global_attribute3 calculated_interest,
1121: apply_date
1122: from ar_receivable_applications
1123: where status = 'APP'
1124: and cash_receipt_id = p_cash_receipt_id;
1125:
1126: ps_rec pay_sched%ROWTYPE;

Line 1144: arp_util.debug('jl_ar_receivable_applications.Reverse_br()+');

1140:
1141: BEGIN
1142:
1143: IF PG_DEBUG in ('Y', 'C') THEN
1144: arp_util.debug('jl_ar_receivable_applications.Reverse_br()+');
1145: END IF;
1146:
1147: jl_zz_ar_library_1_pkg.get_interest_reversal_flag(p_cash_receipt_id,
1148: x_interest_reversal,

Line 1228: arp_util.debug('jl_ar_receivable_applications.Reverse_br()-');

1224: p_return_status := FND_API.G_RET_STS_ERROR;
1225: END IF;
1226:
1227: IF PG_DEBUG in ('Y', 'C') THEN
1228: arp_util.debug('jl_ar_receivable_applications.Reverse_br()-');
1229: END IF;
1230:
1231: END Reverse_br;
1232:

Line 1279: arp_util.debug('jl_ar_receivable_applications.Apply()+');

1275: BEGIN
1276:
1277:
1278: IF PG_DEBUG in ('Y', 'C') THEN
1279: arp_util.debug('jl_ar_receivable_applications.Apply()+');
1280: END IF;
1281:
1282: --l_country_code := FND_PROFILE.VALUE('JGZZ_COUNTRY_CODE');
1283: l_org_id := MO_GLOBAL.get_current_org_id;

Line 1345: arp_util.debug('jl_ar_receivable_applications.Apply()-');

1341: END IF;
1342: END IF;
1343:
1344: IF PG_DEBUG in ('Y', 'C') THEN
1345: arp_util.debug('jl_ar_receivable_applications.Apply()-');
1346: END IF;
1347:
1348:
1349: END Apply;

Line 1362: arp_util.debug('jl_ar_receivable_applications.Unapply()+');

1358:
1359: BEGIN
1360:
1361: IF PG_DEBUG in ('Y', 'C') THEN
1362: arp_util.debug('jl_ar_receivable_applications.Unapply()+');
1363: END IF;
1364:
1365: l_org_id := MO_GLOBAL.get_current_org_id;
1366:

Line 1381: arp_util.debug('jl_ar_receivable_applications.Unapply()-');

1377: p_return_status);
1378: END IF;
1379:
1380: IF PG_DEBUG in ('Y', 'C') THEN
1381: arp_util.debug('jl_ar_receivable_applications.Unapply()-');
1382: END IF;
1383:
1384:
1385: END Unapply;

Line 1397: arp_util.debug('jl_ar_receivable_applications.Reverse()+');

1393:
1394: BEGIN
1395:
1396: IF PG_DEBUG in ('Y', 'C') THEN
1397: arp_util.debug('jl_ar_receivable_applications.Reverse()+');
1398: END IF;
1399:
1400: l_org_id := MO_GLOBAL.get_current_org_id;
1401:

Line 1414: arp_util.debug('jl_ar_receivable_applications.Reverse()-');

1410: p_return_status);
1411: END IF;
1412:
1413: IF PG_DEBUG in ('Y', 'C') THEN
1414: arp_util.debug('jl_ar_receivable_applications.Reverse()-');
1415: END IF;
1416:
1417: END Reverse;
1418:

Line 1486: from ar_receivable_applications_all ara,

1482: aicl.global_attribute6,
1483: aicl.global_attribute7,
1484: aicl.global_attribute8,
1485: aicl.global_attribute10
1486: from ar_receivable_applications_all ara,
1487: ar_cash_receipts_all acr,
1488: ar_interim_cash_rcpt_lines_all aicl
1489: --ar_interim_cash_receipts_all aic
1490: where ara.request_id = p_request_id

Line 1499: from ar_receivable_applications_all ara

1495:
1496: cursor p(p_request_id IN NUMBER) is
1497: select ara.cash_receipt_id,
1498: ara.applied_payment_schedule_id
1499: from ar_receivable_applications_all ara
1500: where request_id = p_request_id;
1501:
1502:
1503: BEGIN

Line 1506: fnd_file.put_line(fnd_file.log,'Inside3 jl_ar_receivable_applications.Create_interest_adjustment()+');

1502:
1503: BEGIN
1504:
1505: --IF PG_DEBUG in ('Y', 'C') THEN
1506: fnd_file.put_line(fnd_file.log,'Inside3 jl_ar_receivable_applications.Create_interest_adjustment()+');
1507: --END IF;
1508:
1509: fnd_file.put_line(fnd_file.log,'Rec Appl Id :'||to_char(p_post_quickcash_req_id));
1510:

Line 1517: update ar_receivable_applications_all

1513: Loop
1514:
1515: fnd_file.put_line(fnd_file.log,'After opening the cursor()+');
1516:
1517: update ar_receivable_applications_all
1518: set global_attribute1 = rint.global_attribute3 ,
1519: global_attribute2 = rint.global_attribute4 ,
1520: global_attribute3 = rint.global_attribute1 ,
1521: global_attribute4 = rint.global_attribute2 ,

Line 1593: arp_util.debug('jl_ar_receivable_applications.Create_interest_adjustments()-');

1589:
1590: End Loop;
1591:
1592: --IF PG_DEBUG in ('Y', 'C') THEN
1593: arp_util.debug('jl_ar_receivable_applications.Create_interest_adjustments()-');
1594: --END IF;
1595:
1596: END Create_interest_adjustment;
1597:

Line 1606: END jl_ar_receivable_applications;

1602: delete from ar_adjustments_all
1603: where associated_cash_receipt_id = p_cash_receipt_id;
1604: END delete_interest_adjustment;
1605:
1606: END jl_ar_receivable_applications;