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_PKG dependencies on XLA_BALANCES_PKG

Line 1: PACKAGE BODY xla_balances_pkg AS

1: PACKAGE BODY xla_balances_pkg AS
2: /* $Header: xlabacom.pkb 120.43.12010000.15 2008/12/24 10:58:25 svellani ship $ */
3: /*======================================================================+
4: | Copyright (c) 1995-2002 Oracle Corporation |
5: | Redwood Shores, CA, USA |

Line 9: | xla_balances_pkg |

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

Line 193: C_DEFAULT_MODULE CONSTANT VARCHAR2(240) := 'xla.plsql.xla_balances_pkg';

189: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
190: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
191:
192: C_LEVEL_LOG_DISABLED CONSTANT NUMBER := 99;
193: C_DEFAULT_MODULE CONSTANT VARCHAR2(240) := 'xla.plsql.xla_balances_pkg';
194:
195: g_log_level NUMBER;
196: g_log_enabled BOOLEAN;
197:

Line 217: (p_location => 'xla_balances_pkg.trace');

213: WHEN xla_exceptions_pkg.application_exception THEN
214: RAISE;
215: WHEN OTHERS THEN
216: xla_exceptions_pkg.raise_message
217: (p_location => 'xla_balances_pkg.trace');
218: END trace;
219:
220:
221: FUNCTION get_account_segment_column

Line 284: ,p_value_1 => 'xla_balances_pkg.pre_accounting'

280: xla_exceptions_pkg.raise_message
281: (p_appli_s_name => 'XLA'
282: ,p_msg_name => 'XLA_COMMON_ERROR'
283: ,p_token_1 => 'LOCATION'
284: ,p_value_1 => 'xla_balances_pkg.pre_accounting'
285: ,p_token_2 => 'ERROR'
286: ,p_value_2 => 'EXCEPTION: Unable to retrieve segment information for chart of accounts ' ||
287: p_chart_of_accounts_id);
288: END IF;

Line 299: (p_location => 'xla_balances_pkg.get_account_segment_column');

295: RAISE;
296: WHEN OTHERS
297: THEN
298: xla_exceptions_pkg.raise_message
299: (p_location => 'xla_balances_pkg.get_account_segment_column');
300: END get_account_segment_column;
301:
302:
303: FUNCTION move_balances_forward_COMMIT

Line 438: ,p_value_1 => 'xla_balances_pkg.pre_accounting'

434: xla_exceptions_pkg.raise_message
435: (p_appli_s_name => 'XLA'
436: ,p_msg_name => 'XLA_COMMON_ERROR'
437: ,p_token_1 => 'LOCATION'
438: ,p_value_1 => 'xla_balances_pkg.pre_accounting'
439: ,p_token_2 => 'ERROR'
440: ,p_value_2 => 'EXCEPTION:'
441: ||'p_balance_status_code_selected and p_balance_status_code_not_sel '
442: || 'cannot be both NULL');

Line 460: ,p_value_1 => 'xla_balances_pkg.pre_accounting'

456: xla_exceptions_pkg.raise_message
457: (p_appli_s_name => 'XLA'
458: ,p_msg_name => 'XLA_COMMON_ERROR'
459: ,p_token_1 => 'LOCATION'
460: ,p_value_1 => 'xla_balances_pkg.pre_accounting'
461: ,p_token_2 => 'ERROR'
462: ,p_value_2 => 'EXCEPTION: ' ||
463: 'p_source_effective_period_num cannot be NULL');
464: END IF;

Line 1062: (p_location => 'xla_balances_pkg.move_balances_forward_COMMIT');

1058: RAISE;
1059: WHEN OTHERS
1060: THEN
1061: xla_exceptions_pkg.raise_message
1062: (p_location => 'xla_balances_pkg.move_balances_forward_COMMIT');
1063: END move_balances_forward_COMMIT;
1064:
1065:
1066: FUNCTION check_create_period_balances

Line 1216: (p_location => 'xla_balances_pkg.check_create_period_balances');

1212: WHEN xla_exceptions_pkg.application_exception THEN
1213: RAISE;
1214: WHEN OTHERS THEN
1215: xla_exceptions_pkg.raise_message
1216: (p_location => 'xla_balances_pkg.check_create_period_balances');
1217: END check_create_period_balances;
1218:
1219:
1220: FUNCTION AUT_check_create_period_bals

Line 1299: (p_location => 'xla_balances_pkg.AUT_check_create_period_bals');

1295: WHEN xla_exceptions_pkg.application_exception THEN
1296: RAISE;
1297: WHEN OTHERS THEN
1298: xla_exceptions_pkg.raise_message
1299: (p_location => 'xla_balances_pkg.AUT_check_create_period_bals');
1300: END AUT_check_create_period_bals;
1301:
1302: FUNCTION lock_create_balance_statuses
1303:

Line 1545: ,p_value_1 => 'xla_balances_pkg.pre_accounting'

1541: xla_exceptions_pkg.raise_message
1542: (p_appli_s_name => 'XLA'
1543: ,p_msg_name => 'XLA_COMMON_ERROR'
1544: ,p_token_1 => 'LOCATION'
1545: ,p_value_1 => 'xla_balances_pkg.pre_accounting'
1546: ,p_token_2 => 'ERROR'
1547: ,p_value_2 => 'EXCEPTION: ' ||
1548: 'Unable to retrieve segment names for ledger_id '
1549: || i.ledger_id);

Line 1694: (p_location => 'xla_balances_pkg.lock_create_balance_statuses');

1690: WHEN xla_exceptions_pkg.application_exception THEN
1691: RAISE;
1692: WHEN OTHERS THEN
1693: xla_exceptions_pkg.raise_message
1694: (p_location => 'xla_balances_pkg.lock_create_balance_statuses');
1695: END lock_create_balance_statuses;
1696:
1697: FUNCTION calculate_control_balances
1698: ( p_application_id IN INTEGER

Line 2435: (p_location => 'xla_balances_pkg.calculate_control_balances');

2431: WHEN xla_exceptions_pkg.application_exception THEN
2432: RAISE;
2433: WHEN OTHERS THEN
2434: xla_exceptions_pkg.raise_message
2435: (p_location => 'xla_balances_pkg.calculate_control_balances');
2436: END calculate_control_balances;
2437:
2438: FUNCTION calculate_analytical_balances
2439: ( p_application_id IN INTEGER

Line 3166: (p_location => 'xla_balances_pkg.calculate_analytical_balances');

3162: WHEN xla_exceptions_pkg.application_exception THEN
3163: RAISE;
3164: WHEN OTHERS THEN
3165: xla_exceptions_pkg.raise_message
3166: (p_location => 'xla_balances_pkg.calculate_analytical_balances');
3167: END calculate_analytical_balances;
3168:
3169:
3170:

Line 3300: ,p_value_1 => 'xla_balances_pkg.pre_accounting'

3296: xla_exceptions_pkg.raise_message
3297: (p_appli_s_name => 'XLA'
3298: ,p_msg_name => 'XLA_COMMON_ERROR'
3299: ,p_token_1 => 'LOCATION'
3300: ,p_value_1 => 'xla_balances_pkg.pre_accounting'
3301: ,p_token_2 => 'ERROR'
3302: ,p_value_2 => 'EXCEPTION: ' ||
3303: 'parameters cannot be NULL');
3304: END IF;

Line 3323: ,p_value_1 => 'xla_balances_pkg.pre_accounting'

3319: xla_exceptions_pkg.raise_message
3320: (p_appli_s_name => 'XLA'
3321: ,p_msg_name => 'XLA_COMMON_ERROR'
3322: ,p_token_1 => 'LOCATION'
3323: ,p_value_1 => 'xla_balances_pkg.pre_accounting'
3324: ,p_token_2 => 'ERROR'
3325: ,p_value_2 => 'EXCEPTION: ' ||
3326: 'If p_balance_source_code is not ''A'' party parameters cannot be NULL');
3327: END IF;

Line 3351: ,p_value_1 => 'xla_balances_pkg.pre_accounting'

3347: xla_exceptions_pkg.raise_message
3348: (p_appli_s_name => 'XLA'
3349: ,p_msg_name => 'XLA_COMMON_ERROR'
3350: ,p_token_1 => 'LOCATION'
3351: ,p_value_1 => 'xla_balances_pkg.pre_accounting'
3352: ,p_token_2 => 'ERROR'
3353: ,p_value_2 => 'EXCEPTION: ' ||
3354: 'If p_balance_source_code is not ''C'' analytical detail parameter cannot be NULL');
3355: END IF;

Line 3735: (p_location => 'xla_balances_pkg.move_identified_bals_forward');

3731: RAISE;
3732: WHEN OTHERS
3733: THEN
3734: xla_exceptions_pkg.raise_message
3735: (p_location => 'xla_balances_pkg.move_identified_bals_forward');
3736: END move_identified_bals_forward;
3737:
3738: PROCEDURE build_line_selection_dyn_stmts
3739: ( p_application_id IN INTEGER

Line 4187: ,p_value_1 => 'xla_balances_pkg.pre_accounting'

4183: xla_exceptions_pkg.raise_message
4184: (p_appli_s_name => 'XLA'
4185: ,p_msg_name => 'XLA_COMMON_ERROR'
4186: ,p_token_1 => 'LOCATION'
4187: ,p_value_1 => 'xla_balances_pkg.pre_accounting'
4188: ,p_token_2 => 'ERROR'
4189: ,p_value_2 => 'EXCEPTION: ' ||
4190: 'Invalid value for p_commit_flag: ' || p_commit_flag);
4191: END IF;

Line 4269: (p_location => 'xla_balances_pkg.build_line_selection_dyn_stmts');

4265: RAISE;
4266: WHEN OTHERS
4267: THEN
4268: xla_exceptions_pkg.raise_message
4269: (p_location => 'xla_balances_pkg.build_line_selection_dyn_stmts');
4270: END build_line_selection_dyn_stmts;
4271:
4272:
4273: FUNCTION load_balance_temp_tables

Line 4989: (p_location => 'xla_balances_pkg.load_balance_temp_tables');

4985: RAISE;
4986: WHEN OTHERS
4987: THEN
4988: xla_exceptions_pkg.raise_message
4989: (p_location => 'xla_balances_pkg.load_balance_temp_tables');
4990: END load_balance_temp_tables;
4991:
4992:
4993:

Line 5278: ,p_value_1 => 'xla_balances_pkg.pre_accounting'

5274: xla_exceptions_pkg.raise_message
5275: (p_appli_s_name => 'XLA'
5276: ,p_msg_name => 'XLA_COMMON_ERROR'
5277: ,p_token_1 => 'LOCATION'
5278: ,p_value_1 => 'xla_balances_pkg.pre_accounting'
5279: ,p_token_2 => 'ERROR'
5280: ,p_value_2 => 'EXCEPTION: ' ||'Invalid value for p_operation_code: '
5281: || p_operation_code);
5282: END IF; --p_operation_code

Line 5310: (p_location => 'xla_balances_pkg.load_alyt_secondary_temp_tabs');

5306: RAISE;
5307: WHEN OTHERS
5308: THEN
5309: xla_exceptions_pkg.raise_message
5310: (p_location => 'xla_balances_pkg.load_alyt_secondary_temp_tabs');
5311: END load_alyt_secondary_temp_tabs;
5312:
5313:
5314:

Line 5543: ,p_value_1 => 'xla_balances_pkg.pre_accounting'

5539: xla_exceptions_pkg.raise_message
5540: (p_appli_s_name => 'XLA'
5541: ,p_msg_name => 'XLA_COMMON_ERROR'
5542: ,p_token_1 => 'LOCATION'
5543: ,p_value_1 => 'xla_balances_pkg.pre_accounting'
5544: ,p_token_2 => 'ERROR'
5545: ,p_value_2 => 'EXCEPTION: ' ||
5546: 'Invalid value for p_operation_code: ' || p_operation_code);
5547:

Line 5575: (p_location => 'xla_balances_pkg.load_ctrl_secondary_temp_tabs');

5571: RAISE;
5572: WHEN OTHERS
5573: THEN
5574: xla_exceptions_pkg.raise_message
5575: (p_location => 'xla_balances_pkg.load_ctrl_secondary_temp_tabs');
5576: END load_ctrl_secondary_temp_tabs;
5577:
5578:
5579: PROCEDURE insert_ledger_period_statuses

Line 5813: ,p_value_1 => 'xla_balances_pkg.pre_accounting'

5809: xla_exceptions_pkg.raise_message
5810: (p_appli_s_name => 'XLA'
5811: ,p_msg_name => 'XLA_COMMON_ERROR'
5812: ,p_token_1 => 'LOCATION'
5813: ,p_value_1 => 'xla_balances_pkg.pre_accounting'
5814: ,p_token_2 => 'ERROR'
5815: ,p_value_2 => 'EXCEPTION:' ||
5816: 'Unsupported combinations of parameters');
5817: END IF;

Line 5842: (p_location => 'xla_balances_pkg.insert_ledger_period_statuses');

5838: RAISE;
5839: WHEN OTHERS
5840: THEN
5841: xla_exceptions_pkg.raise_message
5842: (p_location => 'xla_balances_pkg.insert_ledger_period_statuses');
5843: END insert_ledger_period_statuses;
5844:
5845:
5846: PROCEDURE cache_ledger_period_statuses

Line 6141: (p_location => 'xla_balances_pkg.cache_ledger_period_statuses');

6137: RAISE;
6138: WHEN OTHERS
6139: THEN
6140: xla_exceptions_pkg.raise_message
6141: (p_location => 'xla_balances_pkg.cache_ledger_period_statuses');
6142: END cache_ledger_period_statuses;
6143:
6144:
6145:

Line 6326: ,p_value_1 => 'xla_balances_pkg.pre_accounting'

6322: xla_exceptions_pkg.raise_message
6323: (p_appli_s_name => 'XLA'
6324: ,p_msg_name => 'XLA_COMMON_ERROR'
6325: ,p_token_1 => 'LOCATION'
6326: ,p_value_1 => 'xla_balances_pkg.pre_accounting'
6327: ,p_token_2 => 'ERROR'
6328: ,p_value_2 => 'EXCEPTION:' ||
6329: 'Unsupported p_update_mode: ' || p_update_mode || ' with p_commit_flag: ' ||
6330: p_commit_flag);

Line 6360: ,p_value_1 => 'xla_balances_pkg.pre_accounting'

6356: xla_exceptions_pkg.raise_message
6357: (p_appli_s_name => 'XLA'
6358: ,p_msg_name => 'XLA_COMMON_ERROR'
6359: ,p_token_1 => 'LOCATION'
6360: ,p_value_1 => 'xla_balances_pkg.pre_accounting'
6361: ,p_token_2 => 'ERROR'
6362: ,p_value_2 => 'EXCEPTION:' ||
6363: 'Unkown p_update_mode value: ' || p_update_mode);
6364: END IF;

Line 6381: ,p_value_1 => 'xla_balances_pkg.pre_accounting'

6377: xla_exceptions_pkg.raise_message
6378: (p_appli_s_name => 'XLA'
6379: ,p_msg_name => 'XLA_COMMON_ERROR'
6380: ,p_token_1 => 'LOCATION'
6381: ,p_value_1 => 'xla_balances_pkg.pre_accounting'
6382: ,p_token_2 => 'ERROR'
6383: ,p_value_2 => 'EXCEPTION:' ||
6384: 'Unsupported p_balance_source_code value: ' || p_balance_source_code);
6385: END IF;

Line 6684: ,p_value_1 => 'xla_balances_pkg.pre_accounting'

6680: xla_exceptions_pkg.raise_message
6681: (p_appli_s_name => 'XLA'
6682: ,p_msg_name => 'XLA_COMMON_ERROR'
6683: ,p_token_1 => 'LOCATION'
6684: ,p_value_1 => 'xla_balances_pkg.pre_accounting'
6685: ,p_token_2 => 'ERROR'
6686: ,p_value_2 => 'EXCEPTION:' ||
6687: 'Unsupported p_update_mode value: ' || p_update_mode);
6688: END IF;

Line 7012: ,p_value_1 => 'xla_balances_pkg.pre_accounting'

7008: xla_exceptions_pkg.raise_message
7009: (p_appli_s_name => 'XLA'
7010: ,p_msg_name => 'XLA_COMMON_ERROR'
7011: ,p_token_1 => 'LOCATION'
7012: ,p_value_1 => 'xla_balances_pkg.pre_accounting'
7013: ,p_token_2 => 'ERROR'
7014: ,p_value_2 => 'EXCEPTION:' ||
7015: 'Unkown p_commit_flag value: ' || p_commit_flag);
7016: END IF;

Line 7055: (p_location => 'xla_balances_pkg.calculate_balances');

7051: WHEN xla_exceptions_pkg.application_exception THEN
7052: RAISE;
7053: WHEN OTHERS THEN
7054: xla_exceptions_pkg.raise_message
7055: (p_location => 'xla_balances_pkg.calculate_balances');
7056:
7057: END calculate_balances;
7058:
7059: FUNCTION event_set_update

Line 7095: ,p_value_1 => 'xla_balances_pkg.pre_accounting'

7091: xla_exceptions_pkg.raise_message
7092: (p_appli_s_name => 'XLA'
7093: ,p_msg_name => 'XLA_COMMON_ERROR'
7094: ,p_token_1 => 'LOCATION'
7095: ,p_value_1 => 'xla_balances_pkg.pre_accounting'
7096: ,p_token_2 => 'ERROR'
7097: ,p_value_2 => 'EXCEPTION:' ||
7098: 'Unsupported value for p_update_mode: ' || p_update_mode);
7099: END IF;

Line 7132: (p_location => 'xla_balances_pkg.event_set_update');

7128: WHEN xla_exceptions_pkg.application_exception THEN
7129: RAISE;
7130: WHEN OTHERS THEN
7131: xla_exceptions_pkg.raise_message
7132: (p_location => 'xla_balances_pkg.event_set_update');
7133: END event_set_update;
7134:
7135:
7136:

Line 7175: ,p_value_1 => 'xla_balances_pkg.pre_accounting'

7171: xla_exceptions_pkg.raise_message
7172: (p_appli_s_name => 'XLA'
7173: ,p_msg_name => 'XLA_COMMON_ERROR'
7174: ,p_token_1 => 'LOCATION'
7175: ,p_value_1 => 'xla_balances_pkg.pre_accounting'
7176: ,p_token_2 => 'ERROR'
7177: ,p_value_2 => 'EXCEPTION:' ||
7178: 'p_application_id cannot be NULL');
7179: END IF;

Line 7195: ,p_value_1 => 'xla_balances_pkg.pre_accounting'

7191: xla_exceptions_pkg.raise_message
7192: (p_appli_s_name => 'XLA'
7193: ,p_msg_name => 'XLA_COMMON_ERROR'
7194: ,p_token_1 => 'LOCATION'
7195: ,p_value_1 => 'xla_balances_pkg.pre_accounting'
7196: ,p_token_2 => 'ERROR'
7197: ,p_value_2 => 'EXCEPTION:' ||
7198: 'p_ae_header_id cannot be NULL');
7199: END IF;

Line 7215: ,p_value_1 => 'xla_balances_pkg.pre_accounting'

7211: xla_exceptions_pkg.raise_message
7212: (p_appli_s_name => 'XLA'
7213: ,p_msg_name => 'XLA_COMMON_ERROR'
7214: ,p_token_1 => 'LOCATION'
7215: ,p_value_1 => 'xla_balances_pkg.pre_accounting'
7216: ,p_token_2 => 'ERROR'
7217: ,p_value_2 => 'EXCEPTION:' ||
7218: 'p_update_mode cannot be NULL');
7219: ELSIF p_update_mode NOT IN ('A', 'D', 'F')

Line 7233: ,p_value_1 => 'xla_balances_pkg.pre_accounting'

7229: xla_exceptions_pkg.raise_message
7230: (p_appli_s_name => 'XLA'
7231: ,p_msg_name => 'XLA_COMMON_ERROR'
7232: ,p_token_1 => 'LOCATION'
7233: ,p_value_1 => 'xla_balances_pkg.pre_accounting'
7234: ,p_token_2 => 'ERROR'
7235: ,p_value_2 => 'EXCEPTION:' ||
7236: 'Unsupported value for p_update_mode: ' || p_update_mode);
7237: END IF;

Line 7269: (p_location => 'xla_balances_pkg.single_update');

7265: WHEN xla_exceptions_pkg.application_exception THEN
7266: RAISE;
7267: WHEN OTHERS THEN
7268: xla_exceptions_pkg.raise_message
7269: (p_location => 'xla_balances_pkg.single_update');
7270: END single_update;
7271:
7272:
7273: PROCEDURE massive_update_srs

Line 7404: ,p_value_1 => 'xla_balances_pkg.pre_accounting'

7400: xla_exceptions_pkg.raise_message
7401: (p_appli_s_name => 'XLA'
7402: ,p_msg_name => 'XLA_COMMON_ERROR'
7403: ,p_token_1 => 'LOCATION'
7404: ,p_value_1 => 'xla_balances_pkg.pre_accounting'
7405: ,p_token_2 => 'ERROR'
7406: ,p_value_2 => 'EXCEPTION:' ||
7407: 'p_application_id cannot be NULL'
7408: );

Line 7433: (p_location => 'xla_balances_pkg.massive_update_for_events');

7429: WHEN xla_exceptions_pkg.application_exception THEN
7430: RAISE;
7431: WHEN OTHERS THEN
7432: xla_exceptions_pkg.raise_message
7433: (p_location => 'xla_balances_pkg.massive_update_for_events');
7434: END massive_update_for_events;
7435:
7436: FUNCTION massive_update
7437: (

Line 7484: ,p_value_1 => 'xla_balances_pkg.massive_update'

7480: xla_exceptions_pkg.raise_message
7481: (p_appli_s_name => 'XLA'
7482: ,p_msg_name => 'XLA_COMMON_ERROR'
7483: ,p_token_1 => 'LOCATION'
7484: ,p_value_1 => 'xla_balances_pkg.massive_update'
7485: ,p_token_2 => 'ERROR'
7486: ,p_value_2 => 'EXCEPTION: p_application_id cannot be NULL');
7487:
7488: END IF;

Line 7508: ,p_value_1 => 'xla_balances_pkg.massive_update'

7504: xla_exceptions_pkg.raise_message
7505: (p_appli_s_name => 'XLA'
7506: ,p_msg_name => 'XLA_COMMON_ERROR'
7507: ,p_token_1 => 'LOCATION'
7508: ,p_value_1 => 'xla_balances_pkg.massive_update'
7509: ,p_token_2 => 'ERROR'
7510: ,p_value_2 => 'EXCEPTION: IF p_entity_id is not NULL, p_ledger_id must be NULL');
7511:
7512: ELSIF p_event_id IS NOT NULL

Line 7526: ,p_value_1 => 'xla_balances_pkg.massive_update'

7522: xla_exceptions_pkg.raise_message
7523: (p_appli_s_name => 'XLA'
7524: ,p_msg_name => 'XLA_COMMON_ERROR'
7525: ,p_token_1 => 'LOCATION'
7526: ,p_value_1 => 'xla_balances_pkg.massive_update'
7527: ,p_token_2 => 'ERROR'
7528: ,p_value_2 => 'EXCEPTION: IF p_entity_id is not NULL, p_event_id must be NULL');
7529: ELSIF p_request_id IS NOT NULL
7530: THEN

Line 7543: ,p_value_1 => 'xla_balances_pkg.massive_update'

7539: xla_exceptions_pkg.raise_message
7540: (p_appli_s_name => 'XLA'
7541: ,p_msg_name => 'XLA_COMMON_ERROR'
7542: ,p_token_1 => 'LOCATION'
7543: ,p_value_1 => 'xla_balances_pkg.massive_update'
7544: ,p_token_2 => 'ERROR'
7545: ,p_value_2 => 'EXCEPTION: IF p_entity_id is not NULL, p_request_id must be NULL');
7546:
7547: ELSIF p_accounting_batch_id IS NOT NULL

Line 7561: ,p_value_1 => 'xla_balances_pkg.massive_update'

7557: xla_exceptions_pkg.raise_message
7558: (p_appli_s_name => 'XLA'
7559: ,p_msg_name => 'XLA_COMMON_ERROR'
7560: ,p_token_1 => 'LOCATION'
7561: ,p_value_1 => 'xla_balances_pkg.massive_update'
7562: ,p_token_2 => 'ERROR'
7563: ,p_value_2 => 'EXCEPTION: IF p_entity_id is not NULL, p_accounting_batch_id must be NULL');
7564:
7565: END IF;

Line 7586: ,p_value_1 => 'xla_balances_pkg.massive_update'

7582: xla_exceptions_pkg.raise_message
7583: (p_appli_s_name => 'XLA'
7584: ,p_msg_name => 'XLA_COMMON_ERROR'
7585: ,p_token_1 => 'LOCATION'
7586: ,p_value_1 => 'xla_balances_pkg.massive_update'
7587: ,p_token_2 => 'ERROR'
7588: ,p_value_2 => 'EXCEPTION: IF p_request_id is not NULL, p_ledger_id must be NULL');
7589:
7590: ELSIF p_entity_id IS NOT NULL

Line 7604: ,p_value_1 => 'xla_balances_pkg.massive_update'

7600: xla_exceptions_pkg.raise_message
7601: (p_appli_s_name => 'XLA'
7602: ,p_msg_name => 'XLA_COMMON_ERROR'
7603: ,p_token_1 => 'LOCATION'
7604: ,p_value_1 => 'xla_balances_pkg.massive_update'
7605: ,p_token_2 => 'ERROR'
7606: ,p_value_2 => 'EXCEPTION: IF p_request_id is not NULL, p_entity_id must be NULL');
7607:
7608: ELSIF p_event_id IS NOT NULL

Line 7622: ,p_value_1 => 'xla_balances_pkg.massive_update'

7618: xla_exceptions_pkg.raise_message
7619: (p_appli_s_name => 'XLA'
7620: ,p_msg_name => 'XLA_COMMON_ERROR'
7621: ,p_token_1 => 'LOCATION'
7622: ,p_value_1 => 'xla_balances_pkg.massive_update'
7623: ,p_token_2 => 'ERROR'
7624: ,p_value_2 => 'EXCEPTION: IF p_request_id is not NULL, p_event_id must be NULL');
7625:
7626: ELSIF p_accounting_batch_id IS NOT NULL

Line 7640: ,p_value_1 => 'xla_balances_pkg.massive_update'

7636: xla_exceptions_pkg.raise_message
7637: (p_appli_s_name => 'XLA'
7638: ,p_msg_name => 'XLA_COMMON_ERROR'
7639: ,p_token_1 => 'LOCATION'
7640: ,p_value_1 => 'xla_balances_pkg.massive_update'
7641: ,p_token_2 => 'ERROR'
7642: ,p_value_2 => 'EXCEPTION: IF p_request_id is not NULL, p_accounting_batch_id must be NULL');
7643: END IF;
7644: END IF;

Line 7661: ,p_value_1 => 'xla_balances_pkg.massive_update'

7657: xla_exceptions_pkg.raise_message
7658: (p_appli_s_name => 'XLA'
7659: ,p_msg_name => 'XLA_COMMON_ERROR'
7660: ,p_token_1 => 'LOCATION'
7661: ,p_value_1 => 'xla_balances_pkg.massive_update'
7662: ,p_token_2 => 'ERROR'
7663: ,p_value_2 => 'EXCEPTION: Invalid p_update_mode parameter: '|| p_update_mode);
7664: END IF;
7665:

Line 7681: ,p_value_1 => 'xla_balances_pkg.massive_update'

7677: xla_exceptions_pkg.raise_message
7678: (p_appli_s_name => 'XLA'
7679: ,p_msg_name => 'XLA_COMMON_ERROR'
7680: ,p_token_1 => 'LOCATION'
7681: ,p_value_1 => 'xla_balances_pkg.massive_update'
7682: ,p_token_2 => 'ERROR'
7683: ,p_value_2 => 'EXCEPTION: Invalid p_execution_mode parameter: '|| p_execution_mode);
7684:
7685: END IF;

Line 7705: ,p_value_1 => 'xla_balances_pkg.massive_update'

7701: xla_exceptions_pkg.raise_message
7702: (p_appli_s_name => 'XLA'
7703: ,p_msg_name => 'XLA_COMMON_ERROR'
7704: ,p_token_1 => 'LOCATION'
7705: ,p_value_1 => 'xla_balances_pkg.massive_update'
7706: ,p_token_2 => 'ERROR'
7707: ,p_value_2 => 'EXCEPTION: When p_execution_mode is C, p_event_id, must be NULL');
7708:
7709: ELSIF p_request_id IS NOT NULL

Line 7723: ,p_value_1 => 'xla_balances_pkg.massive_update'

7719: xla_exceptions_pkg.raise_message
7720: (p_appli_s_name => 'XLA'
7721: ,p_msg_name => 'XLA_COMMON_ERROR'
7722: ,p_token_1 => 'LOCATION'
7723: ,p_value_1 => 'xla_balances_pkg.massive_update'
7724: ,p_token_2 => 'ERROR'
7725: ,p_value_2 => 'EXCEPTION: When p_execution_mode is C, p_request_id, must be NULL');
7726:
7727: ELSIF p_entity_id IS NOT NULL

Line 7741: ,p_value_1 => 'xla_balances_pkg.massive_update'

7737: xla_exceptions_pkg.raise_message
7738: (p_appli_s_name => 'XLA'
7739: ,p_msg_name => 'XLA_COMMON_ERROR'
7740: ,p_token_1 => 'LOCATION'
7741: ,p_value_1 => 'xla_balances_pkg.massive_update'
7742: ,p_token_2 => 'ERROR'
7743: ,p_value_2 => 'EXCEPTION: When p_execution_mode is C, p_entity_id, must be NULL');
7744:
7745: END IF;

Line 7813: ,p_value_1 => 'xla_balances_pkg.massive_update'

7809: xla_exceptions_pkg.raise_message
7810: (p_appli_s_name => 'XLA'
7811: ,p_msg_name => 'XLA_COMMON_ERROR'
7812: ,p_token_1 => 'LOCATION'
7813: ,p_value_1 => 'xla_balances_pkg.massive_update'
7814: ,p_token_2 => 'ERROR'
7815: ,p_value_2 => 'EXCEPTION: Invalid value for parameter p_execution_mode: ' || p_execution_mode);
7816:
7817: END IF;

Line 7833: (p_location => 'xla_balances_pkg.massive_update');

7829: WHEN xla_exceptions_pkg.application_exception THEN
7830: RAISE;
7831: WHEN OTHERS THEN
7832: xla_exceptions_pkg.raise_message
7833: (p_location => 'xla_balances_pkg.massive_update');
7834: END massive_update;
7835:
7836:
7837: FUNCTION recreation_common

Line 8434: (p_location => 'xla_balances_pkg.recreation_common');

8430: WHEN xla_exceptions_pkg.application_exception THEN
8431: RAISE;
8432: WHEN OTHERS THEN
8433: xla_exceptions_pkg.raise_message
8434: (p_location => 'xla_balances_pkg.recreation_common');
8435:
8436: END recreation_common;
8437:
8438:

Line 8783: (p_location => 'xla_balances_pkg.recreation_detailed');

8779: WHEN xla_exceptions_pkg.application_exception THEN
8780: RAISE;
8781: WHEN OTHERS THEN
8782: xla_exceptions_pkg.raise_message
8783: (p_location => 'xla_balances_pkg.recreation_detailed');
8784:
8785: END recreation_detailed;
8786:
8787:

Line 9002: (p_location => 'xla_balances_pkg.recreation_massive');

8998: WHEN xla_exceptions_pkg.application_exception THEN
8999: RAISE;
9000: WHEN OTHERS THEN
9001: xla_exceptions_pkg.raise_message
9002: (p_location => 'xla_balances_pkg.recreation_massive');
9003:
9004: END recreation_massive;
9005:
9006:

Line 9211: (p_location => 'xla_balances_pkg.recreate');

9207: ,p_level => C_LEVEL_EXCEPTION
9208: );
9209: END IF;
9210: xla_exceptions_pkg.raise_message
9211: (p_location => 'xla_balances_pkg.recreate');
9212: END IF;
9213:
9214: l_return_value := TRUE;
9215:

Line 9230: (p_location => 'xla_balances_pkg.recreate');

9226: WHEN xla_exceptions_pkg.application_exception THEN
9227: RAISE;
9228: WHEN OTHERS THEN
9229: xla_exceptions_pkg.raise_message
9230: (p_location => 'xla_balances_pkg.recreate');
9231:
9232: END recreate;
9233:
9234:

Line 9322: (p_location => 'xla_balances_pkg.synchronize');

9318: ,p_level => C_LEVEL_EXCEPTION
9319: );
9320: END IF;
9321: xla_exceptions_pkg.raise_message
9322: (p_location => 'xla_balances_pkg.synchronize');
9323: END IF;
9324:
9325: LOOP
9326: EXECUTE IMMEDIATE

Line 9397: (p_location => 'xla_balances_pkg.synchronize');

9393: ,p_level => C_LEVEL_EXCEPTION
9394: );
9395: END IF;
9396: xla_exceptions_pkg.raise_message
9397: (p_location => 'xla_balances_pkg.synchronize');
9398: END IF;
9399:
9400: IF NVL(l_min_reference3,'N') = 'N'
9401: THEN

Line 9779: (p_location => 'xla_balances_pkg.synchronize');

9775: WHEN xla_exceptions_pkg.application_exception THEN
9776: RAISE;
9777: WHEN OTHERS THEN
9778: xla_exceptions_pkg.raise_message
9779: (p_location => 'xla_balances_pkg.synchronize');
9780: END synchronize;
9781:
9782: PROCEDURE open_period_srs
9783: ( p_errbuf OUT NOCOPY VARCHAR2

Line 9918: (p_location => 'xla_balances_pkg.open_period');

9914: ,p_level => C_LEVEL_EXCEPTION
9915: );
9916: END IF;
9917: xla_exceptions_pkg.raise_message
9918: (p_location => 'xla_balances_pkg.open_period');
9919: END IF;
9920:
9921: l_return_value := TRUE;
9922:

Line 9936: (p_location => 'xla_balances_pkg.open_period');

9932: WHEN xla_exceptions_pkg.application_exception THEN
9933: RAISE;
9934: WHEN OTHERS THEN
9935: xla_exceptions_pkg.raise_message
9936: (p_location => 'xla_balances_pkg.open_period');
9937: END open_period;
9938:
9939:
9940: PROCEDURE handle_fake_journal_entry

Line 10110: (p_location => 'xla_balances_pkg.handle_fake_journal_entry');

10106: ,p_level => C_LEVEL_EXCEPTION
10107: );
10108: END IF;
10109: xla_exceptions_pkg.raise_message
10110: (p_location => 'xla_balances_pkg.handle_fake_journal_entry');
10111: END IF;
10112:
10113: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
10114: trace

Line 10125: (p_location => 'xla_balances_pkg.handle_fake_journal_entry');

10121: WHEN xla_exceptions_pkg.application_exception THEN
10122: RAISE;
10123: WHEN OTHERS THEN
10124: xla_exceptions_pkg.raise_message
10125: (p_location => 'xla_balances_pkg.handle_fake_journal_entry');
10126: END handle_fake_journal_entry;
10127:
10128:
10129: FUNCTION initialize

Line 10262: (p_location => 'xla_balances_pkg.initialize');

10258: ,p_level => C_LEVEL_EXCEPTION
10259: );
10260: END IF;
10261: xla_exceptions_pkg.raise_message
10262: (p_location => 'xla_balances_pkg.initialize');
10263: END IF;
10264:
10265: IF p_new_beginning_balance_dr IS NULL
10266: AND p_new_beginning_balance_cr IS NULL

Line 10277: (p_location => 'xla_balances_pkg.initialize');

10273: ,p_level => C_LEVEL_EXCEPTION
10274: );
10275: END IF;
10276: xla_exceptions_pkg.raise_message
10277: (p_location => 'xla_balances_pkg.initialize');
10278: END IF;
10279:
10280: IF xla_control_accounts_pkg.C_IS_CONTROL_ACCOUNT
10281: = xla_control_accounts_pkg.is_control_account

Line 10327: (p_location => 'xla_balances_pkg.initialize');

10323: ,p_level => C_LEVEL_EXCEPTION
10324: );
10325: END IF;
10326: xla_exceptions_pkg.raise_message
10327: (p_location => 'xla_balances_pkg.initialize');
10328: END IF;
10329:
10330: BEGIN
10331: SELECT xba.period_name

Line 10377: (p_location => 'xla_balances_pkg.initialize');

10373: ,p_level => C_LEVEL_EXCEPTION
10374: );
10375: END IF;
10376: xla_exceptions_pkg.raise_message
10377: (p_location => 'xla_balances_pkg.initialize');
10378: END IF;
10379:
10380: UPDATE xla_control_balances xba
10381: SET xba.initial_balance_flag = 'N'

Line 10459: (p_location => 'xla_balances_pkg.initialize');

10455: ,p_level => C_LEVEL_EXCEPTION
10456: );
10457: END IF;
10458: xla_exceptions_pkg.raise_message
10459: (p_location => 'xla_balances_pkg.initialize');
10460: END IF;
10461:
10462: --Delete fake entries
10463: handle_fake_journal_entry

Line 10507: (p_location => 'xla_balances_pkg.initialize');

10503: WHEN xla_exceptions_pkg.application_exception THEN
10504: RAISE;
10505: WHEN OTHERS THEN
10506: xla_exceptions_pkg.raise_message
10507: (p_location => 'xla_balances_pkg.initialize');
10508: END initialize;
10509:
10510: FUNCTION open_period_event ( p_subscription_guid IN raw
10511: ,p_event IN OUT NOCOPY WF_EVENT_T)

Line 10598: END xla_balances_pkg;

10594: g_prog_id := xla_environment_pkg.g_prog_id;
10595: g_req_id := NVL(xla_environment_pkg.g_req_id, -1);
10596:
10597: g_cached_single_period := FALSE;
10598: END xla_balances_pkg;