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.HZ_BATCH_IMPORT_PKG dependencies on HZ_IMP_BATCH_SUMMARY

Line 204: FROM hz_imp_batch_summary

200: BEGIN
201:
202: SELECT registry_dedup_flag, batch_dedup_flag
203: INTO l_reg_dedup, l_batch_dedup
204: FROM hz_imp_batch_summary
205: WHERE batch_id = p_batch_id;
206:
207: -- call the DQM cleanup routine
208: IF l_reg_dedup = 'Y' OR l_batch_dedup = 'Y' THEN

Line 476: select * from hz_imp_batch_summary

472:
473: -- cursor to get the batch information
474: cursor c_batch_info
475: is
476: select * from hz_imp_batch_summary
477: where batch_id = p_batch_id;
478:
479: r_batch_info c_batch_info%ROWTYPE;
480:

Line 616: UPDATE hz_imp_batch_summary

612: IF l_req_data = 'BATCH_DEDUP'
613: AND
614: (l_temp_dstatus <> 'NORMAL' OR r_batch_info.batch_dedup_status = 'ERROR')
615: THEN
616: UPDATE hz_imp_batch_summary
617: SET batch_dedup_status = 'ERROR',
618: batch_status = 'ACTION_REQUIRED',
619: main_conc_status = 'COMPLETED'
620: WHERE batch_id = p_batch_id;

Line 635: UPDATE hz_imp_batch_summary

631: IF l_req_data = 'ADDR_VAL'
632: AND
633: (l_temp_dstatus <> 'NORMAL' OR r_batch_info.addr_val_status = 'ERROR')
634: THEN
635: UPDATE hz_imp_batch_summary
636: SET addr_val_status = 'ERROR',
637: batch_status = 'ACTION_REQUIRED',
638: main_conc_status = 'COMPLETED'
639: WHERE batch_id = p_batch_id;

Line 654: UPDATE hz_imp_batch_summary

650: IF l_req_data = 'DATA_LOAD'
651: AND
652: (l_temp_dstatus <> 'NORMAL' OR r_batch_info.import_status = 'ERROR')
653: THEN
654: UPDATE hz_imp_batch_summary
655: SET import_status = 'ERROR',
656: batch_status = 'ACTION_REQUIRED',
657: main_conc_status = 'COMPLETED'
658: WHERE batch_id = p_batch_id;

Line 885: UPDATE hz_imp_batch_summary

881:
882: -- Bug 4530477
883: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Error***** '||FND_MESSAGE.GET);
884:
885: UPDATE hz_imp_batch_summary
886: SET main_conc_status = 'ERROR',
887: batch_status = 'ACTION_REQUIRED'
888: WHERE batch_id = p_batch_id;
889:

Line 912: UPDATE hz_imp_batch_summary

908: THEN
909:
910: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Error***** '||'The Match Rule selected for Registry De-duplication does not allow Automerge. Please resubmit the batch for import and select No for request parameter Run Automerge.');
911:
912: UPDATE hz_imp_batch_summary
913: SET main_conc_status = 'ERROR',
914: batch_status = 'ACTION_REQUIRED'
915: WHERE batch_id = p_batch_id;
916:

Line 923: UPDATE HZ_IMP_BATCH_SUMMARY

919:
920: RETURN;
921: END IF;
922: END IF;
923: UPDATE HZ_IMP_BATCH_SUMMARY
924: SET AUTOMERGE_FLAG=p_run_automerge
925: WHERE batch_id=p_batch_id;
926: END IF;
927: END;

Line 936: UPDATE hz_imp_batch_summary

932:
933: IF not ( NVL(r_batch_info.import_status,'X') in
934: ( 'ACTION_REQUIRED', 'COMPL_ERROR_LIMIT', 'COMPL_ERRORS' )) THEN
935: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Pre-import has not been performed for this batch.');
936: UPDATE hz_imp_batch_summary
937: SET batch_status = 'ACTION_REQUIRED'
938: WHERE batch_id = p_batch_id;
939: RETURN;
940: END IF;

Line 1072: UPDATE hz_imp_batch_summary

1068: END IF;
1069:
1070: IF (l_rule_id_missing) then
1071: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Data Import cannot proceed, exit with error');
1072: UPDATE hz_imp_batch_summary
1073: SET main_conc_status = 'ERROR'
1074: WHERE batch_id = p_batch_id;
1075: retcode := 2;
1076: RETURN;

Line 1080: UPDATE hz_imp_batch_summary

1076: RETURN;
1077: END IF;
1078:
1079: -- set the processing status appropriately
1080: UPDATE hz_imp_batch_summary
1081: SET batch_dedup_flag = decode(p_run_batch_dedup, 'Y', 'Y', 'N'),
1082: batch_dedup_status = decode(p_run_batch_dedup, 'Y', 'PENDING', 'DECLINED'),
1083: batch_dedup_match_rule_id = decode(p_run_batch_dedup, 'Y', p_batch_dedup_rule_id, null),
1084: addr_val_flag = decode(p_run_addr_val, 'Y', 'Y', 'N'),

