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.

[Home] [Help]

APPS.XLA_TB_DATA_MANAGER_PVT dependencies on XLA_TB_LOGS

Line 1268: DELETE xla_tb_logs

1264: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1265: trace('Deleting log entry',C_LEVEL_STATEMENT,l_Log_module);
1266: END IF;
1267:
1268: DELETE xla_tb_logs
1269: WHERE request_id = g_request_id;
1270:
1271:
1272: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN

Line 1793: DELETE xla_tb_logs

1789:
1790: DELETE xla_tb_def_seg_ranges
1791: WHERE definition_code = p_definition_code;
1792:
1793: DELETE xla_tb_logs
1794: WHERE definition_code = p_definition_code;
1795:
1796: ELSE
1797:

Line 1798: DELETE xla_tb_logs

1794: WHERE definition_code = p_definition_code;
1795:
1796: ELSE
1797:
1798: DELETE xla_tb_logs
1799: WHERE definition_code = p_definition_code
1800: AND je_source_name = g_je_source_name;
1801:
1802: DELETE xla_tb_user_trans_views

Line 1891: DELETE xla_tb_logs

1887:
1888: --DELETE xla_tb_processes
1889: --WHERE definition_code = p_definition_code;
1890:
1891: DELETE xla_tb_logs
1892: WHERE definition_code = p_definition_code;
1893:
1894: ELSE
1895:

Line 1900: DELETE xla_tb_logs

1896: DELETE xla_tb_defn_je_sources
1897: WHERE definition_code = p_definition_code
1898: AND je_source_name = g_je_source_name;
1899:
1900: DELETE xla_tb_logs
1901: WHERE definition_code = p_definition_code
1902: AND je_source_name = g_je_source_name;
1903:
1904: DELETE xla_tb_user_trans_views

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

3408: trace('insert_tb_logs.Begin',C_LEVEL_PROCEDURE,l_Log_module);
3409: END IF;
3410:
3411: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3412: trace('Inserting into the xla_tb_logs table.',C_LEVEL_STATEMENT,l_Log_module);
3413: END IF;
3414:
3415: INSERT INTO xla_tb_logs
3416: ( REQUEST_ID

Line 3415: INSERT INTO xla_tb_logs

3411: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3412: trace('Inserting into the xla_tb_logs table.',C_LEVEL_STATEMENT,l_Log_module);
3413: END IF;
3414:
3415: INSERT INTO xla_tb_logs
3416: ( REQUEST_ID
3417: , LEDGER_ID
3418: , GROUP_ID
3419: , PROCESS_MODE_CODE

Line 3712: FROM xla_tb_logs xtb

3708:
3709: -- Find a failed request for a specific defintion
3710: CURSOR c_failed_req_def IS
3711: SELECT xtb.request_id, xtb.process_mode_code
3712: FROM xla_tb_logs xtb
3713: ,fnd_concurrent_requests fcr
3714: WHERE xtb.ledger_id = p_ledger_id
3715: AND xtb.definition_code = p_definition_code
3716: AND xtb.request_status_code = 'PROCESSING'

Line 3723: FROM xla_tb_logs xtb

3719:
3720: -- Find requests failed for a group_id or not specific to a definition code
3721: CURSOR c_failed_req ( p_ledger_id VARCHAR2 ) IS
3722: SELECT xtb.request_id
3723: FROM xla_tb_logs xtb
3724: ,fnd_concurrent_requests fcr
3725: WHERE xtb.ledger_id = p_ledger_id
3726: AND xtb.definition_code IS NULL
3727: AND xtb.request_status_code = 'PROCESSING'

Line 3772: DELETE xla_tb_logs

3768: trace('Work units updated (g_wu_count) = ' || g_wu_count,C_LEVEL_STATEMENT,l_Log_module);
3769: trace('failed_req_rec - Deleting TB logs',C_LEVEL_STATEMENT,l_Log_module);
3770: END IF;
3771:
3772: DELETE xla_tb_logs
3773: WHERE request_id = failed_req_rec.request_id;
3774:
3775: END LOOP;
3776: ELSE

Line 3795: DELETE xla_tb_logs

3791: trace('Work units updated = ' || g_wu_count,C_LEVEL_STATEMENT,l_Log_module);
3792: trace('Work units updated rowcount = ' || SQL%ROWCOUNT,C_LEVEL_STATEMENT,l_Log_module);
3793: END IF;
3794:
3795: DELETE xla_tb_logs
3796: WHERE request_id = failed_req_rec.request_id;
3797: END LOOP;
3798: END IF;
3799:

Line 3804: DELETE xla_tb_logs xtl

3800: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3801: trace('Deleting entries from TB logs for failed requests.',C_LEVEL_STATEMENT,l_Log_module);
3802: END IF;
3803:
3804: DELETE xla_tb_logs xtl
3805: WHERE request_id NOT IN
3806: ( SELECT xtb.request_id
3807: FROM xla_tb_logs xtb
3808: ,fnd_concurrent_requests fcr

Line 3807: FROM xla_tb_logs xtb

3803:
3804: DELETE xla_tb_logs xtl
3805: WHERE request_id NOT IN
3806: ( SELECT xtb.request_id
3807: FROM xla_tb_logs xtb
3808: ,fnd_concurrent_requests fcr
3809: WHERE xtb.ledger_id = p_ledger_id
3810: AND nvl(xtb.definition_code,'###') = NVL(p_definition_code,'###')
3811: AND xtb.request_status_code = 'PROCESSING'

Line 4719: xla_tb_logs which belongs to different group_id */

4715: -- Recover failed batches.
4716: -- IF p_group_id IS NULL
4717: /*Bug#7338524 Changed this condition to group_id IS NOT NULL as in case of transfer
4718: to GL group_id is passed and recovery needs to be done for failed batches lying in
4719: xla_tb_logs which belongs to different group_id */
4720:
4721: IF p_group_id IS NOT NULL
4722: --OR (p_definition_code IS NOT NULL AND p_process_mode_code IS NULL)
4723: /* commented this condition as part of bug#7344564 which needs review and

Line 5064: | - xla_tb_logs |

5060: | |
5061: | Delete_Non_UI_Rows |
5062: | |
5063: | Deletes rows from the following tables: |
5064: | - xla_tb_logs |
5065: | - xla_tb_def_seg_ranges |
5066: | - xla_tb_user_trans_views |
5067: | - xla_tb_work_units |
5068: | |

Line 5087: DELETE xla_tb_logs

5083: ,C_LEVEL_PROCEDURE
5084: ,l_log_module);
5085: END IF;
5086:
5087: DELETE xla_tb_logs
5088: WHERE definition_code = p_definition_code;
5089:
5090: DELETE xla_tb_def_seg_ranges
5091: WHERE definition_code = p_definition_code;