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_BAL_CONCURRENCY_CONTROL

Line 7162: FROM xla_bal_concurrency_control

7158: CURSOR lock_bal_control (p_application_id NUMBER)
7159: IS
7160: SELECT application_id
7161: , ledger_id
7162: FROM xla_bal_concurrency_control
7163: WHERE application_id = p_application_id
7164: FOR UPDATE NOWAIT;
7165:
7166: BEGIN

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

7271: , p_token_1 => 'LOCATION'
7272: , p_value_1 => 'xla_balances_pkg.MASSIVE_UPDATE'
7273: , p_token_2 => 'ERROR'
7274: , p_value_2 => 'EXCEPTION:'
7275: || 'XLA_BAL_CONCURRENCY_CONTROL COULD NOT BE LOCKED. RESOURCE BUSY'
7276: );
7277: END IF;
7278: OPEN lock_bal_control (p_application_id => p_application_id);
7279:

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

7302: ,p_msg => 'END ' || l_log_module
7303: ,p_level => C_LEVEL_PROCEDURE);
7304: END IF;
7305:
7306: DELETE xla_bal_concurrency_control where request_id=-1*p_ae_header_id;
7307:
7308: RETURN TRUE; -- Bug 14115273
7309:
7310: EXCEPTION

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

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
7316: (p_location => 'xla_balances_pkg.single_update');

Line 7317: 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;
7320:
7321:

Line 7362: FROM xla_bal_concurrency_control

7358: CURSOR lock_bal_control (p_application_id NUMBER)
7359: IS
7360: SELECT application_id
7361: , ledger_id
7362: FROM xla_bal_concurrency_control
7363: WHERE application_id = p_application_id
7364: FOR UPDATE WAIT 60;
7365:
7366: BEGIN

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

7405: , p_token_1 => 'LOCATION'
7406: , p_value_1 => 'xla_balances_pkg.massive_update_srs'
7407: , p_token_2 => 'ERROR'
7408: , p_value_2 => 'EXCEPTION:'
7409: || 'XLA_BAL_CONCURRENCY_CONTROL COULD NOT BE LOCKED. RESOURCE BUSY'
7410: );
7411: END IF;
7412:
7413: OPEN lock_bal_control (p_application_id => p_application_id );

Line 7436: DELETE xla_bal_concurrency_control where request_id = g_req_id; -- bug16073423

7432: )
7433: THEN
7434: p_retcode := 0;
7435:
7436: DELETE xla_bal_concurrency_control where request_id = g_req_id; -- bug16073423
7437:
7438: ELSE
7439: DELETE xla_bal_concurrency_control where request_id = g_req_id; -- bug16073423
7440: p_retcode := 1;

Line 7439: DELETE xla_bal_concurrency_control where request_id = g_req_id; -- bug16073423

7435:
7436: DELETE xla_bal_concurrency_control where request_id = g_req_id; -- bug16073423
7437:
7438: ELSE
7439: DELETE xla_bal_concurrency_control where request_id = g_req_id; -- bug16073423
7440: p_retcode := 1;
7441: END IF;
7442:
7443: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN

Line 7452: DELETE xla_bal_concurrency_control where request_id = g_req_id; -- bug16073423

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
7456: DELETE xla_bal_concurrency_control where request_id = g_req_id; -- bug16073423

Line 7456: DELETE xla_bal_concurrency_control where request_id = g_req_id; -- bug16073423

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
7456: DELETE xla_bal_concurrency_control where request_id = g_req_id; -- bug16073423
7457: p_retcode := 2;
7458: p_errbuf := sqlerrm;
7459: END massive_update_srs;
7460:

Line 7554: FROM xla_bal_concurrency_control

7550: CURSOR lock_bal_control (p_application_id NUMBER)
7551: IS
7552: SELECT application_id
7553: , ledger_id
7554: FROM xla_bal_concurrency_control
7555: WHERE application_id = p_application_id
7556: FOR UPDATE NOWAIT;
7557:
7558: BEGIN

Line 7906: || 'COULD NOT insert record into XLA_BAL_CONCURRENCY_CONTROL'

7902: , p_token_1 => 'LOCATION'
7903: , p_value_1 => 'xla_balances_pkg.MASSIVE_UPDATE'
7904: , p_token_2 => 'ERROR'
7905: , p_value_2 => 'EXCEPTION:'
7906: || 'COULD NOT insert record into XLA_BAL_CONCURRENCY_CONTROL'
7907: );
7908: END IF;
7909:
7910: OPEN lock_bal_control (p_application_id => p_application_id );

