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_TB_DATA_MANAGER_PVT dependencies on XLA_TB_LOGS

Line 1313: DELETE xla_tb_logs

1309: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1310: trace('Deleting log entry',C_LEVEL_STATEMENT,l_Log_module);
1311: END IF;
1312:
1313: DELETE xla_tb_logs
1314: WHERE request_id = g_request_id;
1315:
1316:
1317: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN

Line 1842: DELETE xla_tb_logs

1838:
1839: DELETE xla_tb_def_seg_ranges
1840: WHERE definition_code = p_definition_code;
1841:
1842: DELETE xla_tb_logs
1843: WHERE definition_code = p_definition_code;
1844:
1845: ELSE
1846:

Line 1847: DELETE xla_tb_logs

1843: WHERE definition_code = p_definition_code;
1844:
1845: ELSE
1846:
1847: DELETE xla_tb_logs
1848: WHERE definition_code = p_definition_code
1849: AND je_source_name = g_je_source_name;
1850:
1851: DELETE xla_tb_user_trans_views

Line 1940: DELETE xla_tb_logs

1936:
1937: --DELETE xla_tb_processes
1938: --WHERE definition_code = p_definition_code;
1939:
1940: DELETE xla_tb_logs
1941: WHERE definition_code = p_definition_code;
1942:
1943: ELSE
1944:

Line 1949: DELETE xla_tb_logs

1945: DELETE xla_tb_defn_je_sources
1946: WHERE definition_code = p_definition_code
1947: AND je_source_name = g_je_source_name;
1948:
1949: DELETE xla_tb_logs
1950: WHERE definition_code = p_definition_code
1951: AND je_source_name = g_je_source_name;
1952:
1953: DELETE xla_tb_user_trans_views

Line 3565: trace('Inserting into the xla_tb_logs table.',C_LEVEL_STATEMENT,l_Log_module);

3561: trace('insert_tb_logs.Begin',C_LEVEL_PROCEDURE,l_Log_module);
3562: END IF;
3563:
3564: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3565: trace('Inserting into the xla_tb_logs table.',C_LEVEL_STATEMENT,l_Log_module);
3566: END IF;
3567:
3568: INSERT INTO xla_tb_logs
3569: ( REQUEST_ID

Line 3568: INSERT INTO xla_tb_logs

3564: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3565: trace('Inserting into the xla_tb_logs table.',C_LEVEL_STATEMENT,l_Log_module);
3566: END IF;
3567:
3568: INSERT INTO xla_tb_logs
3569: ( REQUEST_ID
3570: , LEDGER_ID
3571: , GROUP_ID
3572: , PROCESS_MODE_CODE

Line 3865: FROM xla_tb_logs xtb

3861:
3862: -- Find a failed request for a specific defintion
3863: CURSOR c_failed_req_def IS
3864: SELECT xtb.request_id, xtb.process_mode_code
3865: FROM xla_tb_logs xtb
3866: ,fnd_concurrent_requests fcr
3867: WHERE xtb.ledger_id = p_ledger_id
3868: AND xtb.definition_code = p_definition_code
3869: AND xtb.request_status_code = 'PROCESSING'

Line 3876: FROM xla_tb_logs xtb

3872:
3873: -- Find requests failed for a group_id or not specific to a definition code
3874: CURSOR c_failed_req ( p_ledger_id VARCHAR2 ) IS
3875: SELECT xtb.request_id
3876: FROM xla_tb_logs xtb
3877: ,fnd_concurrent_requests fcr
3878: WHERE xtb.ledger_id = p_ledger_id
3879: AND xtb.definition_code IS NULL
3880: AND xtb.request_status_code = 'PROCESSING'

Line 3925: DELETE xla_tb_logs

3921: trace('Work units updated (g_wu_count) = ' || g_wu_count,C_LEVEL_STATEMENT,l_Log_module);
3922: trace('failed_req_rec - Deleting TB logs',C_LEVEL_STATEMENT,l_Log_module);
3923: END IF;
3924:
3925: DELETE xla_tb_logs
3926: WHERE request_id = failed_req_rec.request_id;
3927:
3928: END LOOP;
3929: ELSE

Line 3948: DELETE xla_tb_logs

3944: trace('Work units updated = ' || g_wu_count,C_LEVEL_STATEMENT,l_Log_module);
3945: trace('Work units updated rowcount = ' || SQL%ROWCOUNT,C_LEVEL_STATEMENT,l_Log_module);
3946: END IF;
3947:
3948: DELETE xla_tb_logs
3949: WHERE request_id = failed_req_rec.request_id;
3950: END LOOP;
3951: END IF;
3952:

Line 3957: DELETE xla_tb_logs xtl

3953: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3954: trace('Deleting entries from TB logs for failed requests.',C_LEVEL_STATEMENT,l_Log_module);
3955: END IF;
3956:
3957: DELETE xla_tb_logs xtl
3958: WHERE request_id NOT IN
3959: ( SELECT xtb.request_id
3960: FROM xla_tb_logs xtb
3961: ,fnd_concurrent_requests fcr

Line 3960: FROM xla_tb_logs xtb

3956:
3957: DELETE xla_tb_logs xtl
3958: WHERE request_id NOT IN
3959: ( SELECT xtb.request_id
3960: FROM xla_tb_logs xtb
3961: ,fnd_concurrent_requests fcr
3962: WHERE xtb.ledger_id = p_ledger_id
3963: AND nvl(xtb.definition_code,'###') = NVL(p_definition_code,'###')
3964: AND xtb.request_status_code = 'PROCESSING'

Line 4875: xla_tb_logs which belongs to different group_id */

4871: -- Recover failed batches.
4872: -- IF p_group_id IS NULL
4873: /*Bug#7338524 Changed this condition to group_id IS NOT NULL as in case of transfer
4874: to GL group_id is passed and recovery needs to be done for failed batches lying in
4875: xla_tb_logs which belongs to different group_id */
4876:
4877: IF p_group_id IS NOT NULL
4878: --OR (p_definition_code IS NOT NULL AND p_process_mode_code IS NULL)
4879: /* commented this condition as part of bug#7344564 which needs review and

Line 5220: | - xla_tb_logs |

5216: | |
5217: | Delete_Non_UI_Rows |
5218: | |
5219: | Deletes rows from the following tables: |
5220: | - xla_tb_logs |
5221: | - xla_tb_def_seg_ranges |
5222: | - xla_tb_user_trans_views |
5223: | - xla_tb_work_units |
5224: | |

Line 5243: DELETE xla_tb_logs

5239: ,C_LEVEL_PROCEDURE
5240: ,l_log_module);
5241: END IF;
5242:
5243: DELETE xla_tb_logs
5244: WHERE definition_code = p_definition_code;
5245:
5246: DELETE xla_tb_def_seg_ranges
5247: WHERE definition_code = p_definition_code;