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.ARP_BALANCE_CHECK dependencies on ARP_BALANCE_CHECK

Line 1: PACKAGE BODY ARP_BALANCE_CHECK AS

1: PACKAGE BODY ARP_BALANCE_CHECK AS
2: /* $Header: ARBALCHB.pls 120.10.12020000.4 2012/10/31 06:34:02 jatian ship $ */
3:
4: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
5: PG_BAL_CHECK_ENABLED varchar2(1) := NVL(FND_PROFILE.value('AR_ENABLE_JOURNAL_BAL_CHECK'),'Y');

Line 327: ARP_BALANCE_CHECK.P_ps_rec.payment_schedule_id := NULL;

323:
324:
325:
326:
327: ARP_BALANCE_CHECK.P_ps_rec.payment_schedule_id := NULL;
328: ARP_BALANCE_CHECK.p_ps_rec.customer_trx_id := NULL;
329: ARP_BALANCE_CHECK.p_ps_rec.cash_receipt_id := NULL;
330: ARP_BALANCE_CHECK.p_ps_rec.class := NULL;
331: ARP_BALANCE_CHECK.p_ps_rec.actual_date_closed := NULL;

Line 328: ARP_BALANCE_CHECK.p_ps_rec.customer_trx_id := NULL;

324:
325:
326:
327: ARP_BALANCE_CHECK.P_ps_rec.payment_schedule_id := NULL;
328: ARP_BALANCE_CHECK.p_ps_rec.customer_trx_id := NULL;
329: ARP_BALANCE_CHECK.p_ps_rec.cash_receipt_id := NULL;
330: ARP_BALANCE_CHECK.p_ps_rec.class := NULL;
331: ARP_BALANCE_CHECK.p_ps_rec.actual_date_closed := NULL;
332: ARP_BALANCE_CHECK.p_ps_rec.status := NULL;

Line 329: ARP_BALANCE_CHECK.p_ps_rec.cash_receipt_id := NULL;

325:
326:
327: ARP_BALANCE_CHECK.P_ps_rec.payment_schedule_id := NULL;
328: ARP_BALANCE_CHECK.p_ps_rec.customer_trx_id := NULL;
329: ARP_BALANCE_CHECK.p_ps_rec.cash_receipt_id := NULL;
330: ARP_BALANCE_CHECK.p_ps_rec.class := NULL;
331: ARP_BALANCE_CHECK.p_ps_rec.actual_date_closed := NULL;
332: ARP_BALANCE_CHECK.p_ps_rec.status := NULL;
333: ARP_BALANCE_CHECK.p_ps_rec.trx_number := NULL;

Line 330: ARP_BALANCE_CHECK.p_ps_rec.class := NULL;

326:
327: ARP_BALANCE_CHECK.P_ps_rec.payment_schedule_id := NULL;
328: ARP_BALANCE_CHECK.p_ps_rec.customer_trx_id := NULL;
329: ARP_BALANCE_CHECK.p_ps_rec.cash_receipt_id := NULL;
330: ARP_BALANCE_CHECK.p_ps_rec.class := NULL;
331: ARP_BALANCE_CHECK.p_ps_rec.actual_date_closed := NULL;
332: ARP_BALANCE_CHECK.p_ps_rec.status := NULL;
333: ARP_BALANCE_CHECK.p_ps_rec.trx_number := NULL;
334: ARP_BALANCE_CHECK.p_ps_rec.gl_date_closed := NULL;

Line 331: ARP_BALANCE_CHECK.p_ps_rec.actual_date_closed := NULL;

327: ARP_BALANCE_CHECK.P_ps_rec.payment_schedule_id := NULL;
328: ARP_BALANCE_CHECK.p_ps_rec.customer_trx_id := NULL;
329: ARP_BALANCE_CHECK.p_ps_rec.cash_receipt_id := NULL;
330: ARP_BALANCE_CHECK.p_ps_rec.class := NULL;
331: ARP_BALANCE_CHECK.p_ps_rec.actual_date_closed := NULL;
332: ARP_BALANCE_CHECK.p_ps_rec.status := NULL;
333: ARP_BALANCE_CHECK.p_ps_rec.trx_number := NULL;
334: ARP_BALANCE_CHECK.p_ps_rec.gl_date_closed := NULL;
335:

Line 332: ARP_BALANCE_CHECK.p_ps_rec.status := NULL;