Line 7933: DELETE xla_bal_concurrency_control WHERE request_id = -1*p_entity_id; --bug16073423

7929: )
7930: THEN
7931:
7932: if p_entity_id is not null then
7933: DELETE xla_bal_concurrency_control WHERE request_id = -1*p_entity_id; --bug16073423
7934: else
7935: DELETE xla_bal_concurrency_control WHERE request_id = g_req_id; --bug16073423
7936: end if;
7937:

Line 7935: DELETE xla_bal_concurrency_control WHERE request_id = g_req_id; --bug16073423

7931:
7932: if p_entity_id is not null then
7933: DELETE xla_bal_concurrency_control WHERE request_id = -1*p_entity_id; --bug16073423
7934: else
7935: DELETE xla_bal_concurrency_control WHERE request_id = g_req_id; --bug16073423
7936: end if;
7937:
7938: RETURN TRUE;
7939: END IF;

Line 7969: DELETE xla_bal_concurrency_control WHERE request_id = -1*p_entity_id; --bug16073423

7965: END IF;
7966:
7967:
7968: if p_entity_id is not null then
7969: DELETE xla_bal_concurrency_control WHERE request_id = -1*p_entity_id; --bug16073423
7970: else
7971: DELETE xla_bal_concurrency_control WHERE request_id = g_req_id; --bug16073423
7972: end if;
7973:

Line 7971: DELETE xla_bal_concurrency_control WHERE request_id = g_req_id; --bug16073423

7967:
7968: if p_entity_id is not null then
7969: DELETE xla_bal_concurrency_control WHERE request_id = -1*p_entity_id; --bug16073423
7970: else
7971: DELETE xla_bal_concurrency_control WHERE request_id = g_req_id; --bug16073423
7972: end if;
7973:
7974:
7975: return TRUE; -- Bug 14115273

Line 7984: , p_msg => 'Cannot lock XLA_BAL_CONCURRENCY_CONTROL. This can be ignored'

7980: THEN
7981: IF (c_level_error >= g_log_level)
7982: THEN
7983: TRACE (p_module => l_log_module
7984: , p_msg => 'Cannot lock XLA_BAL_CONCURRENCY_CONTROL. This can be ignored'
7985: , p_level => c_level_error
7986: );
7987: END IF;
7988: if p_entity_id is not null then

Line 7989: DELETE xla_bal_concurrency_control WHERE request_id = -1*p_entity_id; --bug16073423

7985: , p_level => c_level_error
7986: );
7987: END IF;
7988: if p_entity_id is not null then
7989: DELETE xla_bal_concurrency_control WHERE request_id = -1*p_entity_id; --bug16073423
7990: else
7991: DELETE xla_bal_concurrency_control WHERE request_id = g_req_id; --bug16073423
7992: end if;
7993:

Line 7991: DELETE xla_bal_concurrency_control WHERE request_id = g_req_id; --bug16073423

7987: END IF;
7988: if p_entity_id is not null then
7989: DELETE xla_bal_concurrency_control WHERE request_id = -1*p_entity_id; --bug16073423
7990: else
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

Line 7997: DELETE xla_bal_concurrency_control WHERE request_id = -1*p_entity_id; --bug16073423

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
8000: end if;
8001:

Line 7999: DELETE xla_bal_concurrency_control WHERE request_id = g_req_id; --bug16073423

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
8000: end if;
8001:
8002: RAISE;
8003: WHEN OTHERS THEN

Line 8005: DELETE xla_bal_concurrency_control WHERE request_id = -1*p_entity_id; --bug16073423

8001:
8002: RAISE;
8003: WHEN OTHERS THEN
8004: if p_entity_id is not null then
8005: DELETE xla_bal_concurrency_control WHERE request_id = -1*p_entity_id; --bug16073423
8006: else
8007: DELETE xla_bal_concurrency_control WHERE request_id = g_req_id; --bug16073423
8008: end if;
8009:

Line 8007: DELETE xla_bal_concurrency_control WHERE request_id = g_req_id; --bug16073423

8003: WHEN OTHERS THEN
8004: if p_entity_id is not null then
8005: DELETE xla_bal_concurrency_control WHERE request_id = -1*p_entity_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');