DBA Data[Home] [Help]

APPS.XLA_BALANCES_PKG dependencies on XLA_EXCEPTIONS_PKG

Line 214: WHEN xla_exceptions_pkg.application_exception THEN

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');

Line 217: xla_exceptions_pkg.raise_message

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:

Line 281: xla_exceptions_pkg.raise_message

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'

Line 294: WHEN xla_exceptions_pkg.application_exception

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

Line 299: xla_exceptions_pkg.raise_message

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:

Line 435: xla_exceptions_pkg.raise_message

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'

Line 457: xla_exceptions_pkg.raise_message

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'

Line 1045: WHEN xla_exceptions_pkg.application_exception

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

Line 1050: xla_exceptions_pkg.raise_message

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:

Line 1201: WHEN xla_exceptions_pkg.application_exception THEN

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');

Line 1204: xla_exceptions_pkg.raise_message

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:

Line 1284: WHEN xla_exceptions_pkg.application_exception THEN

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');

Line 1287: xla_exceptions_pkg.raise_message

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

Line 1530: xla_exceptions_pkg.raise_message

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'

Line 1679: WHEN xla_exceptions_pkg.application_exception THEN

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');

Line 1682: xla_exceptions_pkg.raise_message

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

Line 2422: WHEN xla_exceptions_pkg.application_exception THEN

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');

Line 2425: xla_exceptions_pkg.raise_message

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

Line 3157: WHEN xla_exceptions_pkg.application_exception THEN

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');

Line 3160: xla_exceptions_pkg.raise_message

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:

Line 3298: xla_exceptions_pkg.raise_message

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'

Line 3321: xla_exceptions_pkg.raise_message

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'

Line 3349: xla_exceptions_pkg.raise_message

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'

Line 3735: WHEN xla_exceptions_pkg.application_exception

3731:
3732: RETURN TRUE;
3733:
3734: EXCEPTION
3735: WHEN xla_exceptions_pkg.application_exception
3736: THEN
3737: RAISE;
3738: WHEN OTHERS
3739: THEN

Line 3740: xla_exceptions_pkg.raise_message

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

Line 4179: xla_exceptions_pkg.raise_message

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'

Line 4259: WHEN xla_exceptions_pkg.application_exception

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

Line 4264: xla_exceptions_pkg.raise_message

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:

Line 4998: WHEN xla_exceptions_pkg.application_exception

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

Line 5003: xla_exceptions_pkg.raise_message

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:

Line 5293: xla_exceptions_pkg.raise_message

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'

Line 5323: WHEN xla_exceptions_pkg.application_exception

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

Line 5328: xla_exceptions_pkg.raise_message

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:

Line 5558: xla_exceptions_pkg.raise_message

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'

Line 5588: WHEN xla_exceptions_pkg.application_exception

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

Line 5593: xla_exceptions_pkg.raise_message

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:

Line 5828: xla_exceptions_pkg.raise_message

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'

Line 5855: WHEN xla_exceptions_pkg.application_exception

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

Line 5860: xla_exceptions_pkg.raise_message

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:

Line 6154: WHEN xla_exceptions_pkg.application_exception

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

Line 6159: xla_exceptions_pkg.raise_message

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:

Line 6346: xla_exceptions_pkg.raise_message

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'

Line 6380: xla_exceptions_pkg.raise_message

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'

Line 6401: xla_exceptions_pkg.raise_message

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'

Line 6704: xla_exceptions_pkg.raise_message

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'

Line 7017: xla_exceptions_pkg.raise_message

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'

Line 7060: WHEN xla_exceptions_pkg.application_exception THEN

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');

Line 7063: xla_exceptions_pkg.raise_message

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:

Line 7100: xla_exceptions_pkg.raise_message

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'

Line 7137: WHEN xla_exceptions_pkg.application_exception THEN

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');

Line 7140: xla_exceptions_pkg.raise_message

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:

Line 7188: xla_exceptions_pkg.raise_message

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'