328: ARP_BALANCE_CHECK.p_ps_rec.customer_trx_id := NULL;
329: ARP_BALANCE_CHECK.p_ps_rec.cash_receipt_id := NULL;
330: ARP_BALANCE_CHECK.p_ps_rec.class := NULL;
331: ARP_BALANCE_CHECK.p_ps_rec.actual_date_closed := NULL;
332: ARP_BALANCE_CHECK.p_ps_rec.status := NULL;
333: ARP_BALANCE_CHECK.p_ps_rec.trx_number := NULL;
334: ARP_BALANCE_CHECK.p_ps_rec.gl_date_closed := NULL;
335:
336: ARP_BALANCE_CHECK.P_ps_rec_pmt.payment_schedule_id := NULL;

Line 333: ARP_BALANCE_CHECK.p_ps_rec.trx_number := NULL;

329: ARP_BALANCE_CHECK.p_ps_rec.cash_receipt_id := NULL;
330: ARP_BALANCE_CHECK.p_ps_rec.class := NULL;
331: ARP_BALANCE_CHECK.p_ps_rec.actual_date_closed := NULL;
332: ARP_BALANCE_CHECK.p_ps_rec.status := NULL;
333: ARP_BALANCE_CHECK.p_ps_rec.trx_number := NULL;
334: ARP_BALANCE_CHECK.p_ps_rec.gl_date_closed := NULL;
335:
336: ARP_BALANCE_CHECK.P_ps_rec_pmt.payment_schedule_id := NULL;
337: ARP_BALANCE_CHECK.P_ps_rec_pmt.customer_trx_id := NULL;

Line 334: ARP_BALANCE_CHECK.p_ps_rec.gl_date_closed := NULL;

330: ARP_BALANCE_CHECK.p_ps_rec.class := NULL;
331: ARP_BALANCE_CHECK.p_ps_rec.actual_date_closed := NULL;
332: ARP_BALANCE_CHECK.p_ps_rec.status := NULL;
333: ARP_BALANCE_CHECK.p_ps_rec.trx_number := NULL;
334: ARP_BALANCE_CHECK.p_ps_rec.gl_date_closed := NULL;
335:
336: ARP_BALANCE_CHECK.P_ps_rec_pmt.payment_schedule_id := NULL;
337: ARP_BALANCE_CHECK.P_ps_rec_pmt.customer_trx_id := NULL;
338: ARP_BALANCE_CHECK.P_ps_rec_pmt.cash_receipt_id := NULL;

Line 336: ARP_BALANCE_CHECK.P_ps_rec_pmt.payment_schedule_id := NULL;

332: ARP_BALANCE_CHECK.p_ps_rec.status := NULL;
333: ARP_BALANCE_CHECK.p_ps_rec.trx_number := NULL;
334: ARP_BALANCE_CHECK.p_ps_rec.gl_date_closed := NULL;
335:
336: ARP_BALANCE_CHECK.P_ps_rec_pmt.payment_schedule_id := NULL;
337: ARP_BALANCE_CHECK.P_ps_rec_pmt.customer_trx_id := NULL;
338: ARP_BALANCE_CHECK.P_ps_rec_pmt.cash_receipt_id := NULL;
339: ARP_BALANCE_CHECK.P_ps_rec_pmt.class := NULL;
340: ARP_BALANCE_CHECK.P_ps_rec_pmt.actual_date_closed := NULL;

Line 337: ARP_BALANCE_CHECK.P_ps_rec_pmt.customer_trx_id := NULL;

333: ARP_BALANCE_CHECK.p_ps_rec.trx_number := NULL;
334: ARP_BALANCE_CHECK.p_ps_rec.gl_date_closed := NULL;
335:
336: ARP_BALANCE_CHECK.P_ps_rec_pmt.payment_schedule_id := NULL;
337: ARP_BALANCE_CHECK.P_ps_rec_pmt.customer_trx_id := NULL;
338: ARP_BALANCE_CHECK.P_ps_rec_pmt.cash_receipt_id := NULL;
339: ARP_BALANCE_CHECK.P_ps_rec_pmt.class := NULL;
340: ARP_BALANCE_CHECK.P_ps_rec_pmt.actual_date_closed := NULL;
341: ARP_BALANCE_CHECK.P_ps_rec_pmt.status := NULL;

Line 338: ARP_BALANCE_CHECK.P_ps_rec_pmt.cash_receipt_id := NULL;

