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

Line 64: xla_upg_errors.upg_error_id%type

60: TYPE t_seg_type IS TABLE OF
61: xla_ae_segment_values.segment_type_code%type
62: INDEX BY BINARY_INTEGER;
63: TYPE t_error_id IS TABLE OF
64: xla_upg_errors.upg_error_id%type
65: INDEX BY BINARY_INTEGER;
66: -------------------------------------------------------------------------------
67: -- declaring global constants
68: -------------------------------------------------------------------------------

Line 227: from xla_upg_errors

223: l_rowcount number(15) := 0;
224:
225: CURSOR csr_application_exists IS
226: select distinct entity_id
227: from xla_upg_errors
228: where error_level = 'A'
229: and application_id = 602
230: and upg_source_application_id = 602;
231:

Line 245: -- Deleting all xla_upg_errors from previous run

241: IF g_log_enabled THEN
242: l_log_module := C_DEFAULT_MODULE||'.Validate_Application_Entries';
243: END IF;
244:
245: -- Deleting all xla_upg_errors from previous run
246:
247: delete from xla_upg_errors
248: where application_id = 602
249: and upg_source_application_id = 602

Line 247: delete from xla_upg_errors

243: END IF;
244:
245: -- Deleting all xla_upg_errors from previous run
246:
247: delete from xla_upg_errors
248: where application_id = 602
249: and upg_source_application_id = 602
250: and error_message_name IN ('XLA_UPG_APP_NOT_DEFINED'
251: ,'XLA_APP_VERIFICATION_RECORD');

Line 254: INSERT /+ APPEND / INTO XLA_UPG_ERRORS