Line 7208: xla_exceptions_pkg.raise_message

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'

Line 7228: xla_exceptions_pkg.raise_message

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'

Line 7246: xla_exceptions_pkg.raise_message

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'

Line 7268: xla_exceptions_pkg.raise_message

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'

Line 7311: WHEN xla_exceptions_pkg.application_exception THEN

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

Line 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;

Line 7402: xla_exceptions_pkg.raise_message

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'

Line 7451: WHEN xla_exceptions_pkg.application_exception THEN

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

Line 7492: xla_exceptions_pkg.raise_message

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'

Line 7523: WHEN xla_exceptions_pkg.application_exception THEN

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');

Line 7526: xla_exceptions_pkg.raise_message

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:

Line 7583: xla_exceptions_pkg.raise_message

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'

Line 7607: xla_exceptions_pkg.raise_message

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'

Line 7625: xla_exceptions_pkg.raise_message

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'

Line 7642: xla_exceptions_pkg.raise_message

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'

Line 7660: xla_exceptions_pkg.raise_message

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'

Line 7685: xla_exceptions_pkg.raise_message

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'

Line 7703: xla_exceptions_pkg.raise_message

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'

Line 7721: xla_exceptions_pkg.raise_message

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'

Line 7739: xla_exceptions_pkg.raise_message

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'

Line 7760: xla_exceptions_pkg.raise_message

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'

Line 7780: xla_exceptions_pkg.raise_message

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'

Line 7804: xla_exceptions_pkg.raise_message

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'

Line 7822: xla_exceptions_pkg.raise_message

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'

Line 7840: xla_exceptions_pkg.raise_message

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'

Line 7899: xla_exceptions_pkg.raise_message

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'

Line 7950: xla_exceptions_pkg.raise_message

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'

Line 7995: WHEN xla_exceptions_pkg.application_exception THEN

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

Line 8010: xla_exceptions_pkg.raise_message

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:

Line 8609: WHEN xla_exceptions_pkg.application_exception THEN

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');

Line 8612: xla_exceptions_pkg.raise_message

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:

Line 8958: WHEN xla_exceptions_pkg.application_exception THEN

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');

Line 8961: xla_exceptions_pkg.raise_message

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:

Line 9177: WHEN xla_exceptions_pkg.application_exception THEN

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');

Line 9180: xla_exceptions_pkg.raise_message

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:

Line 9323: WHEN xla_exceptions_pkg.application_exception THEN

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;

Line 9389: xla_exceptions_pkg.raise_message

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;

Line 9405: WHEN xla_exceptions_pkg.application_exception THEN

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');

Line 9408: xla_exceptions_pkg.raise_message

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:

Line 9500: xla_exceptions_pkg.raise_message

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

Line 9576: xla_exceptions_pkg.raise_message

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'

Line 9957: WHEN xla_exceptions_pkg.application_exception THEN

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');

Line 9960: xla_exceptions_pkg.raise_message

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

Line 10054: WHEN xla_exceptions_pkg.application_exception THEN

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;

Line 10106: xla_exceptions_pkg.raise_message

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;

Line 10121: WHEN xla_exceptions_pkg.application_exception THEN

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');

Line 10124: xla_exceptions_pkg.raise_message

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:

Line 10298: xla_exceptions_pkg.raise_message

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

Line 10310: WHEN xla_exceptions_pkg.application_exception 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');

Line 10313: xla_exceptions_pkg.raise_message

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:

Line 10450: xla_exceptions_pkg.raise_message

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

Line 10465: xla_exceptions_pkg.raise_message

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

Line 10515: xla_exceptions_pkg.raise_message

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

Line 10565: xla_exceptions_pkg.raise_message

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

Line 10647: xla_exceptions_pkg.raise_message

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

Line 10692: WHEN xla_exceptions_pkg.application_exception THEN

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');

Line 10695: xla_exceptions_pkg.raise_message

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

Line 10747: xla_exceptions_pkg.raise_message

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');