334: ARP_BALANCE_CHECK.p_ps_rec.gl_date_closed := NULL;
335:
336: ARP_BALANCE_CHECK.P_ps_rec_pmt.payment_schedule_id := NULL;
337: ARP_BALANCE_CHECK.P_ps_rec_pmt.customer_trx_id := NULL;
338: ARP_BALANCE_CHECK.P_ps_rec_pmt.cash_receipt_id := NULL;
339: ARP_BALANCE_CHECK.P_ps_rec_pmt.class := NULL;
340: ARP_BALANCE_CHECK.P_ps_rec_pmt.actual_date_closed := NULL;
341: ARP_BALANCE_CHECK.P_ps_rec_pmt.status := NULL;
342: ARP_BALANCE_CHECK.P_ps_rec_pmt.trx_number := NULL;

Line 339: ARP_BALANCE_CHECK.P_ps_rec_pmt.class := NULL;

335:
336: ARP_BALANCE_CHECK.P_ps_rec_pmt.payment_schedule_id := NULL;
337: ARP_BALANCE_CHECK.P_ps_rec_pmt.customer_trx_id := NULL;
338: ARP_BALANCE_CHECK.P_ps_rec_pmt.cash_receipt_id := NULL;
339: ARP_BALANCE_CHECK.P_ps_rec_pmt.class := NULL;
340: ARP_BALANCE_CHECK.P_ps_rec_pmt.actual_date_closed := NULL;
341: ARP_BALANCE_CHECK.P_ps_rec_pmt.status := NULL;
342: ARP_BALANCE_CHECK.P_ps_rec_pmt.trx_number := NULL;
343: ARP_BALANCE_CHECK.P_ps_rec_pmt.gl_date_closed := NULL;

Line 340: ARP_BALANCE_CHECK.P_ps_rec_pmt.actual_date_closed := NULL;

336: ARP_BALANCE_CHECK.P_ps_rec_pmt.payment_schedule_id := NULL;
337: ARP_BALANCE_CHECK.P_ps_rec_pmt.customer_trx_id := NULL;
338: ARP_BALANCE_CHECK.P_ps_rec_pmt.cash_receipt_id := NULL;
339: ARP_BALANCE_CHECK.P_ps_rec_pmt.class := NULL;
340: ARP_BALANCE_CHECK.P_ps_rec_pmt.actual_date_closed := NULL;
341: ARP_BALANCE_CHECK.P_ps_rec_pmt.status := NULL;
342: ARP_BALANCE_CHECK.P_ps_rec_pmt.trx_number := NULL;
343: ARP_BALANCE_CHECK.P_ps_rec_pmt.gl_date_closed := NULL;
344:

Line 341: ARP_BALANCE_CHECK.P_ps_rec_pmt.status := NULL;

337: ARP_BALANCE_CHECK.P_ps_rec_pmt.customer_trx_id := NULL;
338: ARP_BALANCE_CHECK.P_ps_rec_pmt.cash_receipt_id := NULL;
339: ARP_BALANCE_CHECK.P_ps_rec_pmt.class := NULL;
340: ARP_BALANCE_CHECK.P_ps_rec_pmt.actual_date_closed := NULL;
341: ARP_BALANCE_CHECK.P_ps_rec_pmt.status := NULL;
342: ARP_BALANCE_CHECK.P_ps_rec_pmt.trx_number := NULL;
343: ARP_BALANCE_CHECK.P_ps_rec_pmt.gl_date_closed := NULL;
344:
345: IF l_corrupt_type is not null then

Line 342: ARP_BALANCE_CHECK.P_ps_rec_pmt.trx_number := NULL;

338: ARP_BALANCE_CHECK.P_ps_rec_pmt.cash_receipt_id := NULL;
339: ARP_BALANCE_CHECK.P_ps_rec_pmt.class := NULL;
340: ARP_BALANCE_CHECK.P_ps_rec_pmt.actual_date_closed := NULL;
341: ARP_BALANCE_CHECK.P_ps_rec_pmt.status := NULL;
342: ARP_BALANCE_CHECK.P_ps_rec_pmt.trx_number := NULL;
343: ARP_BALANCE_CHECK.P_ps_rec_pmt.gl_date_closed := NULL;
344:
345: IF l_corrupt_type is not null then
346: l_corruption_exists :=TRUE;

Line 343: ARP_BALANCE_CHECK.P_ps_rec_pmt.gl_date_closed := NULL;

339: ARP_BALANCE_CHECK.P_ps_rec_pmt.class := NULL;
340: ARP_BALANCE_CHECK.P_ps_rec_pmt.actual_date_closed := NULL;
341: ARP_BALANCE_CHECK.P_ps_rec_pmt.status := NULL;
342: ARP_BALANCE_CHECK.P_ps_rec_pmt.trx_number := NULL;
343: ARP_BALANCE_CHECK.P_ps_rec_pmt.gl_date_closed := NULL;
344:
345: IF l_corrupt_type is not null then
346: l_corruption_exists :=TRUE;
347: RAISE ps_data_corrupted;

