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

Line 1: PACKAGE BODY XLA_PERIOD_CLOSE_EXP_PKG AS

1: PACKAGE BODY XLA_PERIOD_CLOSE_EXP_PKG AS
2: -- $Header: xlarppcl.pkb 120.38.12010000.1 2008/07/29 10:06:51 appldev ship $
3: /*===========================================================================+
4: | Copyright (c) 2003 Oracle Corporation Belmont, California, USA |
5: | ALL rights reserved. |

Line 11: | xla_period_close_exp_pkg |

7: | FILENAME |
8: | xlarppcl.pkb |
9: | |
10: | PACKAGE NAME |
11: | xla_period_close_exp_pkg |
12: | |
13: | DESCRIPTION |
14: | This package generates an XML extract for the Period Close Validation |
15: | program unit. A dynamic query is created based on the parameters that are |

Line 52: := 'xla.plsql.xla_period_close_exp_pkg';

48: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
49: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
50: C_LEVEL_LOG_DISABLED CONSTANT NUMBER := 99;
51: C_DEFAULT_MODULE CONSTANT VARCHAR2(240)
52: := 'xla.plsql.xla_period_close_exp_pkg';
53:
54: g_log_level NUMBER;
55: g_log_enabled BOOLEAN;
56: g_use_ledger_security VARCHAR2(1) :=

Line 95: (p_location => 'xla_period_close_exp_pkg.trace');

91: WHEN xla_exceptions_pkg.application_exception THEN
92: RAISE;
93: WHEN OTHERS THEN
94: xla_exceptions_pkg.raise_message
95: (p_location => 'xla_period_close_exp_pkg.trace');
96: END trace;
97:
98: --=============================================================================
99: -- *********** public procedures and functions **********

Line 180: (p_location => 'xla_period_close_exp_pkg.run_report ');

176: EXCEPTION
177: WHEN OTHERS THEN
178:
179: xla_exceptions_pkg.raise_message
180: (p_location => 'xla_period_close_exp_pkg.run_report ');
181: END run_report;
182:
183:
184: --------------------------------------------------------------------

Line 374: (p_location => 'xla_period_close_exp_pkg.param_list_sql');

370: EXCEPTION
371: WHEN OTHERS THEN
372: -- trace mesg
373: xla_exceptions_pkg.raise_message
374: (p_location => 'xla_period_close_exp_pkg.param_list_sql');
375: END param_list_sql;
376:
377: PROCEDURE get_period_start_end_dates
378: ( p_ledger_id IN NUMBER

Line 438: 'xla_period_close_exp_pkg.get_period_start_end_dates');

434: ,C_LEVEL_PROCEDURE, l_log_module);
435: END IF;
436: xla_exceptions_pkg.raise_message
437: (p_location =>
438: 'xla_period_close_exp_pkg.get_period_start_end_dates');
439: END get_period_start_end_dates ;
440:
441:
442: PROCEDURE build_xml_sql IS

Line 646: 'xla_period_close_exp_pkg.build_xml_sql');

642: ,C_LEVEL_PROCEDURE, l_log_module);
643: END IF;
644: xla_exceptions_pkg.raise_message
645: (p_location =>
646: 'xla_period_close_exp_pkg.build_xml_sql');
647: END build_xml_sql;
648:
649: --changed Function get_transaction_id returning varchar2 to a procedure preeti/6204675
650:

Line 1037: (p_location => 'xla_period_close_exp_pkg.get_transaction_id ');

1033:
1034: EXCEPTION
1035: WHEN OTHERS THEN
1036: xla_exceptions_pkg.raise_message
1037: (p_location => 'xla_period_close_exp_pkg.get_transaction_id ');
1038:
1039: END get_transaction_id;
1040:
1041:

Line 1149: (p_location => 'xla_period_close_exp_pkg.get_ledger_ids');

1145: RETURN l_ledger_ids;
1146: EXCEPTION
1147: WHEN OTHERS THEN
1148: xla_exceptions_pkg.raise_message
1149: (p_location => 'xla_period_close_exp_pkg.get_ledger_ids');
1150: END get_ledger_ids;
1151:
1152: PROCEDURE build_query_sql
1153: (p_application_id IN NUMBER

Line 1339: xla_period_close_exp_pkg.p_ledger_ids := l_ledger_ids;

1335:
1336:
1337:
1338:
1339: xla_period_close_exp_pkg.p_ledger_ids := l_ledger_ids;
1340: xla_period_close_exp_pkg.p_event_filter := l_event_filter;
1341: xla_period_close_exp_pkg.p_header_filter := l_header_filter;
1342: xla_period_close_exp_pkg.p_je_source_filter := l_je_source_filter;
1343: xla_period_close_exp_pkg.p_object_type_code := p_object_type_code;

Line 1340: xla_period_close_exp_pkg.p_event_filter := l_event_filter;

1336:
1337:
1338:
1339: xla_period_close_exp_pkg.p_ledger_ids := l_ledger_ids;
1340: xla_period_close_exp_pkg.p_event_filter := l_event_filter;
1341: xla_period_close_exp_pkg.p_header_filter := l_header_filter;
1342: xla_period_close_exp_pkg.p_je_source_filter := l_je_source_filter;
1343: xla_period_close_exp_pkg.p_object_type_code := p_object_type_code;
1344: xla_period_close_exp_pkg.p_je_source_name := p_je_source_name;

Line 1341: xla_period_close_exp_pkg.p_header_filter := l_header_filter;

1337:
1338:
1339: xla_period_close_exp_pkg.p_ledger_ids := l_ledger_ids;
1340: xla_period_close_exp_pkg.p_event_filter := l_event_filter;
1341: xla_period_close_exp_pkg.p_header_filter := l_header_filter;
1342: xla_period_close_exp_pkg.p_je_source_filter := l_je_source_filter;
1343: xla_period_close_exp_pkg.p_object_type_code := p_object_type_code;
1344: xla_period_close_exp_pkg.p_je_source_name := p_je_source_name;
1345:

Line 1342: xla_period_close_exp_pkg.p_je_source_filter := l_je_source_filter;

1338:
1339: xla_period_close_exp_pkg.p_ledger_ids := l_ledger_ids;
1340: xla_period_close_exp_pkg.p_event_filter := l_event_filter;
1341: xla_period_close_exp_pkg.p_header_filter := l_header_filter;
1342: xla_period_close_exp_pkg.p_je_source_filter := l_je_source_filter;
1343: xla_period_close_exp_pkg.p_object_type_code := p_object_type_code;
1344: xla_period_close_exp_pkg.p_je_source_name := p_je_source_name;
1345:
1346: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN

Line 1343: xla_period_close_exp_pkg.p_object_type_code := p_object_type_code;

1339: xla_period_close_exp_pkg.p_ledger_ids := l_ledger_ids;
1340: xla_period_close_exp_pkg.p_event_filter := l_event_filter;
1341: xla_period_close_exp_pkg.p_header_filter := l_header_filter;
1342: xla_period_close_exp_pkg.p_je_source_filter := l_je_source_filter;
1343: xla_period_close_exp_pkg.p_object_type_code := p_object_type_code;
1344: xla_period_close_exp_pkg.p_je_source_name := p_je_source_name;
1345:
1346: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
1347: trace('build_query_sql.End'

Line 1344: xla_period_close_exp_pkg.p_je_source_name := p_je_source_name;

1340: xla_period_close_exp_pkg.p_event_filter := l_event_filter;
1341: xla_period_close_exp_pkg.p_header_filter := l_header_filter;
1342: xla_period_close_exp_pkg.p_je_source_filter := l_je_source_filter;
1343: xla_period_close_exp_pkg.p_object_type_code := p_object_type_code;
1344: xla_period_close_exp_pkg.p_je_source_name := p_je_source_name;
1345:
1346: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
1347: trace('build_query_sql.End'
1348: ,C_LEVEL_PROCEDURE, l_log_module);

Line 1356: (p_location => 'xla_period_close_exp_pkg.build_query_sql');

1352: WHEN NO_DATA_FOUND THEN
1353: NULL;
1354: WHEN OTHERS THEN
1355: xla_exceptions_pkg.raise_message
1356: (p_location => 'xla_period_close_exp_pkg.build_query_sql');
1357: END build_query_sql ;
1358:
1359: FUNCTION check_period_close(p_application_id IN NUMBER
1360: ,p_period_name IN VARCHAR2

Line 1539: (p_location => 'xla_period_close_exp_pkg.check_period_close');

1535: RETURN l_unprocessed;
1536: EXCEPTION
1537: WHEN OTHERS THEN
1538: xla_exceptions_pkg.raise_message
1539: (p_location => 'xla_period_close_exp_pkg.check_period_close');
1540:
1541: END check_period_close;
1542:
1543: FUNCTION beforeReport RETURN BOOLEAN IS

Line 1586: ,p_retcode => xla_period_close_exp_pkg.C_RETURN_CODE

1582: C_LEVEL_STATEMENT, l_log_module);
1583: END IF;
1584:
1585: run_report(p_errbuf => l_errbuf
1586: ,p_retcode => xla_period_close_exp_pkg.C_RETURN_CODE
1587: ,p_application_id => xla_period_close_exp_pkg.p_application_id
1588: ,p_ledger_id => xla_period_close_exp_pkg.p_ledger_id
1589: ,p_period_from => xla_period_close_exp_pkg.p_period_from
1590: ,p_period_to => xla_period_close_exp_pkg.p_period_to

Line 1587: ,p_application_id => xla_period_close_exp_pkg.p_application_id

1583: END IF;
1584:
1585: run_report(p_errbuf => l_errbuf
1586: ,p_retcode => xla_period_close_exp_pkg.C_RETURN_CODE
1587: ,p_application_id => xla_period_close_exp_pkg.p_application_id
1588: ,p_ledger_id => xla_period_close_exp_pkg.p_ledger_id
1589: ,p_period_from => xla_period_close_exp_pkg.p_period_from
1590: ,p_period_to => xla_period_close_exp_pkg.p_period_to
1591: ,p_event_class => xla_period_close_exp_pkg.p_event_class_code

Line 1588: ,p_ledger_id => xla_period_close_exp_pkg.p_ledger_id

1584:
1585: run_report(p_errbuf => l_errbuf
1586: ,p_retcode => xla_period_close_exp_pkg.C_RETURN_CODE
1587: ,p_application_id => xla_period_close_exp_pkg.p_application_id
1588: ,p_ledger_id => xla_period_close_exp_pkg.p_ledger_id
1589: ,p_period_from => xla_period_close_exp_pkg.p_period_from
1590: ,p_period_to => xla_period_close_exp_pkg.p_period_to
1591: ,p_event_class => xla_period_close_exp_pkg.p_event_class_code
1592: ,p_je_category => xla_period_close_exp_pkg.p_je_category_name

Line 1589: ,p_period_from => xla_period_close_exp_pkg.p_period_from

1585: run_report(p_errbuf => l_errbuf
1586: ,p_retcode => xla_period_close_exp_pkg.C_RETURN_CODE
1587: ,p_application_id => xla_period_close_exp_pkg.p_application_id
1588: ,p_ledger_id => xla_period_close_exp_pkg.p_ledger_id
1589: ,p_period_from => xla_period_close_exp_pkg.p_period_from
1590: ,p_period_to => xla_period_close_exp_pkg.p_period_to
1591: ,p_event_class => xla_period_close_exp_pkg.p_event_class_code
1592: ,p_je_category => xla_period_close_exp_pkg.p_je_category_name
1593: ,p_mode => xla_period_close_exp_pkg.p_mode);

Line 1590: ,p_period_to => xla_period_close_exp_pkg.p_period_to

1586: ,p_retcode => xla_period_close_exp_pkg.C_RETURN_CODE
1587: ,p_application_id => xla_period_close_exp_pkg.p_application_id
1588: ,p_ledger_id => xla_period_close_exp_pkg.p_ledger_id
1589: ,p_period_from => xla_period_close_exp_pkg.p_period_from
1590: ,p_period_to => xla_period_close_exp_pkg.p_period_to
1591: ,p_event_class => xla_period_close_exp_pkg.p_event_class_code
1592: ,p_je_category => xla_period_close_exp_pkg.p_je_category_name
1593: ,p_mode => xla_period_close_exp_pkg.p_mode);
1594:

Line 1591: ,p_event_class => xla_period_close_exp_pkg.p_event_class_code

1587: ,p_application_id => xla_period_close_exp_pkg.p_application_id
1588: ,p_ledger_id => xla_period_close_exp_pkg.p_ledger_id
1589: ,p_period_from => xla_period_close_exp_pkg.p_period_from
1590: ,p_period_to => xla_period_close_exp_pkg.p_period_to
1591: ,p_event_class => xla_period_close_exp_pkg.p_event_class_code
1592: ,p_je_category => xla_period_close_exp_pkg.p_je_category_name
1593: ,p_mode => xla_period_close_exp_pkg.p_mode);
1594:
1595: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN

Line 1592: ,p_je_category => xla_period_close_exp_pkg.p_je_category_name

1588: ,p_ledger_id => xla_period_close_exp_pkg.p_ledger_id
1589: ,p_period_from => xla_period_close_exp_pkg.p_period_from
1590: ,p_period_to => xla_period_close_exp_pkg.p_period_to
1591: ,p_event_class => xla_period_close_exp_pkg.p_event_class_code
1592: ,p_je_category => xla_period_close_exp_pkg.p_je_category_name
1593: ,p_mode => xla_period_close_exp_pkg.p_mode);
1594:
1595: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
1596: trace('beforeReport.End'

Line 1593: ,p_mode => xla_period_close_exp_pkg.p_mode);

1589: ,p_period_from => xla_period_close_exp_pkg.p_period_from
1590: ,p_period_to => xla_period_close_exp_pkg.p_period_to
1591: ,p_event_class => xla_period_close_exp_pkg.p_event_class_code
1592: ,p_je_category => xla_period_close_exp_pkg.p_je_category_name
1593: ,p_mode => xla_period_close_exp_pkg.p_mode);
1594:
1595: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
1596: trace('beforeReport.End'
1597: ,C_LEVEL_PROCEDURE, l_log_module);

Line 1605: (p_location => 'xla_period_close_exp_pkg.beforeReport ');

1601:
1602: EXCEPTION
1603: WHEN OTHERS THEN
1604: xla_exceptions_pkg.raise_message
1605: (p_location => 'xla_period_close_exp_pkg.beforeReport ');
1606:
1607: END beforeReport;
1608:
1609: BEGIN

Line 1619: END xla_period_close_exp_pkg;

1615: IF NOT g_log_enabled THEN
1616: g_log_level := C_LEVEL_LOG_DISABLED;
1617: END IF;
1618:
1619: END xla_period_close_exp_pkg;