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_UPGRADE_PUB dependencies on XLA_UPG_ERRORS

Line 93: xla_upg_errors.upg_error_id%type

89: TYPE t_seg_type IS TABLE OF
90: xla_ae_segment_values.segment_type_code%type
91: INDEX BY BINARY_INTEGER;
92: TYPE t_error_id IS TABLE OF
93: xla_upg_errors.upg_error_id%type
94: INDEX BY BINARY_INTEGER;
95: TYPE T_ARRAY_LEDGER_ID IS TABLE OF XLA_TRANSACTION_ENTITIES.LEDGER_ID%TYPE
96: INDEX BY BINARY_INTEGER ; -- bug:8717476
97:

Line 681: from xla_upg_errors

677: +============================================================================*/
678: PROCEDURE recover_previous_run IS
679: cursor csr_previous_entity_errors IS
680: select entity_id
681: from xla_upg_errors
682: where error_level = 'N'
683: and upg_batch_id = g_batch_id;
684:
685: cursor csr_previous_event_errors IS

Line 687: from xla_upg_errors

683: and upg_batch_id = g_batch_id;
684:
685: cursor csr_previous_event_errors IS
686: select event_id
687: from xla_upg_errors
688: where error_level = 'E'
689: and upg_batch_id = g_batch_id;
690:
691: cursor csr_previous_header_errors IS

Line 693: from xla_upg_errors

689: and upg_batch_id = g_batch_id;
690:
691: cursor csr_previous_header_errors IS
692: select distinct ae_header_id
693: from xla_upg_errors
694: where error_level IN ('H','L','D')
695: and upg_batch_id = g_batch_id;
696:
697: cursor csr_previous_errors IS

Line 699: from xla_upg_errors

695: and upg_batch_id = g_batch_id;
696:
697: cursor csr_previous_errors IS
698: select upg_error_id
699: from xla_upg_errors
700: where upg_batch_id = g_batch_id;
701:
702: cursor csr_segs_previous_run IS
703: select ae_header_id, segment_type_code

Line 776: delete xla_upg_errors

772: LIMIT g_batch_size;
773: EXIT WHEN l_error_id.COUNT = 0;
774:
775: FORALL i IN l_error_id.FIRST..l_error_id.LAST
776: delete xla_upg_errors
777: where upg_error_id = l_error_id(i);
778:
779: COMMIT;
780: END LOOP;

Line 2436: -- Deleting all xla_upg_errors from previous run