Line 475: arp_standard.debug('ARP_BALANCE_CHECK.CHECK_RECP_BALANCE_BULK (+)');

471:
472: BEGIN
473:
474: IF PG_DEBUG in ('Y', 'C') THEN
475: arp_standard.debug('ARP_BALANCE_CHECK.CHECK_RECP_BALANCE_BULK (+)');
476: END IF;
477:
478: IF PG_BAL_CHECK_ENABLED = 'Y' THEN
479:

Line 485: arp_standard.debug('ARP_BALANCE_CHECK.CHECK_RECP_BALANCE_BULK - OUT_OF_BALANCE');

481:
482: FOR c2 in c1(p_cr_id_low, p_cr_id_high) LOOP
483:
484: IF PG_DEBUG in ('Y', 'C') THEN
485: arp_standard.debug('ARP_BALANCE_CHECK.CHECK_RECP_BALANCE_BULK - OUT_OF_BALANCE');
486: arp_standard.debug('Cash Receipt Id: ' || c2.cr_id);
487: arp_standard.debug('GL Date: ' || to_char(c2.gl_date,'DD-MON-YYYY'));
488: arp_standard.debug('Sum Amount Dr: ' || c2.sum_amount_dr);
489: arp_standard.debug('Sum Amount Cr: ' || c2.sum_amount_cr);

Line 519: arp_standard.debug('ARP_BALANCE_CHECK.CHECK_RECP_BALANCE_BULK (-)');

515:
516: END IF;
517:
518: IF PG_DEBUG in ('Y', 'C') THEN
519: arp_standard.debug('ARP_BALANCE_CHECK.CHECK_RECP_BALANCE_BULK (-)');
520: END IF;
521:
522: EXCEPTION
523: WHEN OTHERS THEN

Line 525: arp_standard.debug('ARP_BALANCE_CHECK.CHECK_RECP_BALANCE_BULK - OTHERS');

521:
522: EXCEPTION
523: WHEN OTHERS THEN
524: IF PG_DEBUG in ('Y', 'C') THEN
525: arp_standard.debug('ARP_BALANCE_CHECK.CHECK_RECP_BALANCE_BULK - OTHERS');
526: END IF;
527: RAISE;
528: END CHECK_RECP_BALANCE_BULK;
529:

Line 649: ARP_BALANCE_CHECK.P_ps_rec.payment_schedule_id := NULL;

645: p_corrupt_type => l_corrupt_type,
646: p_gl_date_closed => l_gl_date_closed,
647: p_actual_date_closed => l_actual_date_closed);
648:
649: ARP_BALANCE_CHECK.P_ps_rec.payment_schedule_id := NULL;
650: ARP_BALANCE_CHECK.p_ps_rec.customer_trx_id := NULL;
651: ARP_BALANCE_CHECK.p_ps_rec.cash_receipt_id := NULL;
652: ARP_BALANCE_CHECK.p_ps_rec.class := NULL;
653: ARP_BALANCE_CHECK.p_ps_rec.actual_date_closed := NULL;

Line 650: ARP_BALANCE_CHECK.p_ps_rec.customer_trx_id := NULL;

646: p_gl_date_closed => l_gl_date_closed,
647: p_actual_date_closed => l_actual_date_closed);
648:
649: ARP_BALANCE_CHECK.P_ps_rec.payment_schedule_id := NULL;
650: ARP_BALANCE_CHECK.p_ps_rec.customer_trx_id := NULL;
651: ARP_BALANCE_CHECK.p_ps_rec.cash_receipt_id := NULL;
652: ARP_BALANCE_CHECK.p_ps_rec.class := NULL;
653: ARP_BALANCE_CHECK.p_ps_rec.actual_date_closed := NULL;
654: ARP_BALANCE_CHECK.p_ps_rec.status := NULL;

Line 651: ARP_BALANCE_CHECK.p_ps_rec.cash_receipt_id := NULL;

647: p_actual_date_closed => l_actual_date_closed);
648:
649: ARP_BALANCE_CHECK.P_ps_rec.payment_schedule_id := NULL;
650: ARP_BALANCE_CHECK.p_ps_rec.customer_trx_id := NULL;
651: ARP_BALANCE_CHECK.p_ps_rec.cash_receipt_id := NULL;
652: ARP_BALANCE_CHECK.p_ps_rec.class := NULL;
653: ARP_BALANCE_CHECK.p_ps_rec.actual_date_closed := NULL;
654: ARP_BALANCE_CHECK.p_ps_rec.status := NULL;
655: ARP_BALANCE_CHECK.p_ps_rec.trx_number := NULL;

