DBA Data[Home] [Help]

APPS.XLA_TB_DATA_MANAGER_PVT dependencies on XLA_TB_DATA_MANAGER_PVT

Line 1: PACKAGE BODY XLA_TB_DATA_MANAGER_PVT AS

1: PACKAGE BODY XLA_TB_DATA_MANAGER_PVT AS
2: /* $Header: xlatbdmg.pkb 120.25.12010000.8 2009/01/21 16:10:40 rajose ship $ */
3: /*===========================================================================+
4: | Copyright (c) 2005-2006 Oracle Corporation |
5: | Redwood Shores, CA, USA |

Line 9: | xla_tb_data_manager_pvt |

5: | Redwood Shores, CA, USA |
6: | ALL rights reserved. |
7: +============================================================================+
8: | PACKAGE NAME |
9: | xla_tb_data_manager_pvt |
10: | |
11: | DESCRIPTION |
12: | This IS a XLA PRIVATE PACKAGE, which contains ALL THE logic required |
13: | TO upload trial balance data INTO xla_trial_balances |

Line 1280: (p_location => 'xla_tb_data_manager_pvt.delete_tb_log');

1276: WHEN xla_exceptions_pkg.application_exception THEN
1277: RAISE;
1278: WHEN OTHERS THEN
1279: xla_exceptions_pkg.raise_message
1280: (p_location => 'xla_tb_data_manager_pvt.delete_tb_log');
1281: END delete_tb_log;
1282:
1283:
1284: PROCEDURE define_segment_ranges

Line 1695: (p_location => 'xla_tb_data_manager_pvt.add_partition');

1691: NULL;
1692:
1693: ELSE
1694: xla_exceptions_pkg.raise_message
1695: (p_location => 'xla_tb_data_manager_pvt.add_partition');
1696: END IF;
1697:
1698: END add_partition;
1699:

Line 1755: (p_location => 'xla_tb_data_manager_pvt.delete_trial_balances');

1751: WHEN xla_exceptions_pkg.application_exception THEN
1752: RAISE;
1753: WHEN OTHERS THEN
1754: xla_exceptions_pkg.raise_message
1755: (p_location => 'xla_tb_data_manager_pvt.delete_trial_balances');
1756: END delete_trial_balances;
1757:
1758: /*------------------------------------------------------------+
1759: | |

Line 1834: (p_location => 'xla_tb_data_manager_pvt.delete_trial_balances');

1830: WHEN xla_exceptions_pkg.application_exception THEN
1831: RAISE;
1832: WHEN OTHERS THEN
1833: xla_exceptions_pkg.raise_message
1834: (p_location => 'xla_tb_data_manager_pvt.delete_trial_balances');
1835: END delete_trial_balances;
1836:
1837:
1838:

Line 1927: (p_location => 'xla_tb_data_manager_pvt.delete_definition');

1923: WHEN xla_exceptions_pkg.application_exception THEN
1924: RAISE;
1925: WHEN OTHERS THEN
1926: xla_exceptions_pkg.raise_message
1927: (p_location => 'xla_tb_data_manager_pvt.delete_definition');
1928: END delete_definition;
1929:
1930:
1931: /*===========================================================================+

Line 1968: (p_location => 'xla_tb_data_manager_pvt.drop_partition');

1964: WHEN xla_exceptions_pkg.application_exception THEN
1965: RAISE;
1966: WHEN OTHERS THEN
1967: xla_exceptions_pkg.raise_message
1968: (p_location => 'xla_tb_data_manager_pvt.drop_partition');
1969: END drop_partition;
1970:
1971: /*===========================================================================+
1972: PROCEDURE

Line 2011: (p_location => 'xla_tb_data_manager_pvt.drop_partition');

2007: WHEN xla_exceptions_pkg.application_exception THEN
2008: RAISE;
2009: WHEN OTHERS THEN
2010: xla_exceptions_pkg.raise_message
2011: (p_location => 'xla_tb_data_manager_pvt.drop_partition');
2012: END drop_partition;
2013:
2014: /*------------------------------------------------------------+
2015: | |

Line 2080: (p_location => 'xla_tb_data_manager_pvt.get_report_definition');

2076: WHEN xla_exceptions_pkg.application_exception THEN
2077: RAISE;
2078: WHEN OTHERS THEN
2079: xla_exceptions_pkg.raise_message
2080: (p_location => 'xla_tb_data_manager_pvt.get_report_definition');
2081: END get_report_definition;
2082:
2083: PROCEDURE get_worker_info
2084: (p_ledger_id IN VARCHAR2)

Line 2136: (p_location => 'xla_tb_data_manager_pvt.get_worker_info');

2132: WHEN xla_exceptions_pkg.application_exception THEN
2133: RAISE;
2134: WHEN OTHERS THEN
2135: xla_exceptions_pkg.raise_message
2136: (p_location => 'xla_tb_data_manager_pvt.get_worker_info');
2137: END get_worker_info;
2138:
2139:
2140: FUNCTION get_ledger_info

Line 2197: (p_location => 'xla_tb_data_manager_pvt.get_ledger_info');

2193: WHEN xla_exceptions_pkg.application_exception THEN
2194: RAISE;
2195: WHEN OTHERS THEN
2196: xla_exceptions_pkg.raise_message
2197: (p_location => 'xla_tb_data_manager_pvt.get_ledger_info');
2198: END get_ledger_info;
2199:
2200: /*------------------------------------------------------------+
2201: |

Line 2263: (p_location => 'xla_tb_data_manager_pvt.get_ledger_where');

2259: WHEN xla_exceptions_pkg.application_exception THEN
2260: RAISE;
2261: WHEN OTHERS THEN
2262: xla_exceptions_pkg.raise_message
2263: (p_location => 'xla_tb_data_manager_pvt.get_ledger_where');
2264: END get_ledger_where;
2265:
2266:
2267: /*------------------------------------------------------------+

Line 2297: (p_location => 'xla_tb_data_manager_pvt.get_je_source_info');

2293: WHEN xla_exceptions_pkg.application_exception THEN
2294: RAISE;
2295: WHEN OTHERS THEN
2296: xla_exceptions_pkg.raise_message
2297: (p_location => 'xla_tb_data_manager_pvt.get_je_source_info');
2298:
2299: END get_je_source_info;
2300:
2301: /*------------------------------------------------------------+

Line 2421: (p_location => 'xla_tb_data_manager_pvt.get_segment_columns');

2417: WHEN xla_exceptions_pkg.application_exception THEN
2418: RAISE;
2419: WHEN OTHERS THEN
2420: xla_exceptions_pkg.raise_message
2421: (p_location => 'xla_tb_data_manager_pvt.get_segment_columns');
2422: END get_segment_columns;
2423:
2424:
2425: FUNCTION get_segment_clause

Line 2464: (p_location => 'xla_tb_data_manager_pvt.get_segment_clause');

2460: WHEN xla_exceptions_pkg.application_exception THEN
2461: RAISE;
2462: WHEN OTHERS THEN
2463: xla_exceptions_pkg.raise_message
2464: (p_location => 'xla_tb_data_manager_pvt.get_segment_clause');
2465: END get_segment_clause;
2466:
2467:
2468: PROCEDURE populate_user_trans_view

Line 2812: (p_location => 'xla_tb_data_manager_pvt.populate_user_trans_view');

2808: WHEN xla_exceptions_pkg.application_exception THEN
2809: RAISE;
2810: WHEN OTHERS THEN
2811: xla_exceptions_pkg.raise_message
2812: (p_location => 'xla_tb_data_manager_pvt.populate_user_trans_view');
2813: END populate_user_trans_view;
2814:
2815: /*===========================================================================+
2816: PROCEDURE

Line 2965: (p_location => 'xla_tb_data_manager_pvt.insert_trial_balance_upg');

2961: END IF;
2962: RAISE;
2963: WHEN OTHERS THEN
2964: xla_exceptions_pkg.raise_message
2965: (p_location => 'xla_tb_data_manager_pvt.insert_trial_balance_upg');
2966: END insert_trial_balance_upg;
2967:
2968: /*===========================================================================+
2969: PROCEDURE

Line 3295: (p_location => 'xla_tb_data_manager_pvt.insert_trial_balance_def');

3291: END IF;
3292: RAISE;
3293: WHEN OTHERS THEN
3294: xla_exceptions_pkg.raise_message
3295: (p_location => 'xla_tb_data_manager_pvt.insert_trial_balance_def');
3296: END insert_trial_balance_def;
3297:
3298: /*------------------------------------------------------------+
3299: | |

Line 3378: (p_location => 'xla_tb_data_manager_pvt.recreate_trial_balances');

3374: WHEN xla_exceptions_pkg.application_exception THEN
3375: RAISE;
3376: WHEN OTHERS THEN
3377: xla_exceptions_pkg.raise_message
3378: (p_location => 'xla_tb_data_manager_pvt.recreate_trial_balances');
3379: END recreate_trial_balances;
3380:
3381:
3382:

Line 3443: (p_location => 'xla_tb_data_manager_pvt.insert_tb_logs');

3439: WHEN xla_exceptions_pkg.application_exception THEN
3440: RAISE;
3441: WHEN OTHERS THEN
3442: xla_exceptions_pkg.raise_message
3443: (p_location => 'xla_tb_data_manager_pvt.insert_tb_logs');
3444: END insert_tb_logs;
3445:
3446: /*===========================================================================+
3447: PROCEDURE

Line 3675: (p_location => 'xla_tb_data_manager_pvt.insert_trial_balance_wu');

3671: WHEN xla_exceptions_pkg.application_exception THEN
3672: RAISE;
3673: WHEN OTHERS THEN
3674: xla_exceptions_pkg.raise_message
3675: (p_location => 'xla_tb_data_manager_pvt.insert_trial_balance_wu');
3676: END insert_trial_balance_wu;
3677:
3678:
3679:

Line 3884: (p_location => 'xla_tb_data_manager_pvt.update_definition_status');

3880: WHEN xla_exceptions_pkg.application_exception THEN
3881: RAISE;
3882: WHEN OTHERS THEN
3883: xla_exceptions_pkg.raise_message
3884: (p_location => 'xla_tb_data_manager_pvt.update_definition_status');
3885: END update_definition_status;
3886:
3887:
3888: /*------------------------------------------------------------+

Line 4256: (p_location => 'xla_tb_data_manager_pvt.generate_work_units');

4252: WHEN xla_exceptions_pkg.application_exception THEN
4253: RAISE;
4254: WHEN OTHERS THEN
4255: xla_exceptions_pkg.raise_message
4256: (p_location => 'xla_tb_data_manager_pvt.generate_work_units');
4257: END generate_work_units;
4258:
4259: /*------------------------------------------------------------+
4260: | |

Line 4317: (p_location => 'xla_tb_data_manager_pvt.retrieve_work_units');

4313: WHEN xla_exceptions_pkg.application_exception THEN
4314: RAISE;
4315: WHEN OTHERS THEN
4316: xla_exceptions_pkg.raise_message
4317: (p_location => 'xla_tb_data_manager_pvt.retrieve_work_units');
4318: END retrieve_work_unit;
4319:
4320:
4321:

Line 4362: (p_location => 'xla_tb_data_manager_pvt.upload_preprocessor');

4358: WHEN xla_exceptions_pkg.application_exception THEN
4359: RAISE;
4360: WHEN OTHERS THEN
4361: xla_exceptions_pkg.raise_message
4362: (p_location => 'xla_tb_data_manager_pvt.upload_preprocessor');
4363: END upload_preprocessor;
4364:
4365: /*======================================================================+
4366: | |

Line 4405: (p_location => 'xla_tb_data_manager_pvt.truncate_partition');

4401: WHEN xla_exceptions_pkg.application_exception THEN
4402: RAISE;
4403: WHEN OTHERS THEN
4404: xla_exceptions_pkg.raise_message
4405: (p_location => 'xla_tb_data_manager_pvt.truncate_partition');
4406: END truncate_partition;
4407:
4408: /*======================================================================+
4409: | |

Line 4577: (p_location => 'xla_tb_data_manager_pvt.upload_pvt');

4573: WHEN xla_exceptions_pkg.application_exception THEN
4574: RAISE;
4575: WHEN OTHERS THEN
4576: xla_exceptions_pkg.raise_message
4577: (p_location => 'xla_tb_data_manager_pvt.upload_pvt');
4578:
4579: END upload_pvt;
4580:
4581: PROCEDURE validate_parameters

Line 4605: (p_location => 'xla_tb_data_manager_pvt.validate_parameters');

4601: WHEN xla_exceptions_pkg.application_exception THEN
4602: RAISE;
4603: WHEN OTHERS THEN
4604: xla_exceptions_pkg.raise_message
4605: (p_location => 'xla_tb_data_manager_pvt.validate_parameters');
4606: END validate_parameters;
4607:
4608:
4609: /*======================================================================+

Line 4760: (p_location => 'xla_tb_data_manager_pvt.upload');

4756: WHEN xla_exceptions_pkg.application_exception THEN
4757: RAISE;
4758: WHEN OTHERS THEN
4759: xla_exceptions_pkg.raise_message
4760: (p_location => 'xla_tb_data_manager_pvt.upload');
4761: END upload;
4762:
4763:
4764: /*======================================================================+

Line 4801: (p_location => 'xla_tb_data_manager_pvt.delete_wu');

4797: WHEN xla_exceptions_pkg.application_exception THEN
4798: RAISE;
4799: WHEN OTHERS THEN
4800: xla_exceptions_pkg.raise_message
4801: (p_location => 'xla_tb_data_manager_pvt.delete_wu');
4802:
4803: END delete_wu;
4804:
4805: /*======================================================================+

Line 4969: (p_location => 'xla_tb_data_manager_pvt.worker_process_pvt');

4965: COMMIT;
4966:
4967: END IF;
4968: xla_exceptions_pkg.raise_message
4969: (p_location => 'xla_tb_data_manager_pvt.worker_process_pvt');
4970:
4971: END worker_process_pvt;
4972:
4973: /*======================================================================+

Line 5114: (p_location => 'xla_tb_data_manager_pvt.delete_non_ui_rows');

5110: END IF;
5111: RAISE;
5112: WHEN OTHERS THEN
5113: xla_exceptions_pkg.raise_message
5114: (p_location => 'xla_tb_data_manager_pvt.delete_non_ui_rows');
5115: END delete_non_ui_rows;
5116:
5117: --=============================================================================
5118: -- *********** Initialization routine **********

Line 5144: END XLA_TB_DATA_MANAGER_PVT;

5140: END IF;
5141:
5142:
5143:
5144: END XLA_TB_DATA_MANAGER_PVT;