210: fnd_log.string(p_level, p_module, p_msg);
211: END IF;
212:
213: EXCEPTION
214: WHEN xla_exceptions_pkg.application_exception THEN
215: RAISE;
216: WHEN OTHERS THEN
217: xla_exceptions_pkg.raise_message
218: (p_location => 'xla_balances_pkg.trace');
213: EXCEPTION
214: WHEN xla_exceptions_pkg.application_exception THEN
215: RAISE;
216: WHEN OTHERS THEN
217: xla_exceptions_pkg.raise_message
218: (p_location => 'xla_balances_pkg.trace');
219: END trace;
220:
221:
277: p_chart_of_accounts_id
278: ,p_level => C_LEVEL_EXCEPTION
279: );
280: END IF;
281: xla_exceptions_pkg.raise_message
282: (p_appli_s_name => 'XLA'
283: ,p_msg_name => 'XLA_COMMON_ERROR'
284: ,p_token_1 => 'LOCATION'
285: ,p_value_1 => 'xla_balances_pkg.pre_accounting'
290:
291: RETURN l_account_segment_column;
292:
293: EXCEPTION
294: WHEN xla_exceptions_pkg.application_exception
295: THEN
296: RAISE;
297: WHEN OTHERS
298: THEN
295: THEN
296: RAISE;
297: WHEN OTHERS
298: THEN
299: xla_exceptions_pkg.raise_message
300: (p_location => 'xla_balances_pkg.get_account_segment_column');
301: END get_account_segment_column;
302:
303:
431: || 'cannot be both NULL'
432: ,p_level => C_LEVEL_EXCEPTION
433: );
434: END IF;
435: xla_exceptions_pkg.raise_message
436: (p_appli_s_name => 'XLA'
437: ,p_msg_name => 'XLA_COMMON_ERROR'
438: ,p_token_1 => 'LOCATION'
439: ,p_value_1 => 'xla_balances_pkg.pre_accounting'
453: 'p_source_effective_period_num cannot be NULL'
454: ,p_level => C_LEVEL_EXCEPTION
455: );
456: END IF;
457: xla_exceptions_pkg.raise_message
458: (p_appli_s_name => 'XLA'
459: ,p_msg_name => 'XLA_COMMON_ERROR'
460: ,p_token_1 => 'LOCATION'
461: ,p_value_1 => 'xla_balances_pkg.pre_accounting'
1041:
1042: RETURN l_return_value;
1043:
1044: EXCEPTION
1045: WHEN xla_exceptions_pkg.application_exception
1046: THEN
1047: RAISE;
1048: WHEN OTHERS
1049: THEN
1046: THEN
1047: RAISE;
1048: WHEN OTHERS
1049: THEN
1050: xla_exceptions_pkg.raise_message
1051: (p_location => 'xla_balances_pkg.move_balances_forward_COMMIT');
1052: END move_balances_forward_COMMIT;
1053:
1054:
1197:
1198: RETURN l_return_value;
1199:
1200: EXCEPTION
1201: WHEN xla_exceptions_pkg.application_exception THEN
1202: RAISE;
1203: WHEN OTHERS THEN
1204: xla_exceptions_pkg.raise_message
1205: (p_location => 'xla_balances_pkg.check_create_period_balances');
1200: EXCEPTION
1201: WHEN xla_exceptions_pkg.application_exception THEN
1202: RAISE;
1203: WHEN OTHERS THEN
1204: xla_exceptions_pkg.raise_message
1205: (p_location => 'xla_balances_pkg.check_create_period_balances');
1206: END check_create_period_balances;
1207:
1208:
1280:
1281: RETURN l_return_value;
1282:
1283: EXCEPTION
1284: WHEN xla_exceptions_pkg.application_exception THEN
1285: RAISE;
1286: WHEN OTHERS THEN
1287: xla_exceptions_pkg.raise_message
1288: (p_location => 'xla_balances_pkg.AUT_check_create_period_bals');
1283: EXCEPTION
1284: WHEN xla_exceptions_pkg.application_exception THEN
1285: RAISE;
1286: WHEN OTHERS THEN
1287: xla_exceptions_pkg.raise_message
1288: (p_location => 'xla_balances_pkg.AUT_check_create_period_bals');
1289: END AUT_check_create_period_bals;
1290:
1291: FUNCTION lock_create_balance_statuses
1526: || i.ledger_id
1527: ,p_level => C_LEVEL_EXCEPTION
1528: );
1529: END IF;
1530: xla_exceptions_pkg.raise_message
1531: (p_appli_s_name => 'XLA'
1532: ,p_msg_name => 'XLA_COMMON_ERROR'
1533: ,p_token_1 => 'LOCATION'
1534: ,p_value_1 => 'xla_balances_pkg.pre_accounting'
1675: ,p_msg => 'END ' || l_log_module
1676: ,p_level => C_LEVEL_PROCEDURE);
1677: END IF;
1678: RETURN FALSE;
1679: WHEN xla_exceptions_pkg.application_exception THEN
1680: RAISE;
1681: WHEN OTHERS THEN
1682: xla_exceptions_pkg.raise_message
1683: (p_location => 'xla_balances_pkg.lock_create_balance_statuses');
1678: RETURN FALSE;
1679: WHEN xla_exceptions_pkg.application_exception THEN
1680: RAISE;
1681: WHEN OTHERS THEN
1682: xla_exceptions_pkg.raise_message
1683: (p_location => 'xla_balances_pkg.lock_create_balance_statuses');
1684: END lock_create_balance_statuses;
1685:
1686: FUNCTION calculate_control_balances
2418:
2419: RETURN TRUE;
2420:
2421: EXCEPTION
2422: WHEN xla_exceptions_pkg.application_exception THEN
2423: RAISE;
2424: WHEN OTHERS THEN
2425: xla_exceptions_pkg.raise_message
2426: (p_location => 'xla_balances_pkg.calculate_control_balances');
2421: EXCEPTION
2422: WHEN xla_exceptions_pkg.application_exception THEN
2423: RAISE;
2424: WHEN OTHERS THEN
2425: xla_exceptions_pkg.raise_message
2426: (p_location => 'xla_balances_pkg.calculate_control_balances');
2427: END calculate_control_balances;
2428:
2429: FUNCTION calculate_analytical_balances
3153:
3154: RETURN TRUE;
3155:
3156: EXCEPTION
3157: WHEN xla_exceptions_pkg.application_exception THEN
3158: RAISE;
3159: WHEN OTHERS THEN
3160: xla_exceptions_pkg.raise_message
3161: (p_location => 'xla_balances_pkg.calculate_analytical_balances');
3156: EXCEPTION
3157: WHEN xla_exceptions_pkg.application_exception THEN
3158: RAISE;
3159: WHEN OTHERS THEN
3160: xla_exceptions_pkg.raise_message
3161: (p_location => 'xla_balances_pkg.calculate_analytical_balances');
3162: END calculate_analytical_balances;
3163:
3164:
3294: 'parameters cannot be NULL'
3295: ,p_level => C_LEVEL_EXCEPTION
3296: );
3297: END IF;
3298: xla_exceptions_pkg.raise_message
3299: (p_appli_s_name => 'XLA'
3300: ,p_msg_name => 'XLA_COMMON_ERROR'
3301: ,p_token_1 => 'LOCATION'
3302: ,p_value_1 => 'xla_balances_pkg.pre_accounting'
3317: 'If p_balance_source_code is not ''A'' party parameters cannot be NULL'
3318: ,p_level => C_LEVEL_EXCEPTION
3319: );
3320: END IF;
3321: xla_exceptions_pkg.raise_message
3322: (p_appli_s_name => 'XLA'
3323: ,p_msg_name => 'XLA_COMMON_ERROR'
3324: ,p_token_1 => 'LOCATION'
3325: ,p_value_1 => 'xla_balances_pkg.pre_accounting'
3345: 'If p_balance_source_code is not ''C'' analytical detail parameter cannot be NULL'
3346: ,p_level => C_LEVEL_EXCEPTION
3347: );
3348: END IF;
3349: xla_exceptions_pkg.raise_message
3350: (p_appli_s_name => 'XLA'
3351: ,p_msg_name => 'XLA_COMMON_ERROR'
3352: ,p_token_1 => 'LOCATION'
3353: ,p_value_1 => 'xla_balances_pkg.pre_accounting'
3731:
3732: RETURN TRUE;
3733:
3734: EXCEPTION
3735: WHEN xla_exceptions_pkg.application_exception
3736: THEN
3737: RAISE;
3738: WHEN OTHERS
3739: THEN
3736: THEN
3737: RAISE;
3738: WHEN OTHERS
3739: THEN
3740: xla_exceptions_pkg.raise_message
3741: (p_location => 'xla_balances_pkg.move_identified_bals_forward');
3742: END move_identified_bals_forward;
3743:
3744: PROCEDURE build_line_selection_dyn_stmts
4175: 'Invalid value for p_commit_flag: ' || p_commit_flag
4176: ,p_level => C_LEVEL_EXCEPTION
4177: );
4178: END IF;
4179: xla_exceptions_pkg.raise_message
4180: (p_appli_s_name => 'XLA'
4181: ,p_msg_name => 'XLA_COMMON_ERROR'
4182: ,p_token_1 => 'LOCATION'
4183: ,p_value_1 => 'xla_balances_pkg.pre_accounting'
4255: ,p_level => C_LEVEL_ERROR
4256: );
4257: END IF;
4258: RAISE;
4259: WHEN xla_exceptions_pkg.application_exception
4260: THEN
4261: RAISE;
4262: WHEN OTHERS
4263: THEN
4260: THEN
4261: RAISE;
4262: WHEN OTHERS
4263: THEN
4264: xla_exceptions_pkg.raise_message
4265: (p_location => 'xla_balances_pkg.build_line_selection_dyn_stmts');
4266: END build_line_selection_dyn_stmts;
4267:
4268:
4994: ,p_level => C_LEVEL_ERROR
4995: );
4996: END IF;
4997: RAISE;
4998: WHEN xla_exceptions_pkg.application_exception
4999: THEN
5000: RAISE;
5001: WHEN OTHERS
5002: THEN
4999: THEN
5000: RAISE;
5001: WHEN OTHERS
5002: THEN
5003: xla_exceptions_pkg.raise_message
5004: (p_location => 'xla_balances_pkg.load_balance_temp_tables');
5005: END load_balance_temp_tables;
5006:
5007:
5289: || p_operation_code
5290: ,p_level => C_LEVEL_EXCEPTION
5291: );
5292: END IF;
5293: xla_exceptions_pkg.raise_message
5294: (p_appli_s_name => 'XLA'
5295: ,p_msg_name => 'XLA_COMMON_ERROR'
5296: ,p_token_1 => 'LOCATION'
5297: ,p_value_1 => 'xla_balances_pkg.pre_accounting'
5319:
5320: RETURN l_row_count;
5321:
5322: EXCEPTION
5323: WHEN xla_exceptions_pkg.application_exception
5324: THEN
5325: RAISE;
5326: WHEN OTHERS
5327: THEN
5324: THEN
5325: RAISE;
5326: WHEN OTHERS
5327: THEN
5328: xla_exceptions_pkg.raise_message
5329: (p_location => 'xla_balances_pkg.load_alyt_secondary_temp_tabs');
5330: END load_alyt_secondary_temp_tabs;
5331:
5332:
5554: 'Invalid value for p_operation_code: ' || p_operation_code
5555: ,p_level => C_LEVEL_EXCEPTION
5556: );
5557: END IF;
5558: xla_exceptions_pkg.raise_message
5559: (p_appli_s_name => 'XLA'
5560: ,p_msg_name => 'XLA_COMMON_ERROR'
5561: ,p_token_1 => 'LOCATION'
5562: ,p_value_1 => 'xla_balances_pkg.pre_accounting'
5584:
5585: RETURN l_row_count;
5586:
5587: EXCEPTION
5588: WHEN xla_exceptions_pkg.application_exception
5589: THEN
5590: RAISE;
5591: WHEN OTHERS
5592: THEN
5589: THEN
5590: RAISE;
5591: WHEN OTHERS
5592: THEN
5593: xla_exceptions_pkg.raise_message
5594: (p_location => 'xla_balances_pkg.load_ctrl_secondary_temp_tabs');
5595: END load_ctrl_secondary_temp_tabs;
5596:
5597:
5824: 'Unsupported combinations of parameters'
5825: ,p_level => C_LEVEL_EXCEPTION
5826: );
5827: END IF;
5828: xla_exceptions_pkg.raise_message
5829: (p_appli_s_name => 'XLA'
5830: ,p_msg_name => 'XLA_COMMON_ERROR'
5831: ,p_token_1 => 'LOCATION'
5832: ,p_value_1 => 'xla_balances_pkg.pre_accounting'
5851: ,p_level => C_LEVEL_PROCEDURE);
5852: END IF;
5853:
5854: EXCEPTION
5855: WHEN xla_exceptions_pkg.application_exception
5856: THEN
5857: RAISE;
5858: WHEN OTHERS
5859: THEN
5856: THEN
5857: RAISE;
5858: WHEN OTHERS
5859: THEN
5860: xla_exceptions_pkg.raise_message
5861: (p_location => 'xla_balances_pkg.insert_ledger_period_statuses');
5862: END insert_ledger_period_statuses;
5863:
5864:
6150: ,p_level => C_LEVEL_PROCEDURE);
6151: END IF;
6152:
6153: EXCEPTION
6154: WHEN xla_exceptions_pkg.application_exception
6155: THEN
6156: RAISE;
6157: WHEN OTHERS
6158: THEN
6155: THEN
6156: RAISE;
6157: WHEN OTHERS
6158: THEN
6159: xla_exceptions_pkg.raise_message
6160: (p_location => 'xla_balances_pkg.cache_ledger_period_statuses');
6161: END cache_ledger_period_statuses;
6162:
6163:
6342: p_commit_flag
6343: ,p_level => C_LEVEL_EXCEPTION
6344: );
6345: END IF;
6346: xla_exceptions_pkg.raise_message
6347: (p_appli_s_name => 'XLA'
6348: ,p_msg_name => 'XLA_COMMON_ERROR'
6349: ,p_token_1 => 'LOCATION'
6350: ,p_value_1 => 'xla_balances_pkg.pre_accounting'
6376: 'Unkown p_update_mode value: ' || p_update_mode
6377: ,p_level => C_LEVEL_EXCEPTION
6378: );
6379: END IF;
6380: xla_exceptions_pkg.raise_message
6381: (p_appli_s_name => 'XLA'
6382: ,p_msg_name => 'XLA_COMMON_ERROR'
6383: ,p_token_1 => 'LOCATION'
6384: ,p_value_1 => 'xla_balances_pkg.pre_accounting'
6397: 'Unsupported p_balance_source_code value: ' || p_balance_source_code
6398: ,p_level => C_LEVEL_EXCEPTION
6399: );
6400: END IF;
6401: xla_exceptions_pkg.raise_message
6402: (p_appli_s_name => 'XLA'
6403: ,p_msg_name => 'XLA_COMMON_ERROR'
6404: ,p_token_1 => 'LOCATION'
6405: ,p_value_1 => 'xla_balances_pkg.pre_accounting'
6700: 'Unsupported p_update_mode value: ' || p_update_mode
6701: ,p_level => C_LEVEL_EXCEPTION
6702: );
6703: END IF;
6704: xla_exceptions_pkg.raise_message
6705: (p_appli_s_name => 'XLA'
6706: ,p_msg_name => 'XLA_COMMON_ERROR'
6707: ,p_token_1 => 'LOCATION'
6708: ,p_value_1 => 'xla_balances_pkg.pre_accounting'
7013: 'Unkown p_commit_flag value: ' || p_commit_flag
7014: ,p_level => C_LEVEL_EXCEPTION
7015: );
7016: END IF;
7017: xla_exceptions_pkg.raise_message
7018: (p_appli_s_name => 'XLA'
7019: ,p_msg_name => 'XLA_COMMON_ERROR'
7020: ,p_token_1 => 'LOCATION'
7021: ,p_value_1 => 'xla_balances_pkg.pre_accounting'
7056: ,p_level => C_LEVEL_PROCEDURE);
7057: END IF;
7058: ROLLBACK TO SAVEPOINT_INCREMENTAL;
7059: RETURN FALSE;
7060: WHEN xla_exceptions_pkg.application_exception THEN
7061: RAISE;
7062: WHEN OTHERS THEN
7063: xla_exceptions_pkg.raise_message
7064: (p_location => 'xla_balances_pkg.calculate_balances');
7059: RETURN FALSE;
7060: WHEN xla_exceptions_pkg.application_exception THEN
7061: RAISE;
7062: WHEN OTHERS THEN
7063: xla_exceptions_pkg.raise_message
7064: (p_location => 'xla_balances_pkg.calculate_balances');
7065:
7066: END calculate_balances;
7067:
7096: 'Unsupported value for p_update_mode: ' || p_update_mode
7097: ,p_level => C_LEVEL_EXCEPTION
7098: );
7099: END IF;
7100: xla_exceptions_pkg.raise_message
7101: (p_appli_s_name => 'XLA'
7102: ,p_msg_name => 'XLA_COMMON_ERROR'
7103: ,p_token_1 => 'LOCATION'
7104: ,p_value_1 => 'xla_balances_pkg.pre_accounting'
7133:
7134: RETURN TRUE;
7135:
7136: EXCEPTION
7137: WHEN xla_exceptions_pkg.application_exception THEN
7138: RAISE;
7139: WHEN OTHERS THEN
7140: xla_exceptions_pkg.raise_message
7141: (p_location => 'xla_balances_pkg.event_set_update');
7136: EXCEPTION
7137: WHEN xla_exceptions_pkg.application_exception THEN
7138: RAISE;
7139: WHEN OTHERS THEN
7140: xla_exceptions_pkg.raise_message
7141: (p_location => 'xla_balances_pkg.event_set_update');
7142: END event_set_update;
7143:
7144:
7184: 'p_application_id cannot be NULL'
7185: ,p_level => C_LEVEL_EXCEPTION
7186: );
7187: END IF;
7188: xla_exceptions_pkg.raise_message
7189: (p_appli_s_name => 'XLA'
7190: ,p_msg_name => 'XLA_COMMON_ERROR'
7191: ,p_token_1 => 'LOCATION'
7192: ,p_value_1 => 'xla_balances_pkg.pre_accounting'
7204: 'p_ae_header_id cannot be NULL'
7205: ,p_level => C_LEVEL_EXCEPTION
7206: );
7207: END IF;
7208: xla_exceptions_pkg.raise_message
7209: (p_appli_s_name => 'XLA'
7210: ,p_msg_name => 'XLA_COMMON_ERROR'
7211: ,p_token_1 => 'LOCATION'
7212: ,p_value_1 => 'xla_balances_pkg.pre_accounting'
7224: 'p_update_mode cannot be NULL'
7225: ,p_level => C_LEVEL_EXCEPTION
7226: );
7227: END IF;
7228: xla_exceptions_pkg.raise_message
7229: (p_appli_s_name => 'XLA'
7230: ,p_msg_name => 'XLA_COMMON_ERROR'
7231: ,p_token_1 => 'LOCATION'
7232: ,p_value_1 => 'xla_balances_pkg.pre_accounting'
7242: 'Unsupported value for p_update_mode: ' || p_update_mode
7243: ,p_level => C_LEVEL_EXCEPTION
7244: );
7245: END IF;
7246: xla_exceptions_pkg.raise_message
7247: (p_appli_s_name => 'XLA'
7248: ,p_msg_name => 'XLA_COMMON_ERROR'
7249: ,p_token_1 => 'LOCATION'
7250: ,p_value_1 => 'xla_balances_pkg.pre_accounting'
7264: , p_execution_mode => 'O'
7265: , p_concurrency_class => 'BALANCES_CALCULATION'
7266: )
7267: THEN
7268: xla_exceptions_pkg.raise_message
7269: (p_appli_s_name => 'XLA'
7270: , p_msg_name => 'XLA_COMMON_ERROR'
7271: , p_token_1 => 'LOCATION'
7272: , p_value_1 => 'xla_balances_pkg.MASSIVE_UPDATE'
7307:
7308: RETURN TRUE; -- Bug 14115273
7309:
7310: EXCEPTION
7311: WHEN xla_exceptions_pkg.application_exception THEN
7312: DELETE xla_bal_concurrency_control where request_id=-1*p_ae_header_id;
7313: RAISE;
7314: WHEN OTHERS THEN
7315: xla_exceptions_pkg.raise_message
7311: WHEN xla_exceptions_pkg.application_exception THEN
7312: DELETE xla_bal_concurrency_control where request_id=-1*p_ae_header_id;
7313: RAISE;
7314: WHEN OTHERS THEN
7315: xla_exceptions_pkg.raise_message
7316: (p_location => 'xla_balances_pkg.single_update');
7317: DELETE xla_bal_concurrency_control where request_id=-1*p_ae_header_id;
7318: RETURN TRUE; -- Bug 14115273
7319: END single_update;
7398: , p_execution_mode => 'C'
7399: , p_concurrency_class => 'BALANCES_CALCULATION'
7400: )
7401: THEN
7402: xla_exceptions_pkg.raise_message
7403: (p_appli_s_name => 'XLA'
7404: , p_msg_name => 'XLA_COMMON_ERROR'
7405: , p_token_1 => 'LOCATION'
7406: , p_value_1 => 'xla_balances_pkg.massive_update_srs'
7447: ,p_level => C_LEVEL_PROCEDURE);
7448: END IF;
7449:
7450: EXCEPTION
7451: WHEN xla_exceptions_pkg.application_exception THEN
7452: DELETE xla_bal_concurrency_control where request_id = g_req_id; -- bug16073423
7453: p_retcode := 2;
7454: p_errbuf := sqlerrm;
7455: WHEN OTHERS THEN
7488: 'p_application_id cannot be NULL'
7489: ,p_level => C_LEVEL_EXCEPTION
7490: );
7491: END IF;
7492: xla_exceptions_pkg.raise_message
7493: (p_appli_s_name => 'XLA'
7494: ,p_msg_name => 'XLA_COMMON_ERROR'
7495: ,p_token_1 => 'LOCATION'
7496: ,p_value_1 => 'xla_balances_pkg.pre_accounting'
7519:
7520: return TRUE; -- Bug 14115273
7521:
7522: EXCEPTION
7523: WHEN xla_exceptions_pkg.application_exception THEN
7524: RAISE;
7525: WHEN OTHERS THEN
7526: xla_exceptions_pkg.raise_message
7527: (p_location => 'xla_balances_pkg.massive_update_for_events');
7522: EXCEPTION
7523: WHEN xla_exceptions_pkg.application_exception THEN
7524: RAISE;
7525: WHEN OTHERS THEN
7526: xla_exceptions_pkg.raise_message
7527: (p_location => 'xla_balances_pkg.massive_update_for_events');
7528: return TRUE; -- Bug 14115273
7529: END massive_update_for_events;
7530:
7579: ,p_level => C_LEVEL_EXCEPTION
7580: );
7581: END IF;
7582:
7583: xla_exceptions_pkg.raise_message
7584: (p_appli_s_name => 'XLA'
7585: ,p_msg_name => 'XLA_COMMON_ERROR'
7586: ,p_token_1 => 'LOCATION'
7587: ,p_value_1 => 'xla_balances_pkg.massive_update'
7603: 'IF p_entity_id is not NULL, p_ledger_id must be NULL '
7604: ,p_level => C_LEVEL_EXCEPTION
7605: );
7606: END IF;
7607: xla_exceptions_pkg.raise_message
7608: (p_appli_s_name => 'XLA'
7609: ,p_msg_name => 'XLA_COMMON_ERROR'
7610: ,p_token_1 => 'LOCATION'
7611: ,p_value_1 => 'xla_balances_pkg.massive_update'
7621: 'IF p_entity_id is not NULL, p_event_id must be NULL '
7622: ,p_level => C_LEVEL_EXCEPTION
7623: );
7624: END IF;
7625: xla_exceptions_pkg.raise_message
7626: (p_appli_s_name => 'XLA'
7627: ,p_msg_name => 'XLA_COMMON_ERROR'
7628: ,p_token_1 => 'LOCATION'
7629: ,p_value_1 => 'xla_balances_pkg.massive_update'
7638: 'IF p_entity_id is not NULL, p_request_id must be NULL '
7639: ,p_level => C_LEVEL_EXCEPTION
7640: );
7641: END IF;
7642: xla_exceptions_pkg.raise_message
7643: (p_appli_s_name => 'XLA'
7644: ,p_msg_name => 'XLA_COMMON_ERROR'
7645: ,p_token_1 => 'LOCATION'
7646: ,p_value_1 => 'xla_balances_pkg.massive_update'
7656: 'IF p_entity_id is not NULL, p_accounting_batch_id must be NULL '
7657: ,p_level => C_LEVEL_EXCEPTION
7658: );
7659: END IF;
7660: xla_exceptions_pkg.raise_message
7661: (p_appli_s_name => 'XLA'
7662: ,p_msg_name => 'XLA_COMMON_ERROR'
7663: ,p_token_1 => 'LOCATION'
7664: ,p_value_1 => 'xla_balances_pkg.massive_update'
7681: 'IF p_request_id is not NULL, p_ledger_id must be NULL '
7682: ,p_level => C_LEVEL_EXCEPTION
7683: );
7684: END IF;
7685: xla_exceptions_pkg.raise_message
7686: (p_appli_s_name => 'XLA'
7687: ,p_msg_name => 'XLA_COMMON_ERROR'
7688: ,p_token_1 => 'LOCATION'
7689: ,p_value_1 => 'xla_balances_pkg.massive_update'
7699: 'IF p_request_id is not NULL, p_entity_id must be NULL '
7700: ,p_level => C_LEVEL_EXCEPTION
7701: );
7702: END IF;
7703: xla_exceptions_pkg.raise_message
7704: (p_appli_s_name => 'XLA'
7705: ,p_msg_name => 'XLA_COMMON_ERROR'
7706: ,p_token_1 => 'LOCATION'
7707: ,p_value_1 => 'xla_balances_pkg.massive_update'
7717: 'IF p_request_id is not NULL, p_event_id must be NULL '
7718: ,p_level => C_LEVEL_EXCEPTION
7719: );
7720: END IF;
7721: xla_exceptions_pkg.raise_message
7722: (p_appli_s_name => 'XLA'
7723: ,p_msg_name => 'XLA_COMMON_ERROR'
7724: ,p_token_1 => 'LOCATION'
7725: ,p_value_1 => 'xla_balances_pkg.massive_update'
7735: 'IF p_request_id is not NULL, p_accounting_batch_id must be NULL '
7736: ,p_level => C_LEVEL_EXCEPTION
7737: );
7738: END IF;
7739: xla_exceptions_pkg.raise_message
7740: (p_appli_s_name => 'XLA'
7741: ,p_msg_name => 'XLA_COMMON_ERROR'
7742: ,p_token_1 => 'LOCATION'
7743: ,p_value_1 => 'xla_balances_pkg.massive_update'
7756: 'Invalid p_update_mode parameter: '|| p_update_mode
7757: ,p_level => C_LEVEL_EXCEPTION
7758: );
7759: END IF;
7760: xla_exceptions_pkg.raise_message
7761: (p_appli_s_name => 'XLA'
7762: ,p_msg_name => 'XLA_COMMON_ERROR'
7763: ,p_token_1 => 'LOCATION'
7764: ,p_value_1 => 'xla_balances_pkg.massive_update'
7776: 'Invalid p_execution_mode parameter: '|| p_execution_mode
7777: ,p_level => C_LEVEL_EXCEPTION
7778: );
7779: END IF;
7780: xla_exceptions_pkg.raise_message
7781: (p_appli_s_name => 'XLA'
7782: ,p_msg_name => 'XLA_COMMON_ERROR'
7783: ,p_token_1 => 'LOCATION'
7784: ,p_value_1 => 'xla_balances_pkg.massive_update'
7800: 'When p_execution_mode is C, p_event_id, must be NULL.'
7801: ,p_level => C_LEVEL_EXCEPTION
7802: );
7803: END IF;
7804: xla_exceptions_pkg.raise_message
7805: (p_appli_s_name => 'XLA'
7806: ,p_msg_name => 'XLA_COMMON_ERROR'
7807: ,p_token_1 => 'LOCATION'
7808: ,p_value_1 => 'xla_balances_pkg.massive_update'
7818: 'When p_execution_mode is C, p_request_id, must be NULL.'
7819: ,p_level => C_LEVEL_EXCEPTION
7820: );
7821: END IF;
7822: xla_exceptions_pkg.raise_message
7823: (p_appli_s_name => 'XLA'
7824: ,p_msg_name => 'XLA_COMMON_ERROR'
7825: ,p_token_1 => 'LOCATION'
7826: ,p_value_1 => 'xla_balances_pkg.massive_update'
7836: 'When p_execution_mode is C, p_entity_id, must be NULL.'
7837: ,p_level => C_LEVEL_EXCEPTION
7838: );
7839: END IF;
7840: xla_exceptions_pkg.raise_message
7841: (p_appli_s_name => 'XLA'
7842: ,p_msg_name => 'XLA_COMMON_ERROR'
7843: ,p_token_1 => 'LOCATION'
7844: ,p_value_1 => 'xla_balances_pkg.massive_update'
7895: , p_execution_mode => 'O'
7896: , p_concurrency_class => 'BALANCES_CALCULATION'
7897: )
7898: THEN
7899: xla_exceptions_pkg.raise_message
7900: (p_appli_s_name => 'XLA'
7901: , p_msg_name => 'XLA_COMMON_ERROR'
7902: , p_token_1 => 'LOCATION'
7903: , p_value_1 => 'xla_balances_pkg.MASSIVE_UPDATE'
7946: 'Invalid value for parameter p_execution_mode: ' || p_execution_mode
7947: ,p_level => C_LEVEL_EXCEPTION
7948: );
7949: END IF;
7950: xla_exceptions_pkg.raise_message
7951: (p_appli_s_name => 'XLA'
7952: ,p_msg_name => 'XLA_COMMON_ERROR'
7953: ,p_token_1 => 'LOCATION'
7954: ,p_value_1 => 'xla_balances_pkg.massive_update'
7991: DELETE xla_bal_concurrency_control WHERE request_id = g_req_id; --bug16073423
7992: end if;
7993:
7994: RETURN TRUE; -- Bug 14115273
7995: WHEN xla_exceptions_pkg.application_exception THEN
7996: if p_entity_id is not null then
7997: DELETE xla_bal_concurrency_control WHERE request_id = -1*p_entity_id; --bug16073423
7998: else
7999: DELETE xla_bal_concurrency_control WHERE request_id = g_req_id; --bug16073423
8006: else
8007: DELETE xla_bal_concurrency_control WHERE request_id = g_req_id; --bug16073423
8008: end if;
8009:
8010: xla_exceptions_pkg.raise_message
8011: (p_location => 'xla_balances_pkg.massive_update');
8012: END massive_update;
8013:
8014:
8605:
8606: RETURN l_return_value;
8607:
8608: EXCEPTION
8609: WHEN xla_exceptions_pkg.application_exception THEN
8610: RAISE;
8611: WHEN OTHERS THEN
8612: xla_exceptions_pkg.raise_message
8613: (p_location => 'xla_balances_pkg.recreation_common');
8608: EXCEPTION
8609: WHEN xla_exceptions_pkg.application_exception THEN
8610: RAISE;
8611: WHEN OTHERS THEN
8612: xla_exceptions_pkg.raise_message
8613: (p_location => 'xla_balances_pkg.recreation_common');
8614:
8615: END recreation_common;
8616:
8954: END IF;
8955:
8956:
8957: EXCEPTION
8958: WHEN xla_exceptions_pkg.application_exception THEN
8959: RAISE;
8960: WHEN OTHERS THEN
8961: xla_exceptions_pkg.raise_message
8962: (p_location => 'xla_balances_pkg.recreation_detailed');
8957: EXCEPTION
8958: WHEN xla_exceptions_pkg.application_exception THEN
8959: RAISE;
8960: WHEN OTHERS THEN
8961: xla_exceptions_pkg.raise_message
8962: (p_location => 'xla_balances_pkg.recreation_detailed');
8963:
8964: END recreation_detailed;
8965:
9173:
9174: RETURN TRUE;
9175:
9176: EXCEPTION
9177: WHEN xla_exceptions_pkg.application_exception THEN
9178: RAISE;
9179: WHEN OTHERS THEN
9180: xla_exceptions_pkg.raise_message
9181: (p_location => 'xla_balances_pkg.recreation_massive');
9176: EXCEPTION
9177: WHEN xla_exceptions_pkg.application_exception THEN
9178: RAISE;
9179: WHEN OTHERS THEN
9180: xla_exceptions_pkg.raise_message
9181: (p_location => 'xla_balances_pkg.recreation_massive');
9182:
9183: END recreation_massive;
9184:
9319: ,p_level => C_LEVEL_PROCEDURE);
9320: END IF;
9321:
9322: EXCEPTION
9323: WHEN xla_exceptions_pkg.application_exception THEN
9324: p_retcode := 2;
9325: p_errbuf := sqlerrm;
9326: WHEN OTHERS THEN
9327: p_retcode := 2;
9385: 'Unable to submit request'
9386: ,p_level => C_LEVEL_EXCEPTION
9387: );
9388: END IF;
9389: xla_exceptions_pkg.raise_message
9390: (p_location => 'xla_balances_pkg.recreate');
9391: END IF;
9392:
9393: l_return_value := TRUE;
9401:
9402: RETURN l_return_value;
9403:
9404: EXCEPTION
9405: WHEN xla_exceptions_pkg.application_exception THEN
9406: RAISE;
9407: WHEN OTHERS THEN
9408: xla_exceptions_pkg.raise_message
9409: (p_location => 'xla_balances_pkg.recreate');
9404: EXCEPTION
9405: WHEN xla_exceptions_pkg.application_exception THEN
9406: RAISE;
9407: WHEN OTHERS THEN
9408: xla_exceptions_pkg.raise_message
9409: (p_location => 'xla_balances_pkg.recreate');
9410:
9411: END recreate;
9412:
9496: p_chart_of_accounts_id
9497: ,p_level => C_LEVEL_EXCEPTION
9498: );
9499: END IF;
9500: xla_exceptions_pkg.raise_message
9501: (p_location => 'xla_balances_pkg.synchronize');
9502: END IF;
9503:
9504: LOOP
9572: 'REFERENCE3 is not consistent across ccids'
9573: ,p_level => C_LEVEL_EXCEPTION
9574: );
9575: END IF;
9576: xla_exceptions_pkg.raise_message
9577: (p_location => 'xla_balances_pkg.synchronize');
9578: END IF;
9579:
9580: IF NVL(l_min_reference3,'N') = 'N'
9953:
9954: RETURN TRUE;
9955:
9956: EXCEPTION
9957: WHEN xla_exceptions_pkg.application_exception THEN
9958: RAISE;
9959: WHEN OTHERS THEN
9960: xla_exceptions_pkg.raise_message
9961: (p_location => 'xla_balances_pkg.synchronize');
9956: EXCEPTION
9957: WHEN xla_exceptions_pkg.application_exception THEN
9958: RAISE;
9959: WHEN OTHERS THEN
9960: xla_exceptions_pkg.raise_message
9961: (p_location => 'xla_balances_pkg.synchronize');
9962: END synchronize;
9963:
9964: PROCEDURE open_period_srs
10050: ,p_level => C_LEVEL_PROCEDURE);
10051: END IF;
10052:
10053: EXCEPTION
10054: WHEN xla_exceptions_pkg.application_exception THEN
10055: p_retcode := 2;
10056: p_errbuf := sqlerrm;
10057: WHEN OTHERS THEN
10058: p_retcode := 2;
10102: 'Unable to submit request'
10103: ,p_level => C_LEVEL_EXCEPTION
10104: );
10105: END IF;
10106: xla_exceptions_pkg.raise_message
10107: (p_location => 'xla_balances_pkg.open_period');
10108: END IF;
10109:
10110: l_return_value := TRUE;
10117: END IF;
10118:
10119: RETURN l_return_value;
10120: EXCEPTION
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.open_period');
10120: EXCEPTION
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.open_period');
10126: END open_period;
10127:
10128:
10294: 'Invalid p_mode: ' || p_mode
10295: ,p_level => C_LEVEL_EXCEPTION
10296: );
10297: END IF;
10298: xla_exceptions_pkg.raise_message
10299: (p_location => 'xla_balances_pkg.handle_fake_journal_entry');
10300: END IF;
10301:
10302: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
10306: ,p_level => C_LEVEL_PROCEDURE);
10307: END IF;
10308:
10309: EXCEPTION
10310: WHEN xla_exceptions_pkg.application_exception THEN
10311: RAISE;
10312: WHEN OTHERS THEN
10313: xla_exceptions_pkg.raise_message
10314: (p_location => 'xla_balances_pkg.handle_fake_journal_entry');
10309: EXCEPTION
10310: WHEN xla_exceptions_pkg.application_exception THEN
10311: RAISE;
10312: WHEN OTHERS THEN
10313: xla_exceptions_pkg.raise_message
10314: (p_location => 'xla_balances_pkg.handle_fake_journal_entry');
10315: END handle_fake_journal_entry;
10316:
10317:
10446: 'Party information cannot be NULL.'
10447: ,p_level => C_LEVEL_EXCEPTION
10448: );
10449: END IF;
10450: xla_exceptions_pkg.raise_message
10451: (p_location => 'xla_balances_pkg.initialize');
10452: END IF;
10453:
10454: IF p_new_beginning_balance_dr IS NULL
10461: 'p_beginning_balance_dr and p_beginning_balance_cr cannot be both NULL'
10462: ,p_level => C_LEVEL_EXCEPTION
10463: );
10464: END IF;
10465: xla_exceptions_pkg.raise_message
10466: (p_location => 'xla_balances_pkg.initialize');
10467: END IF;
10468:
10469: IF xla_control_accounts_pkg.C_IS_CONTROL_ACCOUNT
10511: 'Entry exist before or on the initialization period'
10512: ,p_level => C_LEVEL_EXCEPTION
10513: );
10514: END IF;
10515: xla_exceptions_pkg.raise_message
10516: (p_location => 'xla_balances_pkg.initialize');
10517: END IF;
10518:
10519: BEGIN
10561: l_existing_balance_period_name
10562: ,p_level => C_LEVEL_EXCEPTION
10563: );
10564: END IF;
10565: xla_exceptions_pkg.raise_message
10566: (p_location => 'xla_balances_pkg.initialize');
10567: END IF;
10568:
10569: UPDATE xla_control_balances xba
10643: 'Failure propagating the initial balance'
10644: ,p_level => C_LEVEL_EXCEPTION
10645: );
10646: END IF;
10647: xla_exceptions_pkg.raise_message
10648: (p_location => 'xla_balances_pkg.initialize');
10649: END IF;
10650:
10651: --Delete fake entries
10688:
10689: RETURN TRUE;
10690:
10691: EXCEPTION
10692: WHEN xla_exceptions_pkg.application_exception THEN
10693: RAISE;
10694: WHEN OTHERS THEN
10695: xla_exceptions_pkg.raise_message
10696: (p_location => 'xla_balances_pkg.initialize');
10691: EXCEPTION
10692: WHEN xla_exceptions_pkg.application_exception THEN
10693: RAISE;
10694: WHEN OTHERS THEN
10695: xla_exceptions_pkg.raise_message
10696: (p_location => 'xla_balances_pkg.initialize');
10697: END initialize;
10698:
10699: FUNCTION open_period_event ( p_subscription_guid IN raw
10743: ,p_module => l_log_module);
10744: END IF;
10745:
10746: IF l_request_id = 0 THEN
10747: xla_exceptions_pkg.raise_message
10748: (p_appli_s_name => 'XLA'
10749: ,p_msg_name => 'XLA_REP_TECHNICAL_ERROR'
10750: ,p_token_1 => 'APPLICATION_NAME'
10751: ,p_value_1 => 'SLA');