Line 652: ARP_BALANCE_CHECK.p_ps_rec.class := NULL;

648:
649: ARP_BALANCE_CHECK.P_ps_rec.payment_schedule_id := NULL;
650: ARP_BALANCE_CHECK.p_ps_rec.customer_trx_id := NULL;
651: ARP_BALANCE_CHECK.p_ps_rec.cash_receipt_id := NULL;
652: ARP_BALANCE_CHECK.p_ps_rec.class := NULL;
653: ARP_BALANCE_CHECK.p_ps_rec.actual_date_closed := NULL;
654: ARP_BALANCE_CHECK.p_ps_rec.status := NULL;
655: ARP_BALANCE_CHECK.p_ps_rec.trx_number := NULL;
656: ARP_BALANCE_CHECK.p_ps_rec.gl_date_closed := NULL;

Line 653: ARP_BALANCE_CHECK.p_ps_rec.actual_date_closed := NULL;

649: ARP_BALANCE_CHECK.P_ps_rec.payment_schedule_id := NULL;
650: ARP_BALANCE_CHECK.p_ps_rec.customer_trx_id := NULL;
651: ARP_BALANCE_CHECK.p_ps_rec.cash_receipt_id := NULL;
652: ARP_BALANCE_CHECK.p_ps_rec.class := NULL;
653: ARP_BALANCE_CHECK.p_ps_rec.actual_date_closed := NULL;
654: ARP_BALANCE_CHECK.p_ps_rec.status := NULL;
655: ARP_BALANCE_CHECK.p_ps_rec.trx_number := NULL;
656: ARP_BALANCE_CHECK.p_ps_rec.gl_date_closed := NULL;
657:

Line 654: ARP_BALANCE_CHECK.p_ps_rec.status := NULL;

650: ARP_BALANCE_CHECK.p_ps_rec.customer_trx_id := NULL;
651: ARP_BALANCE_CHECK.p_ps_rec.cash_receipt_id := NULL;
652: ARP_BALANCE_CHECK.p_ps_rec.class := NULL;
653: ARP_BALANCE_CHECK.p_ps_rec.actual_date_closed := NULL;
654: ARP_BALANCE_CHECK.p_ps_rec.status := NULL;
655: ARP_BALANCE_CHECK.p_ps_rec.trx_number := NULL;
656: ARP_BALANCE_CHECK.p_ps_rec.gl_date_closed := NULL;
657:
658: IF l_corrupt_type is not null then

Line 655: ARP_BALANCE_CHECK.p_ps_rec.trx_number := NULL;

651: ARP_BALANCE_CHECK.p_ps_rec.cash_receipt_id := NULL;
652: ARP_BALANCE_CHECK.p_ps_rec.class := NULL;
653: ARP_BALANCE_CHECK.p_ps_rec.actual_date_closed := NULL;
654: ARP_BALANCE_CHECK.p_ps_rec.status := NULL;
655: ARP_BALANCE_CHECK.p_ps_rec.trx_number := NULL;
656: ARP_BALANCE_CHECK.p_ps_rec.gl_date_closed := NULL;
657:
658: IF l_corrupt_type is not null then
659: l_corruption_exists :=TRUE;

Line 656: ARP_BALANCE_CHECK.p_ps_rec.gl_date_closed := NULL;

652: ARP_BALANCE_CHECK.p_ps_rec.class := NULL;
653: ARP_BALANCE_CHECK.p_ps_rec.actual_date_closed := NULL;
654: ARP_BALANCE_CHECK.p_ps_rec.status := NULL;
655: ARP_BALANCE_CHECK.p_ps_rec.trx_number := NULL;
656: ARP_BALANCE_CHECK.p_ps_rec.gl_date_closed := NULL;
657:
658: IF l_corrupt_type is not null then
659: l_corruption_exists :=TRUE;
660: RAISE ps_data_corrupted;

Line 836: ARP_BALANCE_CHECK.P_ps_rec.payment_schedule_id := NULL;

832: p_gl_date_closed => l_gl_date_closed,
833: p_actual_date_closed => l_actual_date_closed);
834: END IF;
835:
836: ARP_BALANCE_CHECK.P_ps_rec.payment_schedule_id := NULL;
837: ARP_BALANCE_CHECK.p_ps_rec.customer_trx_id := NULL;
838: ARP_BALANCE_CHECK.p_ps_rec.cash_receipt_id := NULL;
839: ARP_BALANCE_CHECK.p_ps_rec.class := NULL;
840: ARP_BALANCE_CHECK.p_ps_rec.actual_date_closed := NULL;

Line 837: ARP_BALANCE_CHECK.p_ps_rec.customer_trx_id := NULL;

833: p_actual_date_closed => l_actual_date_closed);
834: END IF;
835:
836: ARP_BALANCE_CHECK.P_ps_rec.payment_schedule_id := NULL;
837: ARP_BALANCE_CHECK.p_ps_rec.customer_trx_id := NULL;
838: ARP_BALANCE_CHECK.p_ps_rec.cash_receipt_id := NULL;
839: ARP_BALANCE_CHECK.p_ps_rec.class := NULL;
840: ARP_BALANCE_CHECK.p_ps_rec.actual_date_closed := NULL;
841: ARP_BALANCE_CHECK.p_ps_rec.status := NULL;

Line 838: ARP_BALANCE_CHECK.p_ps_rec.cash_receipt_id := NULL;

834: END IF;
835:
836: ARP_BALANCE_CHECK.P_ps_rec.payment_schedule_id := NULL;
837: ARP_BALANCE_CHECK.p_ps_rec.customer_trx_id := NULL;
838: ARP_BALANCE_CHECK.p_ps_rec.cash_receipt_id := NULL;
839: ARP_BALANCE_CHECK.p_ps_rec.class := NULL;
840: ARP_BALANCE_CHECK.p_ps_rec.actual_date_closed := NULL;
841: ARP_BALANCE_CHECK.p_ps_rec.status := NULL;
842: ARP_BALANCE_CHECK.p_ps_rec.trx_number := NULL;

Line 839: ARP_BALANCE_CHECK.p_ps_rec.class := NULL;

835:
836: ARP_BALANCE_CHECK.P_ps_rec.payment_schedule_id := NULL;
837: ARP_BALANCE_CHECK.p_ps_rec.customer_trx_id := NULL;
838: ARP_BALANCE_CHECK.p_ps_rec.cash_receipt_id := NULL;
839: ARP_BALANCE_CHECK.p_ps_rec.class := NULL;
840: ARP_BALANCE_CHECK.p_ps_rec.actual_date_closed := NULL;
841: ARP_BALANCE_CHECK.p_ps_rec.status := NULL;
842: ARP_BALANCE_CHECK.p_ps_rec.trx_number := NULL;
843: ARP_BALANCE_CHECK.p_ps_rec.gl_date_closed := NULL;

Line 840: ARP_BALANCE_CHECK.p_ps_rec.actual_date_closed := NULL;

836: ARP_BALANCE_CHECK.P_ps_rec.payment_schedule_id := NULL;
837: ARP_BALANCE_CHECK.p_ps_rec.customer_trx_id := NULL;
838: ARP_BALANCE_CHECK.p_ps_rec.cash_receipt_id := NULL;
839: ARP_BALANCE_CHECK.p_ps_rec.class := NULL;
840: ARP_BALANCE_CHECK.p_ps_rec.actual_date_closed := NULL;
841: ARP_BALANCE_CHECK.p_ps_rec.status := NULL;
842: ARP_BALANCE_CHECK.p_ps_rec.trx_number := NULL;
843: ARP_BALANCE_CHECK.p_ps_rec.gl_date_closed := NULL;
844:

Line 841: ARP_BALANCE_CHECK.p_ps_rec.status := NULL;

837: ARP_BALANCE_CHECK.p_ps_rec.customer_trx_id := NULL;
838: ARP_BALANCE_CHECK.p_ps_rec.cash_receipt_id := NULL;
839: ARP_BALANCE_CHECK.p_ps_rec.class := NULL;
840: ARP_BALANCE_CHECK.p_ps_rec.actual_date_closed := NULL;
841: ARP_BALANCE_CHECK.p_ps_rec.status := NULL;
842: ARP_BALANCE_CHECK.p_ps_rec.trx_number := NULL;
843: ARP_BALANCE_CHECK.p_ps_rec.gl_date_closed := NULL;
844:
845: ARP_BALANCE_CHECK.P_ps_rec_pmt.payment_schedule_id := NULL;

Line 842: ARP_BALANCE_CHECK.p_ps_rec.trx_number := NULL;

838: ARP_BALANCE_CHECK.p_ps_rec.cash_receipt_id := NULL;
839: ARP_BALANCE_CHECK.p_ps_rec.class := NULL;
840: ARP_BALANCE_CHECK.p_ps_rec.actual_date_closed := NULL;
841: ARP_BALANCE_CHECK.p_ps_rec.status := NULL;
842: ARP_BALANCE_CHECK.p_ps_rec.trx_number := NULL;
843: ARP_BALANCE_CHECK.p_ps_rec.gl_date_closed := NULL;
844:
845: ARP_BALANCE_CHECK.P_ps_rec_pmt.payment_schedule_id := NULL;
846: ARP_BALANCE_CHECK.P_ps_rec_pmt.customer_trx_id := NULL;

Line 843: ARP_BALANCE_CHECK.p_ps_rec.gl_date_closed := NULL;

839: ARP_BALANCE_CHECK.p_ps_rec.class := NULL;
840: ARP_BALANCE_CHECK.p_ps_rec.actual_date_closed := NULL;
841: ARP_BALANCE_CHECK.p_ps_rec.status := NULL;
842: ARP_BALANCE_CHECK.p_ps_rec.trx_number := NULL;
843: ARP_BALANCE_CHECK.p_ps_rec.gl_date_closed := NULL;
844:
845: ARP_BALANCE_CHECK.P_ps_rec_pmt.payment_schedule_id := NULL;
846: ARP_BALANCE_CHECK.P_ps_rec_pmt.customer_trx_id := NULL;
847: ARP_BALANCE_CHECK.P_ps_rec_pmt.cash_receipt_id := NULL;

Line 845: ARP_BALANCE_CHECK.P_ps_rec_pmt.payment_schedule_id := NULL;

841: ARP_BALANCE_CHECK.p_ps_rec.status := NULL;
842: ARP_BALANCE_CHECK.p_ps_rec.trx_number := NULL;
843: ARP_BALANCE_CHECK.p_ps_rec.gl_date_closed := NULL;
844:
845: ARP_BALANCE_CHECK.P_ps_rec_pmt.payment_schedule_id := NULL;
846: ARP_BALANCE_CHECK.P_ps_rec_pmt.customer_trx_id := NULL;
847: ARP_BALANCE_CHECK.P_ps_rec_pmt.cash_receipt_id := NULL;
848: ARP_BALANCE_CHECK.P_ps_rec_pmt.class := NULL;
849: ARP_BALANCE_CHECK.P_ps_rec_pmt.actual_date_closed := NULL;

Line 846: ARP_BALANCE_CHECK.P_ps_rec_pmt.customer_trx_id := NULL;

842: ARP_BALANCE_CHECK.p_ps_rec.trx_number := NULL;
843: ARP_BALANCE_CHECK.p_ps_rec.gl_date_closed := NULL;
844:
845: ARP_BALANCE_CHECK.P_ps_rec_pmt.payment_schedule_id := NULL;
846: ARP_BALANCE_CHECK.P_ps_rec_pmt.customer_trx_id := NULL;
847: ARP_BALANCE_CHECK.P_ps_rec_pmt.cash_receipt_id := NULL;
848: ARP_BALANCE_CHECK.P_ps_rec_pmt.class := NULL;
849: ARP_BALANCE_CHECK.P_ps_rec_pmt.actual_date_closed := NULL;
850: ARP_BALANCE_CHECK.P_ps_rec_pmt.status := NULL;

Line 847: ARP_BALANCE_CHECK.P_ps_rec_pmt.cash_receipt_id := NULL;

843: ARP_BALANCE_CHECK.p_ps_rec.gl_date_closed := NULL;
844:
845: ARP_BALANCE_CHECK.P_ps_rec_pmt.payment_schedule_id := NULL;
846: ARP_BALANCE_CHECK.P_ps_rec_pmt.customer_trx_id := NULL;
847: ARP_BALANCE_CHECK.P_ps_rec_pmt.cash_receipt_id := NULL;
848: ARP_BALANCE_CHECK.P_ps_rec_pmt.class := NULL;
849: ARP_BALANCE_CHECK.P_ps_rec_pmt.actual_date_closed := NULL;
850: ARP_BALANCE_CHECK.P_ps_rec_pmt.status := NULL;
851: ARP_BALANCE_CHECK.P_ps_rec_pmt.trx_number := NULL;

Line 848: ARP_BALANCE_CHECK.P_ps_rec_pmt.class := NULL;

844:
845: ARP_BALANCE_CHECK.P_ps_rec_pmt.payment_schedule_id := NULL;
846: ARP_BALANCE_CHECK.P_ps_rec_pmt.customer_trx_id := NULL;
847: ARP_BALANCE_CHECK.P_ps_rec_pmt.cash_receipt_id := NULL;
848: ARP_BALANCE_CHECK.P_ps_rec_pmt.class := NULL;
849: ARP_BALANCE_CHECK.P_ps_rec_pmt.actual_date_closed := NULL;
850: ARP_BALANCE_CHECK.P_ps_rec_pmt.status := NULL;
851: ARP_BALANCE_CHECK.P_ps_rec_pmt.trx_number := NULL;
852: ARP_BALANCE_CHECK.P_ps_rec_pmt.gl_date_closed := NULL;

Line 849: ARP_BALANCE_CHECK.P_ps_rec_pmt.actual_date_closed := NULL;

845: ARP_BALANCE_CHECK.P_ps_rec_pmt.payment_schedule_id := NULL;
846: ARP_BALANCE_CHECK.P_ps_rec_pmt.customer_trx_id := NULL;
847: ARP_BALANCE_CHECK.P_ps_rec_pmt.cash_receipt_id := NULL;
848: ARP_BALANCE_CHECK.P_ps_rec_pmt.class := NULL;
849: ARP_BALANCE_CHECK.P_ps_rec_pmt.actual_date_closed := NULL;
850: ARP_BALANCE_CHECK.P_ps_rec_pmt.status := NULL;
851: ARP_BALANCE_CHECK.P_ps_rec_pmt.trx_number := NULL;
852: ARP_BALANCE_CHECK.P_ps_rec_pmt.gl_date_closed := NULL;
853:

Line 850: ARP_BALANCE_CHECK.P_ps_rec_pmt.status := NULL;

846: ARP_BALANCE_CHECK.P_ps_rec_pmt.customer_trx_id := NULL;
847: ARP_BALANCE_CHECK.P_ps_rec_pmt.cash_receipt_id := NULL;
848: ARP_BALANCE_CHECK.P_ps_rec_pmt.class := NULL;
849: ARP_BALANCE_CHECK.P_ps_rec_pmt.actual_date_closed := NULL;
850: ARP_BALANCE_CHECK.P_ps_rec_pmt.status := NULL;
851: ARP_BALANCE_CHECK.P_ps_rec_pmt.trx_number := NULL;
852: ARP_BALANCE_CHECK.P_ps_rec_pmt.gl_date_closed := NULL;
853:
854: IF l_corrupt_type is not null then

Line 851: ARP_BALANCE_CHECK.P_ps_rec_pmt.trx_number := NULL;

847: ARP_BALANCE_CHECK.P_ps_rec_pmt.cash_receipt_id := NULL;
848: ARP_BALANCE_CHECK.P_ps_rec_pmt.class := NULL;
849: ARP_BALANCE_CHECK.P_ps_rec_pmt.actual_date_closed := NULL;
850: ARP_BALANCE_CHECK.P_ps_rec_pmt.status := NULL;
851: ARP_BALANCE_CHECK.P_ps_rec_pmt.trx_number := NULL;
852: ARP_BALANCE_CHECK.P_ps_rec_pmt.gl_date_closed := NULL;
853:
854: IF l_corrupt_type is not null then
855: l_corruption_exists :=TRUE;

Line 852: ARP_BALANCE_CHECK.P_ps_rec_pmt.gl_date_closed := NULL;

848: ARP_BALANCE_CHECK.P_ps_rec_pmt.class := NULL;
849: ARP_BALANCE_CHECK.P_ps_rec_pmt.actual_date_closed := NULL;
850: ARP_BALANCE_CHECK.P_ps_rec_pmt.status := NULL;
851: ARP_BALANCE_CHECK.P_ps_rec_pmt.trx_number := NULL;
852: ARP_BALANCE_CHECK.P_ps_rec_pmt.gl_date_closed := NULL;
853:
854: IF l_corrupt_type is not null then
855: l_corruption_exists :=TRUE;
856: RAISE ps_data_corrupted;

Line 876: ARP_BALANCE_CHECK.P_reg_cm := 'N';

872: value => 'The Value Is Incorrect for '||l_corruption_string ||' .Please Contact Oracle Support');
873: app_exception.raise_exception;
874: END;
875: ELSE
876: ARP_BALANCE_CHECK.P_reg_cm := 'N';
877: END IF;
878:
879: IF PG_DEBUG in ('Y', 'C') THEN
880: arp_standard.debug('ARP_BALANCE_CHK.CHECK_APPLN_BALANCE (-)');

Line 1398: END ARP_BALANCE_CHECK;

1394: END IF;
1395: RAISE;
1396:
1397: END CHECK_LL_TRANSACTION_BALANCE;
1398: END ARP_BALANCE_CHECK;