DBA Data[Home] [Help]

APPS.ARP_PROCESS_WRITEOFF dependencies on ARP_PROCESS_WRITEOFF

Line 1: PACKAGE BODY ARP_PROCESS_WRITEOFF AS

1: PACKAGE BODY ARP_PROCESS_WRITEOFF AS
2: /* $Header: ARPWRTFB.pls 120.8.12000000.4 2007/09/27 11:42:30 nemani ship $ */
3: /*========================================================================
4: | PRIVATE PROCEDURE submit_report
5: |

Line 10: | arp_process_writeoff.create_receipt_writeoff()

6: | DESCRIPTION
7: | This procedure submits the receipt write-off report.
8: |
9: | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
10: | arp_process_writeoff.create_receipt_writeoff()
11: |
12: | CALLS PROCEDURES/FUNCTIONS (local to this package body)
13: | NONE
14: | PARAMETERS

Line 43: arp_util.debug('arp_process_writeoff.submit_report()+');

39: l_org_id NUMBER;
40:
41: BEGIN
42: IF PG_DEBUG in ('Y', 'C') THEN
43: arp_util.debug('arp_process_writeoff.submit_report()+');
44: END IF;
45:
46: l_request_id := fnd_global.conc_request_id;
47:

Line 171: arp_util.debug('arp_process_writeoff.submit_report()-');

167: , argument99 => ''
168: , argument100 => '');
169: END IF;
170: IF PG_DEBUG in ('Y', 'C') THEN
171: arp_util.debug('arp_process_writeoff.submit_report()-');
172: END IF;
173:
174: EXCEPTION
175: WHEN OTHERS THEN

Line 177: arp_util.debug('arp_process_writeoff.submit_report() '||SQLERRM);

173:
174: EXCEPTION
175: WHEN OTHERS THEN
176: IF PG_DEBUG in ('Y', 'C') THEN
177: arp_util.debug('arp_process_writeoff.submit_report() '||SQLERRM);
178: END IF;
179:
180: END submit_report;
181: /*========================================================================

Line 192: | arp_process_writeoff.unapplied_amount()

188: | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
189: | NONE
190: |
191: | CALLS PROCEDURES/FUNCTIONS (local to this package body)
192: | arp_process_writeoff.unapplied_amount()
193: |
194: | PARAMETERS
195: | p_receipt_currency_code IN Receipt currency code
196: | p_unapp_amount IN Unapplied amount

Line 351: arp_util.debug('arp_process_writeoff.creare_receipt_writeoff()+');

347: group by acr.cash_receipt_id,acr.receipt_number,acr.amount,
348: acr.exchange_rate,crh.batch_id;
349:
350: BEGIN
351: arp_util.debug('arp_process_writeoff.creare_receipt_writeoff()+');
352:
353: arp_util.debug('p_receipt curreny '||p_receipt_currency_code);
354: arp_util.debug('p_unapp_amount '||p_unapp_amount);
355: arp_util.debug('p_unapp_amount_percent '||p_unapp_amount_percent);

Line 543: IF NOT (arp_process_writeoff.gt_rec_wrt_off_type.EXISTS(writeoff_rec.batch_id)) AND

539:
540: IF l_actual_writeoff_amount <> 0 THEN
541:
542: /*5444407*/
543: IF NOT (arp_process_writeoff.gt_rec_wrt_off_type.EXISTS(writeoff_rec.batch_id)) AND
544: writeoff_rec.batch_id is not null THEN
545: arp_process_writeoff.gt_rec_wrt_off_type(writeoff_rec.batch_id).batch_id:=writeoff_rec.batch_id;
546: END IF;
547:

Line 545: arp_process_writeoff.gt_rec_wrt_off_type(writeoff_rec.batch_id).batch_id:=writeoff_rec.batch_id;

541:
542: /*5444407*/
543: IF NOT (arp_process_writeoff.gt_rec_wrt_off_type.EXISTS(writeoff_rec.batch_id)) AND
544: writeoff_rec.batch_id is not null THEN
545: arp_process_writeoff.gt_rec_wrt_off_type(writeoff_rec.batch_id).batch_id:=writeoff_rec.batch_id;
546: END IF;
547:
548: --Calling Activity_application Procedure
549: ar_receipt_api_pub.activity_application(

Line 578: arp_util.debug('arp_process_writeoff - Failed for Receipt : '||

574:
575: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS )
576: THEN
577:
578: arp_util.debug('arp_process_writeoff - Failed for Receipt : '||
579: writeoff_rec.receipt_number );
580: arp_util.debug('p_return_status : ' || l_return_status);
581: arp_util.debug('p_msg_count : ' || l_msg_count);
582: arp_util.debug('p_msg_data : ' || l_msg_data);

Line 609: IF arp_process_writeoff.gt_rec_wrt_off_type.COUNT <> 0 THEN

605:
606: END LOOP;
607:
608: /*5444407*/
609: IF arp_process_writeoff.gt_rec_wrt_off_type.COUNT <> 0 THEN
610: l_cnt:=arp_process_writeoff.gt_rec_wrt_off_type.COUNT;
611: arp_util.debug(' Count of records in PL/SQL table :' || to_char(l_cnt));
612: i := arp_process_writeoff.gt_rec_wrt_off_type.FIRST;
613: WHILE i IS NOT NULL LOOP

Line 610: l_cnt:=arp_process_writeoff.gt_rec_wrt_off_type.COUNT;

606: END LOOP;
607:
608: /*5444407*/
609: IF arp_process_writeoff.gt_rec_wrt_off_type.COUNT <> 0 THEN
610: l_cnt:=arp_process_writeoff.gt_rec_wrt_off_type.COUNT;
611: arp_util.debug(' Count of records in PL/SQL table :' || to_char(l_cnt));
612: i := arp_process_writeoff.gt_rec_wrt_off_type.FIRST;
613: WHILE i IS NOT NULL LOOP
614: l_batch_id:=arp_process_writeoff.gt_rec_wrt_off_type(i).batch_id;

Line 612: i := arp_process_writeoff.gt_rec_wrt_off_type.FIRST;

608: /*5444407*/
609: IF arp_process_writeoff.gt_rec_wrt_off_type.COUNT <> 0 THEN
610: l_cnt:=arp_process_writeoff.gt_rec_wrt_off_type.COUNT;
611: arp_util.debug(' Count of records in PL/SQL table :' || to_char(l_cnt));
612: i := arp_process_writeoff.gt_rec_wrt_off_type.FIRST;
613: WHILE i IS NOT NULL LOOP
614: l_batch_id:=arp_process_writeoff.gt_rec_wrt_off_type(i).batch_id;
615: arp_rw_batches_check_pkg.update_batch_status(l_batch_id);
616: i:=arp_process_writeoff.gt_rec_wrt_off_type.NEXT(i);

Line 614: l_batch_id:=arp_process_writeoff.gt_rec_wrt_off_type(i).batch_id;

610: l_cnt:=arp_process_writeoff.gt_rec_wrt_off_type.COUNT;
611: arp_util.debug(' Count of records in PL/SQL table :' || to_char(l_cnt));
612: i := arp_process_writeoff.gt_rec_wrt_off_type.FIRST;
613: WHILE i IS NOT NULL LOOP
614: l_batch_id:=arp_process_writeoff.gt_rec_wrt_off_type(i).batch_id;
615: arp_rw_batches_check_pkg.update_batch_status(l_batch_id);
616: i:=arp_process_writeoff.gt_rec_wrt_off_type.NEXT(i);
617: END LOOP;
618: END IF;

Line 616: i:=arp_process_writeoff.gt_rec_wrt_off_type.NEXT(i);

612: i := arp_process_writeoff.gt_rec_wrt_off_type.FIRST;
613: WHILE i IS NOT NULL LOOP
614: l_batch_id:=arp_process_writeoff.gt_rec_wrt_off_type(i).batch_id;
615: arp_rw_batches_check_pkg.update_batch_status(l_batch_id);
616: i:=arp_process_writeoff.gt_rec_wrt_off_type.NEXT(i);
617: END LOOP;
618: END IF;
619:
620: IF l_number_of_records_writtenoff > 0 THEN

Line 627: arp_process_writeoff.submit_report(l_receipt_currency_code,l_apply_date,l_gl_date);

623:
624: COMMIT;
625:
626: --for 1644863
627: arp_process_writeoff.submit_report(l_receipt_currency_code,l_apply_date,l_gl_date);
628: END IF;
629: END IF;
630: arp_util.debug('Total Number of Receipts written off :'||to_char(l_number_of_records_writtenoff));
631:

Line 632: arp_util.debug('arp_process_writeoff.creare_receipt_writeoff()-');

628: END IF;
629: END IF;
630: arp_util.debug('Total Number of Receipts written off :'||to_char(l_number_of_records_writtenoff));
631:
632: arp_util.debug('arp_process_writeoff.creare_receipt_writeoff()-');
633:
634: EXCEPTION
635: WHEN OTHERS THEN
636: arp_util.debug('EXCEPTION:arp_process_writeoff.cretre_receipt_writeoff()'||SQLERRM);

Line 636: arp_util.debug('EXCEPTION:arp_process_writeoff.cretre_receipt_writeoff()'||SQLERRM);

632: arp_util.debug('arp_process_writeoff.creare_receipt_writeoff()-');
633:
634: EXCEPTION
635: WHEN OTHERS THEN
636: arp_util.debug('EXCEPTION:arp_process_writeoff.cretre_receipt_writeoff()'||SQLERRM);
637: RAISE;
638:
639: END;
640: /*========================================================================

Line 647: | arp_process_writeoff.create_receipt_writeoff()

643: | DESCRIPTION
644: | This procedure calculates the unapplied amount for the given receipt
645: |
646: | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
647: | arp_process_writeoff.create_receipt_writeoff()
648: |
649: | CALLS PROCEDURES/FUNCTIONS (local to this package body)
650: | NONE
651: | PARAMETERS

Line 698: arp_util.debug('arp_process_writeoff.unapplied_amount()+');

694: l_amount_from NUMBER;
695: l_functional_currency ar_cash_receipts.currency_code%TYPE;
696:
697: BEGIN
698: arp_util.debug('arp_process_writeoff.unapplied_amount()+');
699: l_functional_currency := arp_global.functional_currency;
700:
701: IF nvl(p_request_id,0) = 0
702: THEN

Line 801: arp_util.debug('arp_process_writeoff.unapplied_amount()+');

797:
798: RETURN (l_unapp_amount_balance);
799: END IF;
800:
801: arp_util.debug('arp_process_writeoff.unapplied_amount()+');
802:
803: EXCEPTION
804: WHEN OTHERS THEN
805: arp_util.debug('EXCEPTION :arp_process_writeoff.unapplied_amount()'

Line 805: arp_util.debug('EXCEPTION :arp_process_writeoff.unapplied_amount()'

801: arp_util.debug('arp_process_writeoff.unapplied_amount()+');
802:
803: EXCEPTION
804: WHEN OTHERS THEN
805: arp_util.debug('EXCEPTION :arp_process_writeoff.unapplied_amount()'
806: ||SQLERRM);
807: RETURN (0);
808: END;
809: /*========================================================================

Line 816: | arp_process_writeoff.create_receipt_writeoff()

812: | DESCRIPTION
813: | This procedure calculates the applied amount for the given receipt
814: |
815: | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
816: | arp_process_writeoff.create_receipt_writeoff()
817: |
818: | CALLS PROCEDURES/FUNCTIONS (local to this package body)
819: | NONE
820: | PARAMETERS

Line 845: arp_util.debug('arp_process_writeoff.applied_amount()+');

841:
842: l_applied_amount NUMBER;
843:
844: BEGIN
845: arp_util.debug('arp_process_writeoff.applied_amount()+');
846:
847: IF NVL(p_request_id,0) <> 0
848: THEN
849: --Sum of the applied amount excluding the current one with the request id

Line 887: arp_util.debug('arp_process_writeoff.applied_amount()-');

883: ar_receivable_applications ra
884: WHERE ra.cash_receipt_id = p_cash_receipt_id;
885: END IF;
886:
887: arp_util.debug('arp_process_writeoff.applied_amount()-');
888: RETURN (l_applied_amount);
889:
890: EXCEPTION
891: WHEN OTHERS THEN

Line 892: arp_util.debug('EXCEPTION :arp_process_writeoff.applied_amount()'||SQLERRM);

888: RETURN (l_applied_amount);
889:
890: EXCEPTION
891: WHEN OTHERS THEN
892: arp_util.debug('EXCEPTION :arp_process_writeoff.applied_amount()'||SQLERRM);
893: RETURN (0);
894:
895: END;
896:

Line 928: arp_util.debug('arp_process_writeoff.on_account_amount()+');

924:
925: l_on_account_amount NUMBER;
926:
927: BEGIN
928: arp_util.debug('arp_process_writeoff.on_account_amount()+');
929:
930: SELECT
931: SUM(DECODE(ra.status,'ACC', NVL(ra.amount_applied, 0),
932: 0)) on_account_amount

Line 938: arp_util.debug('arp_process_writeoff.on_account_amount()-');

934: FROM
935: ar_receivable_applications ra
936: WHERE ra.cash_receipt_id = p_cash_receipt_id;
937:
938: arp_util.debug('arp_process_writeoff.on_account_amount()-');
939:
940: RETURN (l_on_account_amount);
941: EXCEPTION
942: WHEN OTHERS THEN

Line 943: arp_util.debug('arp_process_writeoff.on_account_amount() '||SQLERRM);

939:
940: RETURN (l_on_account_amount);
941: EXCEPTION
942: WHEN OTHERS THEN
943: arp_util.debug('arp_process_writeoff.on_account_amount() '||SQLERRM);
944: RETURN (0);
945:
946: END;
947:

Line 982: arp_util.debug('arp_process_writeoff.balancing_segment()+');

978: l_segment_value varchar2(25);
979:
980: BEGIN
981:
982: arp_util.debug('arp_process_writeoff.balancing_segment()+');
983:
984: SELECT fa_rx_flex_pkg.flex_sql(101,'GL#',chart_of_accounts_id,NULL,
985: 'SELECT','GL_BALANCING')
986: INTO l_balancing_segment

Line 995: arp_util.debug('arp_process_writeoff.balancing_segment()-');

991: FROM gl_code_combinations where code_combination_id=:bind_ccid';
992:
993: EXECUTE IMMEDIATE l_str INTO l_segment_value USING p_code_combination_id;
994:
995: arp_util.debug('arp_process_writeoff.balancing_segment()-');
996:
997: RETURN l_segment_value;
998:
999: EXCEPTION

Line 1001: arp_util.debug('arp_process_writeoff.balancing_segment() '||SQLERRM);

997: RETURN l_segment_value;
998:
999: EXCEPTION
1000: WHEN OTHERS THEN
1001: arp_util.debug('arp_process_writeoff.balancing_segment() '||SQLERRM);
1002: RETURN (NULL);
1003: END;
1004: BEGIN
1005: arp_global.init_global;

Line 1006: END ARP_PROCESS_WRITEOFF;

1002: RETURN (NULL);
1003: END;
1004: BEGIN
1005: arp_global.init_global;
1006: END ARP_PROCESS_WRITEOFF;