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.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 887: UPDATE hz_imp_batch_summary

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

Line 914: UPDATE hz_imp_batch_summary

910: THEN
911:
912: 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.');
913:
914: UPDATE hz_imp_batch_summary
915: SET main_conc_status = 'ERROR',
916: batch_status = 'ACTION_REQUIRED'
917: WHERE batch_id = p_batch_id;
918:

Line 925: UPDATE HZ_IMP_BATCH_SUMMARY

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

Line 938: UPDATE hz_imp_batch_summary

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

Line 1074: UPDATE hz_imp_batch_summary

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

Line 1082: UPDATE hz_imp_batch_summary

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

Line 1189: UPDATE hz_imp_batch_summary

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

Line 1198: UPDATE hz_imp_batch_summary

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

Line 1258: UPDATE hz_imp_batch_summary

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

Line 1267: UPDATE hz_imp_batch_summary

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

Line 1378: UPDATE hz_imp_batch_summary

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

Line 1392: UPDATE hz_imp_batch_summary

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

Line 1434: FROM hz_imp_batch_summary

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

Line 1569: UPDATE hz_imp_batch_summary

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

Line 1750: UPDATE hz_imp_batch_summary

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

Line 1764: UPDATE hz_imp_batch_summary

1760: get_current_run(
1761: p_batch_id => p_batch_id,
1762: x_run_number => l_current_run);
1763:
1764: UPDATE hz_imp_batch_summary
1765: SET import_req_id = l_dl_sub_request
1766: WHERE batch_id = p_batch_id;
1767:
1768: END IF;

Line 1803: FROM hz_imp_batch_summary

1799:
1800: /*
1801: SELECT registry_dedup_flag
1802: INTO l_reg_dedup
1803: FROM hz_imp_batch_summary
1804: WHERE batch_id = p_batch_id;
1805: */
1806: IF NVL(r_batch_info.registry_dedup_flag,'N') = 'Y' THEN
1807:

Line 1920: UPDATE hz_imp_batch_summary

1916: delete hz_imp_work_units where batch_id = P_BATCH_ID;
1917: END IF;
1918:
1919: -- set the data load status to COMPLETED
1920: UPDATE hz_imp_batch_summary
1921: SET main_conc_status = 'COMPLETED',
1922: batch_status = decode(r_batch_info.import_status,'COMPLETED','COMPLETED','ACTION_REQUIRED')
1923: WHERE batch_id = p_batch_id;
1924: