eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XLA_BALANCES_CALC_PKG dependencies on XLA_BAL_CONCURRENCY_CONTROL

Line 105: | lock records in xla_bal_concurrency_control |

101: /*===============================================+
102: | |
103: | Private Function |
104: |------------------ |
105: | lock records in xla_bal_concurrency_control |
106: | |
107: | |
108: +===============================================*/
109: FUNCTION lock_bal_concurrency_control (

Line 253: INSERT INTO xla_bal_concurrency_control

249: , xah.accounting_batch_id;
250:
251:
252: FORALL i in g_ledger_array.FIRST..g_ledger_array.LAST
253: INSERT INTO xla_bal_concurrency_control
254: (ledger_id
255: , application_id
256: , concurrency_class
257: , accounting_batch_id

Line 286: INSERT INTO xla_bal_concurrency_control

282: and entity_id = p_entity_id;
283:
284:
285: FORALL i in g_ledger_array.FIRST..g_ledger_array.LAST
286: INSERT INTO xla_bal_concurrency_control
287: (ledger_id
288: , application_id
289: , concurrency_class
290: , accounting_batch_id

Line 315: INSERT INTO xla_bal_concurrency_control

311: where application_id = p_application_id
312: and ae_header_id = p_ae_header_id;
313:
314: FORALL i in g_ledger_array.FIRST..g_ledger_array.LAST
315: INSERT INTO xla_bal_concurrency_control
316: (ledger_id
317: , application_id
318: , concurrency_class
319: , accounting_batch_id

Line 345: INSERT INTO xla_bal_concurrency_control

341: where accounting_batch_id = p_accounting_batch_id
342: and application_id = p_application_id;
343:
344: FORALL i in g_ledger_array.FIRST..g_ledger_array.LAST
345: INSERT INTO xla_bal_concurrency_control
346: (ledger_id
347: , application_id
348: , concurrency_class
349: , accounting_batch_id

Line 374: INSERT INTO xla_bal_concurrency_control

370: , g_accounting_batch_array
371: FROM dual;
372:
373: FORALL i in g_ledger_array.FIRST..g_ledger_array.LAST
374: INSERT INTO xla_bal_concurrency_control
375: (ledger_id
376: , application_id
377: , concurrency_class
378: , accounting_batch_id

Line 400: INSERT INTO xla_bal_concurrency_control

396: g_ledger_array
397: FROM dual;
398:
399: FORALL i in g_ledger_array.FIRST..g_ledger_array.LAST
400: INSERT INTO xla_bal_concurrency_control
401: (ledger_id
402: , concurrency_class
403: , request_id
404: ) VALUES

Line 414: , p_msg => '# rows inserted into xla_bal_concurrency_control ' || SQL%ROWCOUNT

410:
411: IF (c_level_procedure >= g_log_level)
412: THEN
413: TRACE (p_module => l_log_module
414: , p_msg => '# rows inserted into xla_bal_concurrency_control ' || SQL%ROWCOUNT
415: , p_level => c_level_procedure
416: );
417: END IF;
418:

Line 436: , p_msg => 'Cannot lock XLA_BAL_CONCURRENCY_CONTROL'

432: THEN
433: IF (c_level_error >= g_log_level)
434: THEN
435: TRACE (p_module => l_log_module
436: , p_msg => 'Cannot lock XLA_BAL_CONCURRENCY_CONTROL'
437: , p_level => c_level_error
438: );
439: END IF;
440:

Line 636: l_summary_stmt := REPLACE (l_summary_stmt, '$bal_concurrency$', ',xla_bal_concurrency_control bcc');

632:
633: -- add dynamic conditions
634: IF p_request_id IS NOT NULL AND p_request_id <> -1
635: THEN
636: l_summary_stmt := REPLACE (l_summary_stmt, '$bal_concurrency$', ',xla_bal_concurrency_control bcc');
637: l_summary_stmt := l_summary_stmt || '
638: AND bcc.request_id = :'||l_summary_bind_count||'
639: AND bcc.accounting_batch_id = aeh.accounting_batch_id
640: AND bcc.application_id = aeh.application_id

Line 1398: l_update_processed := REPLACE(l_update_processed,'$bal_concurrency$',',xla_bal_concurrency_control bcc');

1394:
1395: --Add dynamic conditions
1396: IF p_request_id IS NOT NULL AND p_request_id <> -1
1397: THEN
1398: l_update_processed := REPLACE(l_update_processed,'$bal_concurrency$',',xla_bal_concurrency_control bcc');
1399: l_update_processed := l_update_processed||
1400: ' AND bcc.request_id = :'||l_processed_bind_count||'
1401: AND bcc.accounting_batch_id = aeh.accounting_batch_id
1402: AND bcc.application_id = aeh.application_id' ;

Line 1754: l_summary_stmt := REPLACE (l_summary_stmt, '$bal_concurrency$', ',xla_bal_concurrency_control bcc');

1750:
1751: -- add dynamic conditions
1752: IF p_request_id IS NOT NULL AND p_request_id <> -1
1753: THEN
1754: l_summary_stmt := REPLACE (l_summary_stmt, '$bal_concurrency$', ',xla_bal_concurrency_control bcc');
1755: l_summary_stmt := l_summary_stmt || '
1756: AND bcc.request_id = :'||l_summary_bind_count||'
1757: AND bcc.accounting_batch_id = aeh.accounting_batch_id
1758: AND bcc.application_id = aeh.application_id

Line 2369: l_update_processed := REPLACE(l_update_processed,'$bal_concurrency$',',xla_bal_concurrency_control bcc');

2365:
2366: --Add dynamic conditions
2367: IF p_request_id IS NOT NULL AND p_request_id <> -1
2368: THEN
2369: l_update_processed := REPLACE(l_update_processed,'$bal_concurrency$',',xla_bal_concurrency_control bcc');
2370: l_update_processed := l_update_processed||
2371: ' AND bcc.request_id = :'||l_processed_bind_count||'
2372: AND bcc.accounting_batch_id = aeh.accounting_batch_id
2373: AND bcc.application_id = aeh.application_id' ;

Line 3358: FROM xla_bal_concurrency_control

3354: CURSOR lock_bal_control (p_ledger_id NUMBER)
3355: IS
3356: SELECT application_id
3357: ,ledger_id
3358: FROM xla_bal_concurrency_control
3359: WHERE ledger_id = p_ledger_id
3360: AND application_id IN ( SELECT * FROM TABLE(g_application_array))
3361: FOR UPDATE NOWAIT; --Lock All the applications belonging to this ledger
3362:

Line 3662: , p_value_2 => 'EXCEPTION:'|| 'Record cannot be inserted into XLA_BAL_CONCURRENCY_CONTROL '

3658: , p_msg_name => 'XLA_COMMON_ERROR'
3659: , p_token_1 => 'LOCATION'
3660: , p_value_1 => 'xla_balances_calc_pkg.open_period_srs'
3661: , p_token_2 => 'ERROR'
3662: , p_value_2 => 'EXCEPTION:'|| 'Record cannot be inserted into XLA_BAL_CONCURRENCY_CONTROL '
3663: );
3664: END IF;
3665:
3666: OPEN lock_bal_control (p_ledger_id => p_ledger_id );

Line 3678: delete xla_bal_concurrency_control where request_id = g_req_id; --Bug 13614923

3674: )
3675: THEN
3676: fnd_file.put_line (fnd_file.LOG, 'Open Period Balances Successfully completed');
3677:
3678: delete xla_bal_concurrency_control where request_id = g_req_id; --Bug 13614923
3679:
3680:
3681: ELSE
3682: delete xla_bal_concurrency_control where request_id = g_req_id; --Bug 13614923

Line 3682: delete xla_bal_concurrency_control where request_id = g_req_id; --Bug 13614923

3678: delete xla_bal_concurrency_control where request_id = g_req_id; --Bug 13614923
3679:
3680:
3681: ELSE
3682: delete xla_bal_concurrency_control where request_id = g_req_id; --Bug 13614923
3683:
3684: p_retcode := p_retcode + 1;
3685: fnd_file.put_line (fnd_file.LOG, 'Unsuccessful');
3686: ROLLBACK TO SAVEPOINT_BAL;

Line 3705: , p_msg => 'Cannot lock XLA_BAL_CONCURRENCY_CONTROL'

3701: THEN
3702: IF (c_level_error >= g_log_level)
3703: THEN
3704: TRACE (p_module => l_log_module
3705: , p_msg => 'Cannot lock XLA_BAL_CONCURRENCY_CONTROL'
3706: , p_level => c_level_error
3707: );
3708: END IF;
3709:

Line 3727: delete xla_bal_concurrency_control where request_id = g_req_id; -- Bug13614923

3723: || '. Pls. submit Open Period Balances Concurrent Program once the running request is completed'
3724: );
3725: --Added below rollback statement
3726: ROLLBACK TO SAVEPOINT_BAL; -- Bug13614923
3727: delete xla_bal_concurrency_control where request_id = g_req_id; -- Bug13614923
3728:
3729: WHEN xla_exceptions_pkg.application_exception
3730: THEN
3731: p_retcode := 2;

Line 3735: delete xla_bal_concurrency_control where request_id = g_req_id; -- Bug13614923

3731: p_retcode := 2;
3732: p_errbuf := SQLERRM;
3733: --Added below rollback statement
3734: ROLLBACK TO SAVEPOINT_BAL; -- Bug13614923
3735: delete xla_bal_concurrency_control where request_id = g_req_id; -- Bug13614923
3736: WHEN OTHERS
3737: THEN
3738: p_retcode := 2;
3739: --Added below rollback statement

Line 3741: delete xla_bal_concurrency_control where request_id = g_req_id; -- Bug13614923

3737: THEN
3738: p_retcode := 2;
3739: --Added below rollback statement
3740: ROLLBACK TO SAVEPOINT_BAL; -- Bug13614923
3741: delete xla_bal_concurrency_control where request_id = g_req_id; -- Bug13614923
3742: p_errbuf := SQLERRM;
3743: END open_period_srs;
3744:
3745: /*===============================================+

Line 3794: FROM xla_bal_concurrency_control

3790: CURSOR lock_bal_control (p_application_id NUMBER)
3791: IS
3792: SELECT application_id
3793: ,ledger_id
3794: FROM xla_bal_concurrency_control
3795: WHERE application_id = p_application_id
3796: AND ledger_id IN ( SELECT * FROM TABLE(g_ledger_array))
3797: FOR UPDATE NOWAIT;
3798:

Line 3941: || 'XLA_BAL_CONCURRENCY_CONTROL COULD NOT BE LOCKED. RESOURCE BUSY'

3937: , p_token_1 => 'LOCATION'
3938: , p_value_1 => 'xla_balances_calc_pkg.massive_update_srs'
3939: , p_token_2 => 'ERROR'
3940: , p_value_2 => 'EXCEPTION:'
3941: || 'XLA_BAL_CONCURRENCY_CONTROL COULD NOT BE LOCKED. RESOURCE BUSY'
3942: );
3943: END IF;
3944:
3945:

Line 3969: --DELETE RECORDS FROM XLA_BAL_CONCURRENCY_CONTROL TABLE

3965: )
3966: THEN
3967: p_retcode := 0; --bug14255667
3968:
3969: --DELETE RECORDS FROM XLA_BAL_CONCURRENCY_CONTROL TABLE
3970: DELETE xla_bal_concurrency_control WHERE request_id = g_req_id; --Bug 13614923
3971: ELSE
3972: ROLLBACK TO SAVEPOINT_BAL;
3973: DELETE xla_bal_concurrency_control WHERE request_id = g_req_id; --Bug 13614923

Line 3970: DELETE xla_bal_concurrency_control WHERE request_id = g_req_id; --Bug 13614923

3966: THEN
3967: p_retcode := 0; --bug14255667
3968:
3969: --DELETE RECORDS FROM XLA_BAL_CONCURRENCY_CONTROL TABLE
3970: DELETE xla_bal_concurrency_control WHERE request_id = g_req_id; --Bug 13614923
3971: ELSE
3972: ROLLBACK TO SAVEPOINT_BAL;
3973: DELETE xla_bal_concurrency_control WHERE request_id = g_req_id; --Bug 13614923
3974: p_retcode := 1;

Line 3973: DELETE xla_bal_concurrency_control WHERE request_id = g_req_id; --Bug 13614923

3969: --DELETE RECORDS FROM XLA_BAL_CONCURRENCY_CONTROL TABLE
3970: DELETE xla_bal_concurrency_control WHERE request_id = g_req_id; --Bug 13614923
3971: ELSE
3972: ROLLBACK TO SAVEPOINT_BAL;
3973: DELETE xla_bal_concurrency_control WHERE request_id = g_req_id; --Bug 13614923
3974: p_retcode := 1;
3975: END IF;
3976: END IF;
3977: EXCEPTION

Line 3983: , p_msg => 'Cannot lock XLA_BAL_CONCURRENCY_CONTROL'

3979: THEN
3980: IF (c_level_error >= g_log_level)
3981: THEN
3982: TRACE (p_module => l_log_module
3983: , p_msg => 'Cannot lock XLA_BAL_CONCURRENCY_CONTROL'
3984: , p_level => c_level_error
3985: );
3986: END IF;
3987:

Line 4000: FROM xla_bal_concurrency_control

3996: p_retcode := 1; --bug13614923
3997:
3998: for i in ( SELECT distinct application_id
3999: ,ledger_id
4000: FROM xla_bal_concurrency_control
4001: WHERE application_id = p_application_id
4002: AND ledger_id IN ( SELECT * FROM TABLE(g_ledger_array)))
4003: loop
4004: fnd_file.put_line

Line 4019: DELETE xla_bal_concurrency_control WHERE request_id = g_req_id;

4015:
4016: --Bug 12575468
4017: --Added below rollback statement
4018: ROLLBACK TO SAVEPOINT_BAL;
4019: DELETE xla_bal_concurrency_control WHERE request_id = g_req_id;
4020:
4021: WHEN xla_exceptions_pkg.application_exception
4022: THEN
4023: p_retcode := 2; --bug13614923

Line 4027: DELETE xla_bal_concurrency_control WHERE request_id = g_req_id; --Bug 13614923

4023: p_retcode := 2; --bug13614923
4024: --Bug 12575468
4025: --Added below rollback statement
4026: ROLLBACK TO SAVEPOINT_BAL;
4027: DELETE xla_bal_concurrency_control WHERE request_id = g_req_id; --Bug 13614923
4028: RAISE;
4029: WHEN OTHERS
4030: THEN
4031: p_retcode := 2; --bug13614923

Line 4035: DELETE xla_bal_concurrency_control WHERE request_id = g_req_id;

4031: p_retcode := 2; --bug13614923
4032: --Bug 12575468
4033: --Added below rollback statement
4034: ROLLBACK TO SAVEPOINT_BAL;
4035: DELETE xla_bal_concurrency_control WHERE request_id = g_req_id;
4036: xla_exceptions_pkg.raise_message
4037: (p_location => 'xla_balances_calc_pkg.massive_update_srs');
4038: END massive_update_srs;
4039:

Line 4095: FROM xla_bal_concurrency_control

4091: CURSOR lock_bal_control (p_application_id NUMBER)
4092: IS
4093: SELECT application_id
4094: ,ledger_id
4095: FROM xla_bal_concurrency_control
4096: WHERE application_id = p_application_id
4097: AND ledger_id IN ( SELECT * FROM TABLE(g_ledger_array))
4098: FOR UPDATE NOWAIT;
4099:

Line 4280: || 'XLA_BAL_CONCURRENCY_CONTROL COULD NOT BE LOCKED. RESOURCE BUSY'

4276: , p_token_1 => 'LOCATION'
4277: , p_value_1 => 'xla_balances_calc_pkg.MASSIVE_UPDATE'
4278: , p_token_2 => 'ERROR'
4279: , p_value_2 => 'EXCEPTION:'
4280: || 'XLA_BAL_CONCURRENCY_CONTROL COULD NOT BE LOCKED. RESOURCE BUSY'
4281: );
4282: END IF;
4283:
4284:

Line 4304: DELETE FROM xla_bal_concurrency_control where request_id=g_req_id;

4300: , p_execution_mode => p_execution_mode
4301: )
4302: THEN
4303: if p_entity_id is null then
4304: DELETE FROM xla_bal_concurrency_control where request_id=g_req_id;
4305: else
4306: DELETE FROM xla_bal_concurrency_control where request_id=-1*p_entity_id;
4307: end if;
4308: RETURN TRUE;

Line 4306: DELETE FROM xla_bal_concurrency_control where request_id=-1*p_entity_id;

4302: THEN
4303: if p_entity_id is null then
4304: DELETE FROM xla_bal_concurrency_control where request_id=g_req_id;
4305: else
4306: DELETE FROM xla_bal_concurrency_control where request_id=-1*p_entity_id;
4307: end if;
4308: RETURN TRUE;
4309: END IF;
4310: END IF;

Line 4318: DELETE FROM xla_bal_concurrency_control where request_id=g_req_id;

4314: RETURN TRUE;
4315: else
4316: ROLLBACK TO SAVEPOINT_BAL;
4317: if p_entity_id is null then
4318: DELETE FROM xla_bal_concurrency_control where request_id=g_req_id;
4319: else
4320: DELETE FROM xla_bal_concurrency_control where request_id=-1*p_entity_id;
4321: end if;
4322: RETURN TRUE;

Line 4320: DELETE FROM xla_bal_concurrency_control where request_id=-1*p_entity_id;

4316: ROLLBACK TO SAVEPOINT_BAL;
4317: if p_entity_id is null then
4318: DELETE FROM xla_bal_concurrency_control where request_id=g_req_id;
4319: else
4320: DELETE FROM xla_bal_concurrency_control where request_id=-1*p_entity_id;
4321: end if;
4322: RETURN TRUE;
4323: end if;
4324: -- End Bug 14115273

Line 4333: , p_msg => 'Cannot lock XLA_BAL_CONCURRENCY_CONTROL'

4329: THEN
4330: IF (c_level_error >= g_log_level)
4331: THEN
4332: TRACE (p_module => l_log_module
4333: , p_msg => 'Cannot lock XLA_BAL_CONCURRENCY_CONTROL'
4334: , p_level => c_level_error
4335: );
4336: END IF;
4337:

Line 4340: FROM xla_bal_concurrency_control

4336: END IF;
4337:
4338: for i in ( SELECT distinct application_id
4339: ,ledger_id
4340: FROM xla_bal_concurrency_control
4341: WHERE application_id = p_application_id
4342: AND ledger_id IN ( SELECT * FROM TABLE(g_ledger_array)))
4343: loop
4344: fnd_file.put_line

Line 4366: DELETE FROM xla_bal_concurrency_control where request_id=g_req_id;

4362: END IF;
4363:
4364: ROLLBACK TO SAVEPOINT_BAL;
4365: if p_entity_id is null then
4366: DELETE FROM xla_bal_concurrency_control where request_id=g_req_id;
4367: else
4368: DELETE FROM xla_bal_concurrency_control where request_id=-1*p_entity_id;
4369: end if;
4370:

Line 4368: DELETE FROM xla_bal_concurrency_control where request_id=-1*p_entity_id;

4364: ROLLBACK TO SAVEPOINT_BAL;
4365: if p_entity_id is null then
4366: DELETE FROM xla_bal_concurrency_control where request_id=g_req_id;
4367: else
4368: DELETE FROM xla_bal_concurrency_control where request_id=-1*p_entity_id;
4369: end if;
4370:
4371: RETURN TRUE; -- Bug 13614923
4372: WHEN xla_exceptions_pkg.application_exception

Line 4376: DELETE FROM xla_bal_concurrency_control where request_id=g_req_id;

4372: WHEN xla_exceptions_pkg.application_exception
4373: THEN
4374: ROLLBACK TO SAVEPOINT_BAL;
4375: if p_entity_id is null then
4376: DELETE FROM xla_bal_concurrency_control where request_id=g_req_id;
4377: else
4378: DELETE FROM xla_bal_concurrency_control where request_id=-1*p_entity_id;
4379: end if;
4380:

Line 4378: DELETE FROM xla_bal_concurrency_control where request_id=-1*p_entity_id;

4374: ROLLBACK TO SAVEPOINT_BAL;
4375: if p_entity_id is null then
4376: DELETE FROM xla_bal_concurrency_control where request_id=g_req_id;
4377: else
4378: DELETE FROM xla_bal_concurrency_control where request_id=-1*p_entity_id;
4379: end if;
4380:
4381: RETURN TRUE; -- Bug 13614923
4382: WHEN OTHERS

Line 4386: DELETE FROM xla_bal_concurrency_control where request_id=g_req_id;

4382: WHEN OTHERS
4383: THEN
4384: ROLLBACK TO SAVEPOINT_BAL;
4385: if p_entity_id is null then
4386: DELETE FROM xla_bal_concurrency_control where request_id=g_req_id;
4387: else
4388: DELETE FROM xla_bal_concurrency_control where request_id=-1*p_entity_id;
4389: end if;
4390:

Line 4388: DELETE FROM xla_bal_concurrency_control where request_id=-1*p_entity_id;

4384: ROLLBACK TO SAVEPOINT_BAL;
4385: if p_entity_id is null then
4386: DELETE FROM xla_bal_concurrency_control where request_id=g_req_id;
4387: else
4388: DELETE FROM xla_bal_concurrency_control where request_id=-1*p_entity_id;
4389: end if;
4390:
4391: xla_exceptions_pkg.raise_message
4392: (p_location => 'xla_balances_calc_pkg.massive_update');

Line 4422: FROM xla_bal_concurrency_control

4418: CURSOR lock_bal_control
4419: IS
4420: SELECT application_id
4421: ,ledger_id
4422: FROM xla_bal_concurrency_control
4423: WHERE application_id IN ( SELECT * FROM TABLE(g_application_array))
4424: AND ledger_id IN ( SELECT * FROM TABLE(g_ledger_array))
4425: FOR UPDATE NOWAIT;
4426: BEGIN

Line 4571: || 'XLA_BAL_CONCURRENCY_CONTROL COULD NOT BE LOCKED. RESOURCE BUSY'

4567: , p_token_1 => 'LOCATION'
4568: , p_value_1 => 'xla_balances_calc_pkg.MASSIVE_UPDATE'
4569: , p_token_2 => 'ERROR'
4570: , p_value_2 => 'EXCEPTION:'
4571: || 'XLA_BAL_CONCURRENCY_CONTROL COULD NOT BE LOCKED. RESOURCE BUSY'
4572: );
4573: END IF;
4574: OPEN lock_bal_control;
4575:

Line 4592: DELETE FROM xla_bal_concurrency_control where request_id=-1*p_ae_header_id;

4588: , p_update_mode => p_update_mode
4589: , p_execution_mode => l_execution_mode
4590: );
4591:
4592: DELETE FROM xla_bal_concurrency_control where request_id=-1*p_ae_header_id;
4593:
4594: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
4595: trace (p_module => l_log_module
4596: ,p_msg => 'END ' || l_log_module

Line 4605: DELETE FROM xla_bal_concurrency_control where request_id=-1*p_ae_header_id;

4601: if l_return_value then
4602: RETURN TRUE;
4603: else
4604: ROLLBACK TO SAVEPOINT_BAL;
4605: DELETE FROM xla_bal_concurrency_control where request_id=-1*p_ae_header_id;
4606: RETURN TRUE;
4607: end if;
4608: -- End Bug 14115273
4609:

Line 4617: , p_msg => 'Cannot lock XLA_BAL_CONCURRENCY_CONTROL'

4613: THEN
4614: IF (c_level_error >= g_log_level)
4615: THEN
4616: TRACE (p_module => l_log_module
4617: , p_msg => 'Cannot lock XLA_BAL_CONCURRENCY_CONTROL'
4618: , p_level => c_level_error
4619: );
4620: END IF;
4621:

Line 4632: FROM xla_bal_concurrency_control

4628: END IF;
4629:
4630: for i in ( SELECT distinct application_id
4631: ,ledger_id
4632: FROM xla_bal_concurrency_control
4633: WHERE application_id = p_application_id
4634: AND ledger_id IN ( SELECT * FROM TABLE(g_ledger_array)))
4635: loop
4636: fnd_file.put_line

Line 4649: DELETE FROM xla_bal_concurrency_control where request_id=-1*p_ae_header_id;

4645: (fnd_file.LOG ,
4646: 'Pls. submit Subledger Accounting Balances Update Concurrent Program once the running request is completed');
4647:
4648: ROLLBACK TO SAVEPOINT_BAL;
4649: DELETE FROM xla_bal_concurrency_control where request_id=-1*p_ae_header_id;
4650: RETURN TRUE;
4651: WHEN xla_exceptions_pkg.application_exception
4652: THEN
4653: ROLLBACK TO SAVEPOINT_BAL;

Line 4654: DELETE FROM xla_bal_concurrency_control where request_id=-1*p_ae_header_id;

4650: RETURN TRUE;
4651: WHEN xla_exceptions_pkg.application_exception
4652: THEN
4653: ROLLBACK TO SAVEPOINT_BAL;
4654: DELETE FROM xla_bal_concurrency_control where request_id=-1*p_ae_header_id;
4655: RETURN TRUE;
4656: WHEN OTHERS
4657: THEN
4658: ROLLBACK TO SAVEPOINT_BAL;

Line 4659: DELETE FROM xla_bal_concurrency_control where request_id=-1*p_ae_header_id;

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