Line 1187: UPDATE hz_imp_batch_summary

1183: l_num_of_workers
1184: );
1185:
1186: IF l_bd_sub_request = 0 THEN
1187: UPDATE hz_imp_batch_summary
1188: SET main_conc_status = 'COMPLETED',
1189: batch_status = 'ACTION_REQUIRED'
1190: WHERE batch_id = p_batch_id;
1191: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Error submitting batch de-duplication');

Line 1196: UPDATE hz_imp_batch_summary

1192: RETURN;
1193: ELSE
1194: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Submitted request for batch de-dupication');
1195:
1196: UPDATE hz_imp_batch_summary
1197: SET batch_dedup_req_id = l_bd_sub_request
1198: WHERE batch_id = p_batch_id;
1199:
1200: END IF;

Line 1256: UPDATE hz_imp_batch_summary

1252: p_batch_id
1253: );
1254:
1255: IF l_av_sub_request = 0 THEN
1256: UPDATE hz_imp_batch_summary
1257: SET main_conc_status = 'COMPLETED',
1258: batch_status = 'ACTION_REQUIRED'
1259: WHERE batch_id = p_batch_id;
1260: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Error submitting address validation');

Line 1265: UPDATE hz_imp_batch_summary

1261: RETURN;
1262: ELSE
1263: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Submitted request for addrress validation');
1264:
1265: UPDATE hz_imp_batch_summary
1266: SET addr_val_req_id = l_av_sub_request
1267: WHERE batch_id = p_batch_id;
1268: END IF;
1269:

Line 1376: UPDATE hz_imp_batch_summary

1372:
1373: END IF;
1374:
1375: IF l_dl_sub_request = 0 THEN
1376: UPDATE hz_imp_batch_summary
1377: SET main_conc_status = 'COMPLETED',
1378: batch_status = 'ACTION_REQUIRED'
1379: WHERE batch_id = p_batch_id;
1380: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Error submitting data load');

Line 1390: UPDATE hz_imp_batch_summary

1386: get_current_run(
1387: p_batch_id => p_batch_id,
1388: x_run_number => l_current_run);
1389:
1390: UPDATE hz_imp_batch_summary
1391: SET import_req_id = l_dl_sub_request
1392: WHERE batch_id = p_batch_id;
1393:
1394: END IF;

Line 1432: FROM hz_imp_batch_summary

1428:
1429: /*
1430: SELECT registry_dedup_flag
1431: INTO l_reg_dedup
1432: FROM hz_imp_batch_summary
1433: WHERE batch_id = p_batch_id;
1434: */
1435: IF NVL(r_batch_info.registry_dedup_flag,'N') = 'Y' THEN
1436:

Line 1565: UPDATE hz_imp_batch_summary

1561:
1562: IF l_req_data IS NULL THEN
1563:
1564: -- set the data load status to pending
1565: UPDATE hz_imp_batch_summary
1566: SET import_status = 'PENDING',
1567: main_conc_status = 'PROCESSING',
1568: main_conc_req_id = fnd_global.conc_request_id
1569: WHERE batch_id = p_batch_id;

Line 1746: UPDATE hz_imp_batch_summary

1742:
1743: END IF; -- IF r_batch_info.load_type = 'CSV'
1744:
1745: IF l_dl_sub_request = 0 THEN
1746: UPDATE hz_imp_batch_summary
1747: SET main_conc_status = 'COMPLETED',
1748: batch_status = 'ACTION_REQUIRED'
1749: WHERE batch_id = p_batch_id;
1750: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Error submitting data load');

Line 1760: UPDATE hz_imp_batch_summary

1756: get_current_run(
1757: p_batch_id => p_batch_id,
1758: x_run_number => l_current_run);
1759:
1760: UPDATE hz_imp_batch_summary
1761: SET import_req_id = l_dl_sub_request
1762: WHERE batch_id = p_batch_id;
1763:
1764: END IF;

Line 1799: FROM hz_imp_batch_summary

1795:
1796: /*
1797: SELECT registry_dedup_flag
1798: INTO l_reg_dedup
1799: FROM hz_imp_batch_summary
1800: WHERE batch_id = p_batch_id;
1801: */
1802: IF NVL(r_batch_info.registry_dedup_flag,'N') = 'Y' THEN
1803:

Line 1914: UPDATE hz_imp_batch_summary

1910: delete hz_imp_work_units where batch_id = P_BATCH_ID;
1911: END IF;
1912:
1913: -- set the data load status to COMPLETED
1914: UPDATE hz_imp_batch_summary
1915: SET main_conc_status = 'COMPLETED',
1916: batch_status = decode(r_batch_info.import_status,'COMPLETED','COMPLETED','ACTION_REQUIRED')
1917: WHERE batch_id = p_batch_id;
1918: