1: PACKAGE BODY XLA_MULTIPERIOD_RPRTG_PKG AS
2: -- $Header: xlarpmpa.pkb 120.8.12020000.2 2012/07/23 07:02:24 vgopiset ship $
3: /*===========================================================================+
4: | Copyright (c) 2003 Oracle Corporation Belmont, California, USA |
5: | ALL rights reserved. |
7: | FILENAME |
8: | xlarpmpa.pkb |
9: | |
10: | PACKAGE NAME |
11: | xla_multiperiod_rprtg_pkg |
12: | |
13: | DESCRIPTION |
14: | This package calls XLA_MULTIPERIOD_ACCOUNTING_PKG.complete_ |
15: | journal_entries and generates the XML extract for reporting |
35: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
36: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
37: C_LEVEL_LOG_DISABLED CONSTANT NUMBER := 99;
38: C_DEFAULT_MODULE CONSTANT VARCHAR2(240)
39: := 'xla.plsql.xla_multiperiod_rprtg_pkg';
40:
41: g_log_level NUMBER;
42: g_log_enabled BOOLEAN;
43:
57: WHEN xla_exceptions_pkg.application_exception THEN
58: RAISE;
59: WHEN OTHERS THEN
60: xla_exceptions_pkg.raise_message
61: (p_location => 'xla_multiperiod_rprtg_pkg.trace');
62: END trace;
63:
64:
65:
72: WHEN xla_exceptions_pkg.application_exception THEN
73: RAISE;
74: WHEN OTHERS THEN
75: xla_exceptions_pkg.raise_message
76: (p_location => 'XLA_MULTIPERIOD_RPRTG_PKG.print_logfile');
77: END print_logfile;
78:
79: PROCEDURE build_xml_sql (p_accounting_batch_id IN NUMBER);
80:
177: EXCEPTION
178: WHEN OTHERS THEN
179: -- trace mesg
180: xla_exceptions_pkg.raise_message
181: (p_location => 'xla_multiperiod_rprtg_pkg.run_report ');
182: END run_report;
183:
184: FUNCTION get_transaction_id
185: (p_application_id IN NUMBER
422:
423: EXCEPTION
424: WHEN OTHERS THEN
425: xla_exceptions_pkg.raise_message
426: (p_location => 'xla_multiperiod_rprtg_pkg.get_transaction_id ');
427:
428: END get_transaction_id;
429:
430: PROCEDURE build_xml_sql (p_accounting_batch_id IN NUMBER) IS
443: ,p_level => C_LEVEL_PROCEDURE
444: ,p_module => l_log_module);
445: END IF;
446:
447: xla_multiperiod_rprtg_pkg.C_SUMMARY_QUERY :=
448: ' SELECT xec.event_class_code EVENT_CLASS_CODE
449: ,xec.name EVENT_CLASS
450: ,xgl.ledger_id LEDGER_ID
451: ,xgl.name LEDGER
482: AND lk2.lookup_code = ''B''
483: AND lk3.lookup_type = ''XLA_BALANCE_TYPE''
484: AND lk3.lookup_code = ''E'' ';
485:
486: xla_multiperiod_rprtg_pkg.xah_appl_filter := ' AND xah.application_id = '||
487: to_char(xla_multiperiod_rprtg_pkg.p_application_id);
488: xla_multiperiod_rprtg_pkg.xae_appl_filter := ' AND xae.application_id = '||
489: to_char(xla_multiperiod_rprtg_pkg.p_application_id);
490: xla_multiperiod_rprtg_pkg.ent_appl_filter := ' AND ent.application_id = '||
483: AND lk3.lookup_type = ''XLA_BALANCE_TYPE''
484: AND lk3.lookup_code = ''E'' ';
485:
486: xla_multiperiod_rprtg_pkg.xah_appl_filter := ' AND xah.application_id = '||
487: to_char(xla_multiperiod_rprtg_pkg.p_application_id);
488: xla_multiperiod_rprtg_pkg.xae_appl_filter := ' AND xae.application_id = '||
489: to_char(xla_multiperiod_rprtg_pkg.p_application_id);
490: xla_multiperiod_rprtg_pkg.ent_appl_filter := ' AND ent.application_id = '||
491: to_char(xla_multiperiod_rprtg_pkg.p_application_id);
484: AND lk3.lookup_code = ''E'' ';
485:
486: xla_multiperiod_rprtg_pkg.xah_appl_filter := ' AND xah.application_id = '||
487: to_char(xla_multiperiod_rprtg_pkg.p_application_id);
488: xla_multiperiod_rprtg_pkg.xae_appl_filter := ' AND xae.application_id = '||
489: to_char(xla_multiperiod_rprtg_pkg.p_application_id);
490: xla_multiperiod_rprtg_pkg.ent_appl_filter := ' AND ent.application_id = '||
491: to_char(xla_multiperiod_rprtg_pkg.p_application_id);
492: xla_multiperiod_rprtg_pkg.xal_appl_filter := ' AND xal.application_id = '||
485:
486: xla_multiperiod_rprtg_pkg.xah_appl_filter := ' AND xah.application_id = '||
487: to_char(xla_multiperiod_rprtg_pkg.p_application_id);
488: xla_multiperiod_rprtg_pkg.xae_appl_filter := ' AND xae.application_id = '||
489: to_char(xla_multiperiod_rprtg_pkg.p_application_id);
490: xla_multiperiod_rprtg_pkg.ent_appl_filter := ' AND ent.application_id = '||
491: to_char(xla_multiperiod_rprtg_pkg.p_application_id);
492: xla_multiperiod_rprtg_pkg.xal_appl_filter := ' AND xal.application_id = '||
493: to_char(xla_multiperiod_rprtg_pkg.p_application_id);
486: xla_multiperiod_rprtg_pkg.xah_appl_filter := ' AND xah.application_id = '||
487: to_char(xla_multiperiod_rprtg_pkg.p_application_id);
488: xla_multiperiod_rprtg_pkg.xae_appl_filter := ' AND xae.application_id = '||
489: to_char(xla_multiperiod_rprtg_pkg.p_application_id);
490: xla_multiperiod_rprtg_pkg.ent_appl_filter := ' AND ent.application_id = '||
491: to_char(xla_multiperiod_rprtg_pkg.p_application_id);
492: xla_multiperiod_rprtg_pkg.xal_appl_filter := ' AND xal.application_id = '||
493: to_char(xla_multiperiod_rprtg_pkg.p_application_id);
494:
487: to_char(xla_multiperiod_rprtg_pkg.p_application_id);
488: xla_multiperiod_rprtg_pkg.xae_appl_filter := ' AND xae.application_id = '||
489: to_char(xla_multiperiod_rprtg_pkg.p_application_id);
490: xla_multiperiod_rprtg_pkg.ent_appl_filter := ' AND ent.application_id = '||
491: to_char(xla_multiperiod_rprtg_pkg.p_application_id);
492: xla_multiperiod_rprtg_pkg.xal_appl_filter := ' AND xal.application_id = '||
493: to_char(xla_multiperiod_rprtg_pkg.p_application_id);
494:
495: xla_multiperiod_rprtg_pkg.acct_batch_filter := ' AND xah.accounting_batch_id = '||
488: xla_multiperiod_rprtg_pkg.xae_appl_filter := ' AND xae.application_id = '||
489: to_char(xla_multiperiod_rprtg_pkg.p_application_id);
490: xla_multiperiod_rprtg_pkg.ent_appl_filter := ' AND ent.application_id = '||
491: to_char(xla_multiperiod_rprtg_pkg.p_application_id);
492: xla_multiperiod_rprtg_pkg.xal_appl_filter := ' AND xal.application_id = '||
493: to_char(xla_multiperiod_rprtg_pkg.p_application_id);
494:
495: xla_multiperiod_rprtg_pkg.acct_batch_filter := ' AND xah.accounting_batch_id = '||
496: to_char(p_accounting_batch_id);
489: to_char(xla_multiperiod_rprtg_pkg.p_application_id);
490: xla_multiperiod_rprtg_pkg.ent_appl_filter := ' AND ent.application_id = '||
491: to_char(xla_multiperiod_rprtg_pkg.p_application_id);
492: xla_multiperiod_rprtg_pkg.xal_appl_filter := ' AND xal.application_id = '||
493: to_char(xla_multiperiod_rprtg_pkg.p_application_id);
494:
495: xla_multiperiod_rprtg_pkg.acct_batch_filter := ' AND xah.accounting_batch_id = '||
496: to_char(p_accounting_batch_id);
497:
491: to_char(xla_multiperiod_rprtg_pkg.p_application_id);
492: xla_multiperiod_rprtg_pkg.xal_appl_filter := ' AND xal.application_id = '||
493: to_char(xla_multiperiod_rprtg_pkg.p_application_id);
494:
495: xla_multiperiod_rprtg_pkg.acct_batch_filter := ' AND xah.accounting_batch_id = '||
496: to_char(p_accounting_batch_id);
497:
498: xla_multiperiod_rprtg_pkg.C_TRANSFER_QUERY :=
499: ' SELECT xgl.name LEDGER
494:
495: xla_multiperiod_rprtg_pkg.acct_batch_filter := ' AND xah.accounting_batch_id = '||
496: to_char(p_accounting_batch_id);
497:
498: xla_multiperiod_rprtg_pkg.C_TRANSFER_QUERY :=
499: ' SELECT xgl.name LEDGER
500: ,xgl.ledger_id LEDGER_ID
501: ,lk1.meaning ACTUAL
502: ,lk2.meaning BUDGET
520: AND lk2.lookup_code = ''B''
521: AND lk3.lookup_type = ''XLA_BALANCE_TYPE''
522: AND lk3.lookup_code = ''E'' ';
523:
524: xla_multiperiod_rprtg_pkg.C_GENERAL_ERRORS_QUERY :=
525: ' SELECT ERR.MESSAGE_NUMBER ERROR_NO
526: ,ERR.ENCODED_MSG ERROR_MSG
527: ,ERR.AE_LINE_NUM LINE_NUM
528: FROM XLA_ACCOUNTING_ERRORS ERR
529: ,XLA_AE_HEADERS XAH
530: WHERE err.ae_header_id = xah.ae_header_id
531: AND err.application_id = xah.application_id ';
532:
533: xla_multiperiod_rprtg_pkg.C_RECOGNITION_COLS_QUERY :=
534: ' SELECT xah.event_id event_id
535: ,xec.name event_class
536: ,xet.name event_type
537: ,xae.event_number event_number
569: total_accted_debits
570: ,sum(xal.accounted_cr) over (partition by xal.ae_header_id)
571: total_accted_credits ';
572:
573: xla_multiperiod_rprtg_pkg.C_RECOGNITION_FROM_QUERY :=
574: ' FROM xla_ae_headers xah
575: ,xla_events xae
576: ,xla_event_types_tl xet
577: ,xla_event_classes_tl xec
585: ,fnd_document_sequences seq
586: ,fun_seq_versions seqv2
587: ,fun_seq_versions seqv3 ';
588:
589: xla_multiperiod_rprtg_pkg.C_RECOGNITION_WHR_QUERY :=
590: ' WHERE xec.application_id = xet.application_id
591: AND xec.event_class_code = xet.event_class_code
592: AND xec.language = USERENV(''LANG'')
593: AND ent.application_id = xet.application_id
618: AND xah.accounting_entry_status_code in (''D'',''F'')
619: AND xah.parent_ae_header_id IS NOT NULL
620: AND xah.parent_ae_line_num IS NOT NULL ';
621:
622: xla_multiperiod_rprtg_pkg.C_ACCRUAL_RVRSL_COLS_QUERY :=
623: ' SELECT xah.event_id event_id
624: ,xec.name event_class
625: ,xet.name event_type
626: ,xae.event_number event_number
658: total_accted_debits
659: ,sum(xal.accounted_cr) over (partition by xal.ae_header_id)
660: total_accted_credits ';
661:
662: xla_multiperiod_rprtg_pkg.C_ACCRUAL_RVRSL_FROM_QUERY :=
663: ' FROM xla_ae_headers xah
664: ,xla_events xae
665: ,xla_event_types_tl xet
666: ,xla_event_classes_tl xec
674: ,fnd_document_sequences seq
675: ,fun_seq_versions seqv2
676: ,fun_seq_versions seqv3 ';
677:
678: xla_multiperiod_rprtg_pkg.C_ACCRUAL_RVRSL_WHR_QUERY :=
679: ' WHERE xec.application_id = xet.application_id
680: AND xec.event_class_code = xet.event_class_code
681: AND xec.language = USERENV(''LANG'')
682: AND ent.application_id = xet.application_id
707: AND xah.accounting_entry_status_code in (''D'',''F'')
708: AND xah.parent_ae_header_id IS NOT NULL
709: AND xah.parent_ae_line_num IS NULL ';
710:
711: xla_multiperiod_rprtg_pkg.C_ERRORS_COLS_QUERY :=
712: ' SELECT xah.event_id event_id
713: ,xec.name event_class
714: ,xet.name event_type
715: ,xae.event_number event_number
749: total_accted_credits
750: ,err.message_number error_number
751: ,err.encoded_msg error_message ';
752:
753: xla_multiperiod_rprtg_pkg.C_ERRORS_FROM_QUERY :=
754: ' FROM xla_ae_headers xah
755: ,xla_events xae
756: ,xla_event_types_tl xet
757: ,xla_event_classes_tl xec
766: ,fun_seq_versions seqv2
767: ,fun_seq_versions seqv3
768: ,xla_accounting_errors err ';
769:
770: xla_multiperiod_rprtg_pkg.C_ERRORS_WHR_QUERY :=
771: ' WHERE xec.application_id = xet.application_id
772: AND xec.event_class_code = xet.event_class_code
773: AND xec.language = USERENV(''LANG'')
774: AND ent.application_id = xet.application_id
809: AND xah.accounting_entry_status_code NOT IN (''D'',''F'')
810: AND xah.parent_ae_header_id IS NOT NULL ';
811:
812: IF p_report = 'D' THEN
813: xla_multiperiod_rprtg_pkg.p_trx_identifiers := get_transaction_id(xla_multiperiod_rprtg_pkg.p_application_id
814: ,xla_multiperiod_rprtg_pkg.p_ledger_id
815: ,xla_multiperiod_rprtg_pkg.p_end_date
816: ,xla_multiperiod_rprtg_pkg.p_process_category_code)
817: ||' USERIDS ';
810: AND xah.parent_ae_header_id IS NOT NULL ';
811:
812: IF p_report = 'D' THEN
813: xla_multiperiod_rprtg_pkg.p_trx_identifiers := get_transaction_id(xla_multiperiod_rprtg_pkg.p_application_id
814: ,xla_multiperiod_rprtg_pkg.p_ledger_id
815: ,xla_multiperiod_rprtg_pkg.p_end_date
816: ,xla_multiperiod_rprtg_pkg.p_process_category_code)
817: ||' USERIDS ';
818: ELSE
811:
812: IF p_report = 'D' THEN
813: xla_multiperiod_rprtg_pkg.p_trx_identifiers := get_transaction_id(xla_multiperiod_rprtg_pkg.p_application_id
814: ,xla_multiperiod_rprtg_pkg.p_ledger_id
815: ,xla_multiperiod_rprtg_pkg.p_end_date
816: ,xla_multiperiod_rprtg_pkg.p_process_category_code)
817: ||' USERIDS ';
818: ELSE
819: xla_multiperiod_rprtg_pkg.p_trx_identifiers := ',CASE WHEN 1<1 THEN NULL END USERIDS ';
812: IF p_report = 'D' THEN
813: xla_multiperiod_rprtg_pkg.p_trx_identifiers := get_transaction_id(xla_multiperiod_rprtg_pkg.p_application_id
814: ,xla_multiperiod_rprtg_pkg.p_ledger_id
815: ,xla_multiperiod_rprtg_pkg.p_end_date
816: ,xla_multiperiod_rprtg_pkg.p_process_category_code)
817: ||' USERIDS ';
818: ELSE
819: xla_multiperiod_rprtg_pkg.p_trx_identifiers := ',CASE WHEN 1<1 THEN NULL END USERIDS ';
820: END IF;
815: ,xla_multiperiod_rprtg_pkg.p_end_date
816: ,xla_multiperiod_rprtg_pkg.p_process_category_code)
817: ||' USERIDS ';
818: ELSE
819: xla_multiperiod_rprtg_pkg.p_trx_identifiers := ',CASE WHEN 1<1 THEN NULL END USERIDS ';
820: END IF;
821:
822: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
823: trace('build_xml_sql.End'
831: ,C_LEVEL_PROCEDURE, l_log_module);
832: END IF;
833: xla_exceptions_pkg.raise_message
834: (p_location =>
835: 'xla_multiperiod_rprtg_pkg.build_xml_sql');
836: END build_xml_sql;
837:
838:
839: FUNCTION beforeReport RETURN BOOLEAN IS
882: END IF;
883:
884: run_report(p_errbuf => l_errbuf
885: ,p_retcode => C_RETURN_CODE
886: ,p_application_id => xla_multiperiod_rprtg_pkg.p_application_id
887: ,p_ledger_id => xla_multiperiod_rprtg_pkg.p_ledger_id
888: ,p_process_category_code => xla_multiperiod_rprtg_pkg.p_process_category_code
889: ,p_end_date => xla_multiperiod_rprtg_pkg.p_end_date
890: ,p_errors_only_flag => xla_multiperiod_rprtg_pkg.p_errors_only
883:
884: run_report(p_errbuf => l_errbuf
885: ,p_retcode => C_RETURN_CODE
886: ,p_application_id => xla_multiperiod_rprtg_pkg.p_application_id
887: ,p_ledger_id => xla_multiperiod_rprtg_pkg.p_ledger_id
888: ,p_process_category_code => xla_multiperiod_rprtg_pkg.p_process_category_code
889: ,p_end_date => xla_multiperiod_rprtg_pkg.p_end_date
890: ,p_errors_only_flag => xla_multiperiod_rprtg_pkg.p_errors_only
891: ,p_transfer_to_gl_flag => xla_multiperiod_rprtg_pkg.p_transfer_to_gl
884: run_report(p_errbuf => l_errbuf
885: ,p_retcode => C_RETURN_CODE
886: ,p_application_id => xla_multiperiod_rprtg_pkg.p_application_id
887: ,p_ledger_id => xla_multiperiod_rprtg_pkg.p_ledger_id
888: ,p_process_category_code => xla_multiperiod_rprtg_pkg.p_process_category_code
889: ,p_end_date => xla_multiperiod_rprtg_pkg.p_end_date
890: ,p_errors_only_flag => xla_multiperiod_rprtg_pkg.p_errors_only
891: ,p_transfer_to_gl_flag => xla_multiperiod_rprtg_pkg.p_transfer_to_gl
892: ,p_post_in_gl_flag => xla_multiperiod_rprtg_pkg.p_post_in_gl
885: ,p_retcode => C_RETURN_CODE
886: ,p_application_id => xla_multiperiod_rprtg_pkg.p_application_id
887: ,p_ledger_id => xla_multiperiod_rprtg_pkg.p_ledger_id
888: ,p_process_category_code => xla_multiperiod_rprtg_pkg.p_process_category_code
889: ,p_end_date => xla_multiperiod_rprtg_pkg.p_end_date
890: ,p_errors_only_flag => xla_multiperiod_rprtg_pkg.p_errors_only
891: ,p_transfer_to_gl_flag => xla_multiperiod_rprtg_pkg.p_transfer_to_gl
892: ,p_post_in_gl_flag => xla_multiperiod_rprtg_pkg.p_post_in_gl
893: ,p_gl_batch_name => xla_multiperiod_rprtg_pkg.p_gl_batch_name
886: ,p_application_id => xla_multiperiod_rprtg_pkg.p_application_id
887: ,p_ledger_id => xla_multiperiod_rprtg_pkg.p_ledger_id
888: ,p_process_category_code => xla_multiperiod_rprtg_pkg.p_process_category_code
889: ,p_end_date => xla_multiperiod_rprtg_pkg.p_end_date
890: ,p_errors_only_flag => xla_multiperiod_rprtg_pkg.p_errors_only
891: ,p_transfer_to_gl_flag => xla_multiperiod_rprtg_pkg.p_transfer_to_gl
892: ,p_post_in_gl_flag => xla_multiperiod_rprtg_pkg.p_post_in_gl
893: ,p_gl_batch_name => xla_multiperiod_rprtg_pkg.p_gl_batch_name
894: ,p_valuation_method_code => xla_multiperiod_rprtg_pkg.p_valuation_method_code
887: ,p_ledger_id => xla_multiperiod_rprtg_pkg.p_ledger_id
888: ,p_process_category_code => xla_multiperiod_rprtg_pkg.p_process_category_code
889: ,p_end_date => xla_multiperiod_rprtg_pkg.p_end_date
890: ,p_errors_only_flag => xla_multiperiod_rprtg_pkg.p_errors_only
891: ,p_transfer_to_gl_flag => xla_multiperiod_rprtg_pkg.p_transfer_to_gl
892: ,p_post_in_gl_flag => xla_multiperiod_rprtg_pkg.p_post_in_gl
893: ,p_gl_batch_name => xla_multiperiod_rprtg_pkg.p_gl_batch_name
894: ,p_valuation_method_code => xla_multiperiod_rprtg_pkg.p_valuation_method_code
895: ,p_security_int_1 => xla_multiperiod_rprtg_pkg.p_security_int_1
888: ,p_process_category_code => xla_multiperiod_rprtg_pkg.p_process_category_code
889: ,p_end_date => xla_multiperiod_rprtg_pkg.p_end_date
890: ,p_errors_only_flag => xla_multiperiod_rprtg_pkg.p_errors_only
891: ,p_transfer_to_gl_flag => xla_multiperiod_rprtg_pkg.p_transfer_to_gl
892: ,p_post_in_gl_flag => xla_multiperiod_rprtg_pkg.p_post_in_gl
893: ,p_gl_batch_name => xla_multiperiod_rprtg_pkg.p_gl_batch_name
894: ,p_valuation_method_code => xla_multiperiod_rprtg_pkg.p_valuation_method_code
895: ,p_security_int_1 => xla_multiperiod_rprtg_pkg.p_security_int_1
896: ,p_security_int_2 => xla_multiperiod_rprtg_pkg.p_security_int_2
889: ,p_end_date => xla_multiperiod_rprtg_pkg.p_end_date
890: ,p_errors_only_flag => xla_multiperiod_rprtg_pkg.p_errors_only
891: ,p_transfer_to_gl_flag => xla_multiperiod_rprtg_pkg.p_transfer_to_gl
892: ,p_post_in_gl_flag => xla_multiperiod_rprtg_pkg.p_post_in_gl
893: ,p_gl_batch_name => xla_multiperiod_rprtg_pkg.p_gl_batch_name
894: ,p_valuation_method_code => xla_multiperiod_rprtg_pkg.p_valuation_method_code
895: ,p_security_int_1 => xla_multiperiod_rprtg_pkg.p_security_int_1
896: ,p_security_int_2 => xla_multiperiod_rprtg_pkg.p_security_int_2
897: ,p_security_int_3 => xla_multiperiod_rprtg_pkg.p_security_int_3
890: ,p_errors_only_flag => xla_multiperiod_rprtg_pkg.p_errors_only
891: ,p_transfer_to_gl_flag => xla_multiperiod_rprtg_pkg.p_transfer_to_gl
892: ,p_post_in_gl_flag => xla_multiperiod_rprtg_pkg.p_post_in_gl
893: ,p_gl_batch_name => xla_multiperiod_rprtg_pkg.p_gl_batch_name
894: ,p_valuation_method_code => xla_multiperiod_rprtg_pkg.p_valuation_method_code
895: ,p_security_int_1 => xla_multiperiod_rprtg_pkg.p_security_int_1
896: ,p_security_int_2 => xla_multiperiod_rprtg_pkg.p_security_int_2
897: ,p_security_int_3 => xla_multiperiod_rprtg_pkg.p_security_int_3
898: ,p_security_char_1 => xla_multiperiod_rprtg_pkg.p_security_char_1
891: ,p_transfer_to_gl_flag => xla_multiperiod_rprtg_pkg.p_transfer_to_gl
892: ,p_post_in_gl_flag => xla_multiperiod_rprtg_pkg.p_post_in_gl
893: ,p_gl_batch_name => xla_multiperiod_rprtg_pkg.p_gl_batch_name
894: ,p_valuation_method_code => xla_multiperiod_rprtg_pkg.p_valuation_method_code
895: ,p_security_int_1 => xla_multiperiod_rprtg_pkg.p_security_int_1
896: ,p_security_int_2 => xla_multiperiod_rprtg_pkg.p_security_int_2
897: ,p_security_int_3 => xla_multiperiod_rprtg_pkg.p_security_int_3
898: ,p_security_char_1 => xla_multiperiod_rprtg_pkg.p_security_char_1
899: ,p_security_char_2 => xla_multiperiod_rprtg_pkg.p_security_char_2
892: ,p_post_in_gl_flag => xla_multiperiod_rprtg_pkg.p_post_in_gl
893: ,p_gl_batch_name => xla_multiperiod_rprtg_pkg.p_gl_batch_name
894: ,p_valuation_method_code => xla_multiperiod_rprtg_pkg.p_valuation_method_code
895: ,p_security_int_1 => xla_multiperiod_rprtg_pkg.p_security_int_1
896: ,p_security_int_2 => xla_multiperiod_rprtg_pkg.p_security_int_2
897: ,p_security_int_3 => xla_multiperiod_rprtg_pkg.p_security_int_3
898: ,p_security_char_1 => xla_multiperiod_rprtg_pkg.p_security_char_1
899: ,p_security_char_2 => xla_multiperiod_rprtg_pkg.p_security_char_2
900: ,p_security_char_3 => xla_multiperiod_rprtg_pkg.p_security_char_3);
893: ,p_gl_batch_name => xla_multiperiod_rprtg_pkg.p_gl_batch_name
894: ,p_valuation_method_code => xla_multiperiod_rprtg_pkg.p_valuation_method_code
895: ,p_security_int_1 => xla_multiperiod_rprtg_pkg.p_security_int_1
896: ,p_security_int_2 => xla_multiperiod_rprtg_pkg.p_security_int_2
897: ,p_security_int_3 => xla_multiperiod_rprtg_pkg.p_security_int_3
898: ,p_security_char_1 => xla_multiperiod_rprtg_pkg.p_security_char_1
899: ,p_security_char_2 => xla_multiperiod_rprtg_pkg.p_security_char_2
900: ,p_security_char_3 => xla_multiperiod_rprtg_pkg.p_security_char_3);
901:
894: ,p_valuation_method_code => xla_multiperiod_rprtg_pkg.p_valuation_method_code
895: ,p_security_int_1 => xla_multiperiod_rprtg_pkg.p_security_int_1
896: ,p_security_int_2 => xla_multiperiod_rprtg_pkg.p_security_int_2
897: ,p_security_int_3 => xla_multiperiod_rprtg_pkg.p_security_int_3
898: ,p_security_char_1 => xla_multiperiod_rprtg_pkg.p_security_char_1
899: ,p_security_char_2 => xla_multiperiod_rprtg_pkg.p_security_char_2
900: ,p_security_char_3 => xla_multiperiod_rprtg_pkg.p_security_char_3);
901:
902: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
895: ,p_security_int_1 => xla_multiperiod_rprtg_pkg.p_security_int_1
896: ,p_security_int_2 => xla_multiperiod_rprtg_pkg.p_security_int_2
897: ,p_security_int_3 => xla_multiperiod_rprtg_pkg.p_security_int_3
898: ,p_security_char_1 => xla_multiperiod_rprtg_pkg.p_security_char_1
899: ,p_security_char_2 => xla_multiperiod_rprtg_pkg.p_security_char_2
900: ,p_security_char_3 => xla_multiperiod_rprtg_pkg.p_security_char_3);
901:
902: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
903: trace('C_RETURN_CODE = '||C_RETURN_CODE,C_LEVEL_STATEMENT ,l_log_module);
896: ,p_security_int_2 => xla_multiperiod_rprtg_pkg.p_security_int_2
897: ,p_security_int_3 => xla_multiperiod_rprtg_pkg.p_security_int_3
898: ,p_security_char_1 => xla_multiperiod_rprtg_pkg.p_security_char_1
899: ,p_security_char_2 => xla_multiperiod_rprtg_pkg.p_security_char_2
900: ,p_security_char_3 => xla_multiperiod_rprtg_pkg.p_security_char_3);
901:
902: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
903: trace('C_RETURN_CODE = '||C_RETURN_CODE,C_LEVEL_STATEMENT ,l_log_module);
904: trace('beforeReport.End'
909:
910: EXCEPTION
911: WHEN OTHERS THEN
912: xla_exceptions_pkg.raise_message
913: (p_location => 'xla_multiperiod_rprtg_pkg.beforeReport ');
914:
915: END beforeReport;
916:
917: FUNCTION AfterReport RETURN BOOLEAN IS
947:
948: EXCEPTION
949: WHEN OTHERS THEN
950: xla_exceptions_pkg.raise_message
951: (p_location => 'xla_multiperiod_rprtg_pkg.AfterReport');
952:
953: END afterReport;
954:
955: BEGIN
960:
961: IF NOT g_log_enabled THEN
962: g_log_level := C_LEVEL_LOG_DISABLED;
963: END IF;
964: END xla_multiperiod_rprtg_pkg;