250: and error_message_name IN ('XLA_UPG_APP_NOT_DEFINED'
251: ,'XLA_APP_VERIFICATION_RECORD');
252:
253:
254: INSERT /*+ APPEND */ INTO XLA_UPG_ERRORS
255: (upg_error_id, application_id, upg_source_application_id, creation_date
256: , created_by, last_update_date, last_updated_by, upg_batch_id
257: , error_level, error_message_name,entity_id)
258: (SELECT

Line 259: xla_upg_errors_s.nextval

255: (upg_error_id, application_id, upg_source_application_id, creation_date
256: , created_by, last_update_date, last_updated_by, upg_batch_id
257: , error_level, error_message_name,entity_id)
258: (SELECT
259: xla_upg_errors_s.nextval
260: ,602
261: ,602
262: ,sysdate
263: ,-1

Line 321: INSERT INTO XLA_UPG_ERRORS

317: COMMIT;
318: END LOOP;
319: CLOSE csr_application_exists;
320:
321: INSERT INTO XLA_UPG_ERRORS
322: (upg_error_id, application_id, upg_source_application_id, creation_date
323: , created_by, last_update_date, last_updated_by, upg_batch_id
324: , error_level, error_message_name,entity_id)
325: values(

Line 326: xla_upg_errors_s.nextval

322: (upg_error_id, application_id, upg_source_application_id, creation_date
323: , created_by, last_update_date, last_updated_by, upg_batch_id
324: , error_level, error_message_name,entity_id)
325: values(
326: xla_upg_errors_s.nextval
327: ,602
328: ,602
329: ,sysdate
330: ,-1

Line 379: from xla_upg_errors

375: l_rowcount number(15) := 0;
376:
377: cursor csr_entity_errors is
378: select distinct entity_id
379: from xla_upg_errors
380: where error_level = 'N'
381: and application_id = p_application_id
382: and upg_source_application_id = p_upgrading_application_id;
383:

Line 400: -- Deleting all xla_upg_errors from previous run

396: IF g_log_enabled THEN
397: l_log_module := C_DEFAULT_MODULE||'.Validate_Entity_Entries';
398: END IF;
399:
400: -- Deleting all xla_upg_errors from previous run
401:
402: delete from xla_upg_errors
403: where application_id = p_application_id
404: and upg_source_application_id = p_upgrading_application_id

Line 402: delete from xla_upg_errors

398: END IF;
399:
400: -- Deleting all xla_upg_errors from previous run
401:
402: delete from xla_upg_errors
403: where application_id = p_application_id
404: and upg_source_application_id = p_upgrading_application_id
405: and error_message_name in ('XLA_UPG_ENCODE_INVALID'
406: ,'XLA_ENT_VERIFICATION_RECORD');

Line 408: INSERT /+ APPEND / INTO XLA_UPG_ERRORS

404: and upg_source_application_id = p_upgrading_application_id
405: and error_message_name in ('XLA_UPG_ENCODE_INVALID'
406: ,'XLA_ENT_VERIFICATION_RECORD');
407:
408: INSERT /*+ APPEND */ INTO XLA_UPG_ERRORS
409: (upg_error_id, application_id, upg_source_application_id,creation_date
410: , created_by, last_update_date, last_updated_by, upg_batch_id
411: , error_level, error_message_name,entity_id)
412: (select xla_upg_errors_s.nextval

Line 412: (select xla_upg_errors_s.nextval

408: INSERT /*+ APPEND */ INTO XLA_UPG_ERRORS
409: (upg_error_id, application_id, upg_source_application_id,creation_date
410: , created_by, last_update_date, last_updated_by, upg_batch_id
411: , error_level, error_message_name,entity_id)
412: (select xla_upg_errors_s.nextval
413: ,g_application_id
414: ,g_source_application_id
415: ,sysdate
416: ,-1

Line 478: INSERT INTO XLA_UPG_ERRORS

474: COMMIT;
475: END LOOP;
476: CLOSE csr_entity_errors;
477:
478: INSERT INTO XLA_UPG_ERRORS
479: (upg_error_id, application_id, upg_source_application_id, creation_date
480: ,created_by, last_update_date, last_updated_by, upg_batch_id
481: ,error_level, error_message_name,entity_id)
482: values(

Line 483: xla_upg_errors_s.nextval

479: (upg_error_id, application_id, upg_source_application_id, creation_date
480: ,created_by, last_update_date, last_updated_by, upg_batch_id
481: ,error_level, error_message_name,entity_id)
482: values(
483: xla_upg_errors_s.nextval
484: ,g_application_id
485: ,g_source_application_id
486: ,sysdate
487: ,-1

Line 541: from xla_upg_errors

537: l_rowcount number(15) := 0;
538:
539: CURSOR csr_event_errors IS
540: select distinct event_id
541: from xla_upg_errors
542: where error_level = 'E'
543: and application_id = p_application_id
544: and upg_source_application_id = p_upgrading_application_id;
545:

Line 562: -- Deleting all xla_upg_errors from previous run of this procedure

558: IF g_log_enabled THEN
559: l_log_module := C_DEFAULT_MODULE||'.Validate_Event_Entries';
560: END IF;
561:
562: -- Deleting all xla_upg_errors from previous run of this procedure
563:
564: delete from xla_upg_errors
565: where application_id = p_application_id
566: and upg_source_application_id = p_upgrading_application_id

Line 564: delete from xla_upg_errors

560: END IF;
561:
562: -- Deleting all xla_upg_errors from previous run of this procedure
563:
564: delete from xla_upg_errors
565: where application_id = p_application_id
566: and upg_source_application_id = p_upgrading_application_id
567: and error_message_name in ('XLA_UPG_EVT_NO_ENTITY'
568: ,'XLA_UPG_EVT_INV_ENTITY'

Line 578: INSERT /+ APPEND / INTO XLA_UPG_ERRORS

574: ,'XLA_UPG_ACC_CLASS_INVALID'
575: ,'XLA_EVT_VERIFICATION_RECORD');
576:
577: -- Write Errors
578: INSERT /*+ APPEND */ INTO XLA_UPG_ERRORS
579: (upg_error_id, application_id, upg_source_application_id, creation_date
580: , created_by, last_update_date, last_updated_by, upg_batch_id
581: , error_level, error_message_name, event_id)
582: (select xla_upg_errors_s.nextval

Line 582: (select xla_upg_errors_s.nextval

578: INSERT /*+ APPEND */ INTO XLA_UPG_ERRORS
579: (upg_error_id, application_id, upg_source_application_id, creation_date
580: , created_by, last_update_date, last_updated_by, upg_batch_id
581: , error_level, error_message_name, event_id)
582: (select xla_upg_errors_s.nextval
583: ,g_application_id
584: ,g_source_application_id
585: ,sysdate
586: ,-1

Line 696: INSERT INTO XLA_UPG_ERRORS

692: COMMIT;
693: END LOOP;
694: CLOSE csr_event_errors;
695:
696: INSERT INTO XLA_UPG_ERRORS
697: (upg_error_id, application_id, upg_source_application_id, creation_date
698: , created_by, last_update_date, last_updated_by, upg_batch_id
699: , error_level, error_message_name,entity_id)
700: values( xla_upg_errors_s.nextval

Line 700: values( xla_upg_errors_s.nextval

696: INSERT INTO XLA_UPG_ERRORS
697: (upg_error_id, application_id, upg_source_application_id, creation_date
698: , created_by, last_update_date, last_updated_by, upg_batch_id
699: , error_level, error_message_name,entity_id)
700: values( xla_upg_errors_s.nextval
701: ,g_application_id
702: ,g_source_application_id
703: ,sysdate
704: ,-1

Line 751: from xla_upg_errors

747: l_rowcount number(15) := 0;
748:
749: CURSOR csr_header_entries IS
750: select distinct ae_header_id
751: from xla_upg_errors
752: where error_level = 'H'
753: and application_id = p_application_id
754: and upg_source_application_id = p_upgrading_application_id;
755:

Line 772: -- Deleting all xla_upg_errors from previous run

768: IF g_log_enabled THEN
769: l_log_module := C_DEFAULT_MODULE||'.Validate_Header_Entries';
770: END IF;
771:
772: -- Deleting all xla_upg_errors from previous run
773:
774: delete from xla_upg_errors
775: where application_id = p_application_id
776: and upg_source_application_id = p_upgrading_application_id

Line 774: delete from xla_upg_errors

770: END IF;
771:
772: -- Deleting all xla_upg_errors from previous run
773:
774: delete from xla_upg_errors
775: where application_id = p_application_id
776: and upg_source_application_id = p_upgrading_application_id
777: and error_message_name IN ('XLA_UPG_LEDGER_INVALID'
778: ,'XLA_UPG_NO_BUDGET_VER'

Line 787: INSERT /+ APPEND / INTO XLA_UPG_ERRORS

783: ,'XLA_UPG_UNBAL_ENTRAMT'
784: ,'XLA_UPG_HDR_WO_LINES'
785: ,'XLA_HDR_VERIFICATION_RECORD');
786:
787: INSERT /*+ APPEND */ INTO XLA_UPG_ERRORS
788: (upg_error_id, application_id, upg_source_application_id, creation_date
789: , created_by, last_update_date, last_updated_by, upg_batch_id
790: , error_level, error_message_name, ae_header_id)
791: (select

Line 792: xla_upg_errors_s.nextval

788: (upg_error_id, application_id, upg_source_application_id, creation_date
789: , created_by, last_update_date, last_updated_by, upg_batch_id
790: , error_level, error_message_name, ae_header_id)
791: (select
792: xla_upg_errors_s.nextval
793: ,g_application_id
794: ,g_source_application_id
795: ,sysdate
796: ,-1

Line 846: INSERT /+ APPEND / INTO XLA_UPG_ERRORS

842: header_error5) = 'Y');
843:
844: COMMIT;
845:
846: INSERT /*+ APPEND */ INTO XLA_UPG_ERRORS
847: (upg_error_id, application_id, upg_source_application_id, creation_date
848: , created_by, last_update_date, last_updated_by, upg_batch_id
849: , error_level, error_message_name, ae_header_id)
850: (select

Line 851: xla_upg_errors_s.nextval

847: (upg_error_id, application_id, upg_source_application_id, creation_date
848: , created_by, last_update_date, last_updated_by, upg_batch_id
849: , error_level, error_message_name, ae_header_id)
850: (select
851: xla_upg_errors_s.nextval
852: ,g_application_id
853: ,g_source_application_id
854: ,sysdate
855: ,-1

Line 890: INSERT /+ APPEND / INTO XLA_UPG_ERRORS

886: and xah.balance_type_code <> 'B')
887: and grm.multiplier < 3
888: and decode(grm.multiplier, 1, header_error1, header_error2) = 'Y');
889:
890: INSERT /*+ APPEND */ INTO XLA_UPG_ERRORS
891: (upg_error_id, application_id, upg_source_application_id,creation_date
892: , created_by, last_update_date, last_updated_by, upg_batch_id
893: , error_level, ae_header_id, error_message_name)
894: (select xla_upg_errors_s.nextval

Line 894: (select xla_upg_errors_s.nextval

890: INSERT /*+ APPEND */ INTO XLA_UPG_ERRORS
891: (upg_error_id, application_id, upg_source_application_id,creation_date
892: , created_by, last_update_date, last_updated_by, upg_batch_id
893: , error_level, ae_header_id, error_message_name)
894: (select xla_upg_errors_s.nextval
895: ,g_application_id
896: ,g_source_application_id
897: ,sysdate
898: ,-1

Line 941: INSERT INTO XLA_UPG_ERRORS

937: COMMIT;
938: END LOOP;
939: CLOSE csr_header_entries;
940:
941: INSERT INTO XLA_UPG_ERRORS
942: (upg_error_id, application_id, upg_source_application_id, creation_date
943: , created_by, last_update_date, last_updated_by, upg_batch_id
944: , error_level, error_message_name,entity_id)
945: values(

Line 946: xla_upg_errors_s.nextval

942: (upg_error_id, application_id, upg_source_application_id, creation_date
943: , created_by, last_update_date, last_updated_by, upg_batch_id
944: , error_level, error_message_name,entity_id)
945: values(
946: xla_upg_errors_s.nextval
947: ,g_application_id
948: ,g_source_application_id
949: ,sysdate
950: ,-1

Line 1002: from xla_upg_errors

998: l_rowcount number(15) := 0;
999:
1000: CURSOR csr_line_errors IS
1001: select distinct ae_header_id
1002: from xla_upg_errors
1003: where error_level = 'L'
1004: and application_id = p_application_id
1005: and upg_Source_application_id = p_upgrading_application_id;
1006: BEGIN

Line 1022: -- Deleting all xla_upg_errors from previous run

1018: IF g_log_enabled THEN
1019: l_log_module := C_DEFAULT_MODULE||'.Validate_Line_Entries';
1020: END IF;
1021:
1022: -- Deleting all xla_upg_errors from previous run
1023:
1024: delete from xla_upg_errors
1025: where application_id = p_application_id
1026: and upg_source_application_id = p_upgrading_application_id

Line 1024: delete from xla_upg_errors

1020: END IF;
1021:
1022: -- Deleting all xla_upg_errors from previous run
1023:
1024: delete from xla_upg_errors
1025: where application_id = p_application_id
1026: and upg_source_application_id = p_upgrading_application_id
1027: and error_message_name IN ('XLA_UPG_CCID_INVALID'
1028: ,'XLA_UPG_CCID_SUMACCT'

Line 1039: INSERT /+ APPEND / INTO XLA_UPG_ERRORS

1035: ,'XLA_UPG_PARTY_ID_INVALID'
1036: ,'XLA_UPG_PARTY_SITE_INVALID'
1037: ,'XLA_LINE_VERIFICATION_RECORD');
1038:
1039: INSERT /*+ APPEND */ INTO XLA_UPG_ERRORS
1040: (upg_error_id, application_id, upg_source_application_id, creation_date
1041: , created_by, last_update_date, last_updated_by, upg_batch_id
1042: , error_level, ae_header_id, ae_line_num,error_message_name)
1043: (select

Line 1044: xla_upg_errors_s.nextval

1040: (upg_error_id, application_id, upg_source_application_id, creation_date
1041: , created_by, last_update_date, last_updated_by, upg_batch_id
1042: , error_level, ae_header_id, ae_line_num,error_message_name)
1043: (select
1044: xla_upg_errors_s.nextval
1045: ,g_application_id
1046: ,g_source_application_id
1047: ,sysdate
1048: ,-1

Line 1189: INSERT INTO XLA_UPG_ERRORS

1185: COMMIT;
1186: END LOOP;
1187: CLOSE csr_line_errors;
1188:
1189: INSERT INTO XLA_UPG_ERRORS
1190: (upg_error_id, application_id, upg_source_application_id, creation_date
1191: , created_by, last_update_date, last_updated_by, upg_batch_id
1192: , error_level, error_message_name,entity_id)
1193: values(

Line 1194: xla_upg_errors_s.nextval

1190: (upg_error_id, application_id, upg_source_application_id, creation_date
1191: , created_by, last_update_date, last_updated_by, upg_batch_id
1192: , error_level, error_message_name,entity_id)
1193: values(
1194: xla_upg_errors_s.nextval
1195: ,g_application_id
1196: ,g_source_application_id
1197: ,sysdate
1198: ,-1

Line 1239: from xla_upg_errors

1235: l_rowcount number(10) := 0;
1236:
1237: CURSOR csr_distribution_errors IS
1238: select distinct ae_header_id
1239: from xla_upg_errors
1240: where error_level = 'D'
1241: and application_id = p_application_id;
1242:
1243: BEGIN

Line 1258: delete from xla_upg_errors

1254: IF g_log_enabled THEN
1255: l_log_module := C_DEFAULT_MODULE||'.Validate_Distribution_Entries';
1256: END IF;
1257:
1258: delete from xla_upg_errors
1259: where application_id = p_application_id
1260: and error_message_name IN ('XLA_UPG_LINK_NO_LINE'
1261: ,'XLA_DIST_VERIFICATION_RECORD');
1262:

Line 1263: INSERT /+ APPEND / INTO XLA_UPG_ERRORS

1259: where application_id = p_application_id
1260: and error_message_name IN ('XLA_UPG_LINK_NO_LINE'
1261: ,'XLA_DIST_VERIFICATION_RECORD');
1262:
1263: INSERT /*+ APPEND */ INTO XLA_UPG_ERRORS
1264: (upg_error_id, application_id, upg_source_application_id,creation_date
1265: , created_by, last_update_date, last_updated_by, upg_batch_id
1266: , error_level, ae_header_id, ae_line_num, temp_line_num
1267: , error_message_name)

Line 1269: xla_upg_errors_s.nextval

1265: , created_by, last_update_date, last_updated_by, upg_batch_id
1266: , error_level, ae_header_id, ae_line_num, temp_line_num
1267: , error_message_name)
1268: (select
1269: xla_upg_errors_s.nextval
1270: ,g_application_id
1271: ,602
1272: ,sysdate
1273: ,-1

Line 1329: INSERT INTO XLA_UPG_ERRORS

1325: COMMIT;
1326: END LOOP;
1327: CLOSE csr_distribution_errors;
1328:
1329: INSERT INTO XLA_UPG_ERRORS
1330: (upg_error_id, application_id, upg_source_application_id, creation_date
1331: , created_by, last_update_date, last_updated_by, upg_batch_id
1332: , error_level, error_message_name,entity_id)
1333: values(

Line 1334: xla_upg_errors_s.nextval

1330: (upg_error_id, application_id, upg_source_application_id, creation_date
1331: , created_by, last_update_date, last_updated_by, upg_batch_id
1332: , error_level, error_message_name,entity_id)
1333: values(
1334: xla_upg_errors_s.nextval
1335: ,g_application_id
1336: ,602
1337: ,sysdate
1338: ,-1