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_BALANCES_CALC_PKG dependencies on XLA_BALANCES_CALC_PKG

Line 1: PACKAGE BODY xla_balances_calc_pkg as

1: PACKAGE BODY xla_balances_calc_pkg as
2: /* $Header: xlabacalc.pkb 120.26.12020000.4 2012/08/15 00:11:37 vdamerla ship $ */
3: /*======================================================================+
4: | Copyright (c) 1995-2002 Oracle Corporation |
5: | Redwood Shores, CA, USA |

Line 9: | xla_balances_calc_pkg |

5: | Redwood Shores, CA, USA |
6: | All rights reserved. |
7: +=======================================================================+
8: | PACKAGE NAME |
9: | xla_balances_calc_pkg |
10: | |
11: | DESCRIPTION |
12: | XLA Balances Calculation Package |
13: | |

Line 78: := 'xla.plsql.xla_balances_calc_pkg';

74: c_level_error CONSTANT NUMBER := fnd_log.level_error;
75: c_level_unexpected CONSTANT NUMBER := fnd_log.level_unexpected;
76: c_level_log_disabled CONSTANT NUMBER := 99;
77: c_default_module CONSTANT VARCHAR2 (240)
78: := 'xla.plsql.xla_balances_calc_pkg';
79: g_log_level NUMBER;
80: g_log_enabled BOOLEAN;
81:
82: PROCEDURE TRACE (p_module IN VARCHAR2, p_msg IN VARCHAR2, p_level IN NUMBER)

Line 98: xla_exceptions_pkg.raise_message(p_location => 'xla_balances_calc_pkg.trace');

94: THEN
95: RAISE;
96: WHEN OTHERS
97: THEN
98: xla_exceptions_pkg.raise_message(p_location => 'xla_balances_calc_pkg.trace');
99: END TRACE;
100:
101: /*===============================================+
102: | |

Line 457: (p_location => 'xla_balances_calc_pkg.lock_bal_concurrency_control');

453: RAISE;
454: WHEN OTHERS
455: THEN
456: xla_exceptions_pkg.raise_message
457: (p_location => 'xla_balances_calc_pkg.lock_bal_concurrency_control');
458: RAISE; -- Bug 13614923
459: END lock_bal_concurrency_control;
460:
461: /*===============================================+

Line 1568: (p_location => 'xla_balances_calc_pkg.calculate_analytical_balances');

1564: WHEN OTHERS
1565: THEN
1566: ROLLBACK TO SAVEPOINT_BAL;
1567: xla_exceptions_pkg.raise_message
1568: (p_location => 'xla_balances_calc_pkg.calculate_analytical_balances');
1569: --
1570: --
1571: END calculate_analytical_balances;
1572:

Line 2541: (p_location => 'xla_balances_calc_pkg.calculate_control_balances');

2537: WHEN OTHERS
2538: THEN
2539: ROLLBACK TO SAVEPOINT_BAL;
2540: xla_exceptions_pkg.raise_message
2541: (p_location => 'xla_balances_calc_pkg.calculate_control_balances');
2542: --
2543: --
2544: END calculate_control_balances;
2545:

Line 2742: , p_value_1 => 'xla_balances_calc_pkg.calculate_balances'

2738: xla_exceptions_pkg.raise_message
2739: (p_appli_s_name => 'XLA'
2740: , p_msg_name => 'XLA_COMMON_ERROR'
2741: , p_token_1 => 'LOCATION'
2742: , p_value_1 => 'xla_balances_calc_pkg.calculate_balances'
2743: , p_token_2 => 'ERROR'
2744: , p_value_2 => 'Balances are not initialized for the latest open period.
2745: Before proceeding with balance calculation, run Open Period Balances Program for Ledger ID: '||p_ledger_id||' for the latest open period in General Ledger.'
2746: );

Line 2766: , p_value_1 => 'xla_balances_calc_pkg.calculate_balances'

2762: xla_exceptions_pkg.raise_message
2763: (p_appli_s_name => 'XLA'
2764: , p_msg_name => 'XLA_COMMON_ERROR'
2765: , p_token_1 => 'LOCATION'
2766: , p_value_1 => 'xla_balances_calc_pkg.calculate_balances'
2767: , p_token_2 => 'ERROR'
2768: , p_value_2 => 'EXCEPTION:'
2769: || 'p_execution_mode cannot be NULL'
2770: );

Line 2795: , p_value_1 => 'xla_balances_calc_pkg.calculate_balances'

2791: xla_exceptions_pkg.raise_message
2792: (p_appli_s_name => 'XLA'
2793: , p_msg_name => 'XLA_COMMON_ERROR'
2794: , p_token_1 => 'LOCATION'
2795: , p_value_1 => 'xla_balances_calc_pkg.calculate_balances'
2796: , p_token_2 => 'ERROR'
2797: , p_value_2 => 'EXCEPTION:'
2798: || 'Invalid value for update mode '||p_update_mode
2799: );

Line 2871: (p_location => 'xla_balances_calc_pkg.calculate_balances');

2867: WHEN OTHERS
2868: THEN
2869: ROLLBACK TO SAVEPOINT_BAL;
2870: xla_exceptions_pkg.raise_message
2871: (p_location => 'xla_balances_calc_pkg.calculate_balances');
2872: RAISE;
2873: END calculate_balances;
2874:
2875: /*===============================================+

Line 3306: (p_location => 'xla_balances_calc_pkg.move_balances_forward');

3302: RAISE;
3303: WHEN OTHERS
3304: THEN
3305: xla_exceptions_pkg.raise_message
3306: (p_location => 'xla_balances_calc_pkg.move_balances_forward');
3307: RETURN FALSE;
3308: END move_balances_forward;
3309:
3310: /*===============================================+

Line 3660: , p_value_1 => 'xla_balances_calc_pkg.open_period_srs'

3656: xla_exceptions_pkg.raise_message
3657: (p_appli_s_name => 'XLA'
3658: , p_msg_name => 'XLA_COMMON_ERROR'
3659: , p_token_1 => 'LOCATION'
3660: , p_value_1 => 'xla_balances_calc_pkg.open_period_srs'
3661: , p_token_2 => 'ERROR'
3662: , p_value_2 => 'EXCEPTION:'|| 'Record cannot be inserted into XLA_BAL_CONCURRENCY_CONTROL '
3663: );
3664: END IF;

Line 3890: , p_value_1 => 'xla_balances_calc_pkg.massive_update_srs'

3886: xla_exceptions_pkg.raise_message
3887: (p_appli_s_name => 'XLA'
3888: , p_msg_name => 'XLA_COMMON_ERROR'
3889: , p_token_1 => 'LOCATION'
3890: , p_value_1 => 'xla_balances_calc_pkg.massive_update_srs'
3891: , p_token_2 => 'ERROR'
3892: , p_value_2 => 'EXCEPTION:'
3893: || 'p_application_id cannot be NULL'
3894: );

Line 3913: , p_value_1 => 'xla_balances_calc_pkg.massive_update_srs'

3909: xla_exceptions_pkg.raise_message
3910: (p_appli_s_name => 'XLA'
3911: , p_msg_name => 'XLA_COMMON_ERROR'
3912: , p_token_1 => 'LOCATION'
3913: , p_value_1 => 'xla_balances_calc_pkg.massive_update_srs'
3914: , p_token_2 => 'ERROR'
3915: , p_value_2 => 'EXCEPTION:'
3916: || 'p_ledger_id and p_accounting_batch_id cannot be NULL'
3917: );

Line 3938: , p_value_1 => 'xla_balances_calc_pkg.massive_update_srs'

3934: xla_exceptions_pkg.raise_message
3935: (p_appli_s_name => 'XLA'
3936: , p_msg_name => 'XLA_COMMON_ERROR'
3937: , p_token_1 => 'LOCATION'
3938: , p_value_1 => 'xla_balances_calc_pkg.massive_update_srs'
3939: , p_token_2 => 'ERROR'
3940: , p_value_2 => 'EXCEPTION:'
3941: || 'XLA_BAL_CONCURRENCY_CONTROL COULD NOT BE LOCKED. RESOURCE BUSY'
3942: );

Line 4037: (p_location => 'xla_balances_calc_pkg.massive_update_srs');

4033: --Added below rollback statement
4034: ROLLBACK TO SAVEPOINT_BAL;
4035: DELETE xla_bal_concurrency_control WHERE request_id = g_req_id;
4036: xla_exceptions_pkg.raise_message
4037: (p_location => 'xla_balances_calc_pkg.massive_update_srs');
4038: END massive_update_srs;
4039:
4040: /*===============================================+
4041: | |

Line 4216: , p_value_1 => 'xla_balances_calc_pkg.massive_update'

4212: xla_exceptions_pkg.raise_message
4213: (p_appli_s_name => 'XLA'
4214: , p_msg_name => 'XLA_COMMON_ERROR'
4215: , p_token_1 => 'LOCATION'
4216: , p_value_1 => 'xla_balances_calc_pkg.massive_update'
4217: , p_token_2 => 'ERROR'
4218: , p_value_2 => 'EXCEPTION:'
4219: || 'p_application_id cannot be NULL'
4220: );

Line 4277: , p_value_1 => 'xla_balances_calc_pkg.MASSIVE_UPDATE'

4273: xla_exceptions_pkg.raise_message
4274: (p_appli_s_name => 'XLA'
4275: , p_msg_name => 'XLA_COMMON_ERROR'
4276: , p_token_1 => 'LOCATION'
4277: , p_value_1 => 'xla_balances_calc_pkg.MASSIVE_UPDATE'
4278: , p_token_2 => 'ERROR'
4279: , p_value_2 => 'EXCEPTION:'
4280: || 'XLA_BAL_CONCURRENCY_CONTROL COULD NOT BE LOCKED. RESOURCE BUSY'
4281: );

Line 4392: (p_location => 'xla_balances_calc_pkg.massive_update');

4388: DELETE FROM xla_bal_concurrency_control where request_id=-1*p_entity_id;
4389: end if;
4390:
4391: xla_exceptions_pkg.raise_message
4392: (p_location => 'xla_balances_calc_pkg.massive_update');
4393: RETURN TRUE; -- Bug 13614923
4394: END massive_update;
4395:
4396: /*===============================================+

Line 4494: ,p_value_1 => 'xla_balances_calc_pkg.pre_accounting'

4490: xla_exceptions_pkg.raise_message
4491: (p_appli_s_name => 'XLA'
4492: ,p_msg_name => 'XLA_COMMON_ERROR'
4493: ,p_token_1 => 'LOCATION'
4494: ,p_value_1 => 'xla_balances_calc_pkg.pre_accounting'
4495: ,p_token_2 => 'ERROR'
4496: ,p_value_2 => 'EXCEPTION:' ||
4497: 'p_application_id cannot be NULL');
4498: END IF;

Line 4512: ,p_value_1 => 'xla_balances_calc_pkg.pre_accounting'

4508: xla_exceptions_pkg.raise_message
4509: (p_appli_s_name => 'XLA'
4510: ,p_msg_name => 'XLA_COMMON_ERROR'
4511: ,p_token_1 => 'LOCATION'
4512: ,p_value_1 => 'xla_balances_calc_pkg.pre_accounting'
4513: ,p_token_2 => 'ERROR'
4514: ,p_value_2 => 'EXCEPTION:' || 'p_ae_header_id cannot be NULL');
4515: END IF;
4516:

Line 4530: ,p_value_1 => 'xla_balances_calc_pkg.pre_accounting'

4526: xla_exceptions_pkg.raise_message
4527: (p_appli_s_name => 'XLA'
4528: ,p_msg_name => 'XLA_COMMON_ERROR'
4529: ,p_token_1 => 'LOCATION'
4530: ,p_value_1 => 'xla_balances_calc_pkg.pre_accounting'
4531: ,p_token_2 => 'ERROR'
4532: ,p_value_2 => 'EXCEPTION:' ||'p_update_mode cannot be NULL');
4533: ELSIF p_update_mode NOT IN ('A', 'D', 'F')
4534: THEN

Line 4546: ,p_value_1 => 'xla_balances_calc_pkg.pre_accounting'

4542: xla_exceptions_pkg.raise_message
4543: (p_appli_s_name => 'XLA'
4544: ,p_msg_name => 'XLA_COMMON_ERROR'
4545: ,p_token_1 => 'LOCATION'
4546: ,p_value_1 => 'xla_balances_calc_pkg.pre_accounting'
4547: ,p_token_2 => 'ERROR'
4548: ,p_value_2 => 'EXCEPTION:' ||'Unsupported value for p_update_mode: ' || p_update_mode);
4549: END IF;
4550: -- END parameter validation

Line 4568: , p_value_1 => 'xla_balances_calc_pkg.MASSIVE_UPDATE'

4564: xla_exceptions_pkg.raise_message
4565: (p_appli_s_name => 'XLA'
4566: , p_msg_name => 'XLA_COMMON_ERROR'
4567: , p_token_1 => 'LOCATION'
4568: , p_value_1 => 'xla_balances_calc_pkg.MASSIVE_UPDATE'
4569: , p_token_2 => 'ERROR'
4570: , p_value_2 => 'EXCEPTION:'
4571: || 'XLA_BAL_CONCURRENCY_CONTROL COULD NOT BE LOCKED. RESOURCE BUSY'
4572: );

Line 4661: (p_location => 'xla_balances_calc_pkg.single_update');

4657: THEN
4658: ROLLBACK TO SAVEPOINT_BAL;
4659: DELETE FROM xla_bal_concurrency_control where request_id=-1*p_ae_header_id;
4660: xla_exceptions_pkg.raise_message
4661: (p_location => 'xla_balances_calc_pkg.single_update');
4662: RETURN TRUE;
4663: END single_update;
4664:
4665: FUNCTION is_control_account

Line 4738: (p_location => 'xla_balances_calc_pkg.is_control_account');

4734: END IF;
4735: RETURN C_NOT_CONTROL_ACCOUNT;
4736: WHEN OTHERS THEN
4737: xla_exceptions_pkg.raise_message
4738: (p_location => 'xla_balances_calc_pkg.is_control_account');
4739: END;
4740:
4741: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
4742: trace

Line 4780: (p_location => 'xla_balances_calc_pkg.is_control_account');

4776: END IF;
4777: RETURN C_NOT_CONTROL_ACCOUNT;
4778: WHEN OTHERS THEN
4779: xla_exceptions_pkg.raise_message
4780: (p_location => 'xla_balances_calc_pkg.is_control_account');
4781: RETURN C_NOT_CONTROL_ACCOUNT;
4782: END;
4783:
4784:

Line 4832: ,'xla_balances_calc_pkg.is_control_account');

4828: ,'XLA_COMMON_ERROR'
4829: ,'ERROR'
4830: ,'p_natural_account NOT NULL: functionality not implemented'
4831: ,'LOCATION'
4832: ,'xla_balances_calc_pkg.is_control_account');
4833: END IF;
4834:
4835: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
4836: trace

Line 4849: (p_location => 'xla_balances_calc_pkg.is_control_account');

4845: WHEN xla_exceptions_pkg.application_exception THEN
4846: RAISE;
4847: WHEN OTHERS THEN
4848: xla_exceptions_pkg.raise_message
4849: (p_location => 'xla_balances_calc_pkg.is_control_account');
4850: END is_control_account;
4851:
4852: /*===============================================+
4853: | |

Line 5105: (p_location => 'xla_balances_calc_pkg.sr_bal_unprocessed');

5101: WHEN OTHERS
5102: THEN
5103: RAISE;
5104: xla_exceptions_pkg.raise_message
5105: (p_location => 'xla_balances_calc_pkg.sr_bal_unprocessed');
5106: END sr_bal_unprocessed;
5107:
5108:
5109:

Line 5128: END xla_balances_calc_pkg;

5124: g_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
5125: g_prog_id := xla_environment_pkg.g_prog_id;
5126: g_req_id := NVL (xla_environment_pkg.g_req_id, -1);
5127: g_cached_single_period := FALSE;
5128: END xla_balances_calc_pkg;