2432: IF g_log_enabled THEN
2433: l_log_module := C_DEFAULT_MODULE||'.Validate_Header_Line_Entries';
2434: END IF;
2435:
2436: -- Deleting all xla_upg_errors from previous run
2437:
2438: delete from xla_upg_errors
2439: where application_id = p_application_id
2440: and error_message_name IN ('XLA_UPG_LEDGER_INVALID'

Line 2438: delete from xla_upg_errors

2434: END IF;
2435:
2436: -- Deleting all xla_upg_errors from previous run
2437:
2438: delete from xla_upg_errors
2439: where application_id = p_application_id
2440: and error_message_name IN ('XLA_UPG_LEDGER_INVALID'
2441: ,'XLA_UPG_NO_BUDGET_VER'
2442: ,'XLA_UPG_NO_ENC_TYPE'

Line 2461: INSERT /+ APPEND / INTO XLA_UPG_ERRORS

2457: ,'XLA_UPG_PARTY_SITE_INVALID'
2458: ,'XLA_LINE_VERIFICATION_RECORD'
2459: ,'XLA_HDR_VERIFICATION_RECORD');
2460:
2461: INSERT /*+ APPEND */ INTO XLA_UPG_ERRORS
2462: (upg_error_id, application_id, upg_source_application_id, creation_date
2463: , created_by, last_update_date, last_updated_by, upg_batch_id
2464: , error_level, error_message_name, ae_header_id)
2465: (select

Line 2466: xla_upg_errors_s.nextval

2462: (upg_error_id, application_id, upg_source_application_id, creation_date
2463: , created_by, last_update_date, last_updated_by, upg_batch_id
2464: , error_level, error_message_name, ae_header_id)
2465: (select
2466: xla_upg_errors_s.nextval
2467: ,g_application_id
2468: ,-9999
2469: ,sysdate
2470: ,-1

Line 2521: INSERT /+ APPEND / INTO XLA_UPG_ERRORS

2517: COMMIT;
2518:
2519: l_rowcount := l_rowcount + sql%rowcount;
2520:
2521: INSERT /*+ APPEND */ INTO XLA_UPG_ERRORS
2522: (upg_error_id, application_id, upg_source_application_id, creation_date
2523: , created_by, last_update_date, last_updated_by, upg_batch_id
2524: , error_level, error_message_name, ae_header_id)
2525: (select

Line 2526: xla_upg_errors_s.nextval

2522: (upg_error_id, application_id, upg_source_application_id, creation_date
2523: , created_by, last_update_date, last_updated_by, upg_batch_id
2524: , error_level, error_message_name, ae_header_id)
2525: (select
2526: xla_upg_errors_s.nextval
2527: ,g_application_id
2528: ,-9999
2529: ,sysdate
2530: ,-1

Line 2569: INSERT /+ APPEND / INTO XLA_UPG_ERRORS

2565: COMMIT;
2566:
2567: l_rowcount := l_rowcount + sql%rowcount;
2568:
2569: INSERT /*+ APPEND */ INTO XLA_UPG_ERRORS
2570: (upg_error_id, application_id, upg_source_application_id,creation_date
2571: , created_by, last_update_date, last_updated_by, upg_batch_id
2572: , error_level, ae_header_id, error_message_name)
2573: (select xla_upg_errors_s.nextval

Line 2573: (select xla_upg_errors_s.nextval

2569: INSERT /*+ APPEND */ INTO XLA_UPG_ERRORS
2570: (upg_error_id, application_id, upg_source_application_id,creation_date
2571: , created_by, last_update_date, last_updated_by, upg_batch_id
2572: , error_level, ae_header_id, error_message_name)
2573: (select xla_upg_errors_s.nextval
2574: ,g_application_id
2575: ,-9999
2576: ,sysdate
2577: ,-1

Line 2611: INSERT INTO XLA_UPG_ERRORS

2607: end if;
2608:
2609: l_rowcount := sql%rowcount;
2610:
2611: INSERT INTO XLA_UPG_ERRORS
2612: (upg_error_id, application_id, upg_source_application_id, creation_date
2613: , created_by, last_update_date, last_updated_by, upg_batch_id
2614: , error_level, error_message_name,entity_id)
2615: values(

Line 2616: xla_upg_errors_s.nextval

2612: (upg_error_id, application_id, upg_source_application_id, creation_date
2613: , created_by, last_update_date, last_updated_by, upg_batch_id
2614: , error_level, error_message_name,entity_id)
2615: values(
2616: xla_upg_errors_s.nextval
2617: ,g_application_id
2618: ,-9999
2619: ,sysdate
2620: ,-1

Line 2632: INSERT /+ APPEND / INTO XLA_UPG_ERRORS

2628: COMMIT;
2629:
2630: l_rowcount := 0;
2631:
2632: INSERT /*+ APPEND */ INTO XLA_UPG_ERRORS
2633: (upg_error_id, application_id, upg_source_application_id, creation_date
2634: , created_by, last_update_date, last_updated_by, upg_batch_id
2635: , error_level, ae_header_id, ae_line_num,error_message_name)
2636: (select

Line 2637: xla_upg_errors_s.nextval

2633: (upg_error_id, application_id, upg_source_application_id, creation_date
2634: , created_by, last_update_date, last_updated_by, upg_batch_id
2635: , error_level, ae_header_id, ae_line_num,error_message_name)
2636: (select
2637: xla_upg_errors_s.nextval
2638: ,g_application_id
2639: ,-9999
2640: ,sysdate
2641: ,-1

Line 2770: INSERT INTO XLA_UPG_ERRORS

2766: -- finding out how many rows got updated.
2767:
2768: l_rowcount := sql%rowcount;
2769:
2770: INSERT INTO XLA_UPG_ERRORS
2771: (upg_error_id, application_id, upg_source_application_id, creation_date
2772: , created_by, last_update_date, last_updated_by, upg_batch_id
2773: , error_level, error_message_name,entity_id)
2774: values(

Line 2775: xla_upg_errors_s.nextval

2771: (upg_error_id, application_id, upg_source_application_id, creation_date
2772: , created_by, last_update_date, last_updated_by, upg_batch_id
2773: , error_level, error_message_name,entity_id)
2774: values(
2775: xla_upg_errors_s.nextval
2776: ,g_application_id
2777: ,-9999
2778: ,sysdate
2779: ,-1