1: PACKAGE BODY arp_bf_bill AS
2: /* $Header: ARPBFBIB.pls 120.22.12010000.2 2008/10/01 07:04:13 rmanikan ship $ */
3:
4: -- define structure to store data that needs to be overridden
5: TYPE tab_trx_id IS TABLE OF ra_customer_trx.customer_trx_id%TYPE
2542: PROCEDURE Report( P_report IN ReportParametersType) Is
2543:
2544: BEGIN
2545:
2546: write_debug_and_log('arp_bf_bill.Report3(+)');
2547:
2548: IF P_report.print_option in ('DRAFT','FINAL') THEN
2549:
2550: generate(P_Report.print_option,
2598: P_report.request_id);
2599:
2600: END IF;
2601:
2602: write_debug_and_log('arp_bf_bill.Report3(-)');
2603:
2604: EXCEPTION
2605: WHEN OTHERS THEN
2606: write_debug_and_log( 'Exception: arp_bf_bill.Report3 :'||sqlerrm );
2602: write_debug_and_log('arp_bf_bill.Report3(-)');
2603:
2604: EXCEPTION
2605: WHEN OTHERS THEN
2606: write_debug_and_log( 'Exception: arp_bf_bill.Report3 :'||sqlerrm );
2607: RAISE_APPLICATION_ERROR( -20000, sqlerrm);
2608: END;
2609:
2610: -- overloaded procedure called for Accept / Reject
2631: from ar_system_parameters
2632: where org_id = nvl(p_org_id,org_id);
2633: BEGIN
2634:
2635: write_debug_and_log('arp_bf_bill.Report2 (+)');
2636:
2637: mo_global.init('AR');
2638:
2639: l_report.print_option := P_print_option;
2677:
2678: END LOOP;
2679:
2680: END IF;
2681: write_debug_and_log('arp_bf_bill.Report2 (-)');
2682:
2683: EXCEPTION
2684: WHEN OTHERS THEN
2685: write_debug_and_log( 'Exception:arp_bf_bill.Report2:'||sqlerrm);
2681: write_debug_and_log('arp_bf_bill.Report2 (-)');
2682:
2683: EXCEPTION
2684: WHEN OTHERS THEN
2685: write_debug_and_log( 'Exception:arp_bf_bill.Report2:'||sqlerrm);
2686: RAISE_APPLICATION_ERROR( -20000, sqlerrm);
2687: END;
2688:
2689:
2741: where org_id = nvl(p_org_id,org_id);
2742: BEGIN
2743:
2744: mo_global.init('AR');
2745: write_debug_and_log('arp_bf_bill.Report1 (+)');
2746:
2747: IF P_org_id is not null THEN
2748:
2749: write_debug_and_log('ORG ID : '||p_org_id);
2877: write_debug_and_log('... request ID is ' || to_char(l_request_id));
2878:
2879: END IF;
2880:
2881: write_debug_and_log('arp_bf_bill.Report1 (-)');
2882:
2883:
2884:
2885:
2884:
2885:
2886: EXCEPTION
2887: WHEN OTHERS THEN
2888: write_debug_and_log( 'Exception:arp_bf_bill.Report1:'||sqlerrm);
2889: RAISE_APPLICATION_ERROR( -20000, sqlerrm);
2890: END;
2891:
2892: END arp_bf_bill;
2888: write_debug_and_log( 'Exception:arp_bf_bill.Report1:'||sqlerrm);
2889: RAISE_APPLICATION_ERROR( -20000, sqlerrm);
2890: END;
2891:
2892: END arp_bf_bill;