APPS.HZ_IMP_ADDRESS_VAL_PKG dependencies on HZ_IMP_BATCH_SUMMARY

Line 322: update HZ_IMP_BATCH_SUMMARY set ADDR_VAL_STATUS = 'ERROR'

318: retcode := 2;
319: FND_FILE.PUT_LINE(FND_FILE.LOG,TO_CHAR( l_sub_request_id ) ||
320: ' : ' || l_phase || ':' || l_status ||
321: ' (' || l_message || ').' );
322: update HZ_IMP_BATCH_SUMMARY set ADDR_VAL_STATUS = 'ERROR'
323: where batch_id = l_batch_id;
324: RETURN;
325: END IF;
326: else

Line 377: update HZ_IMP_BATCH_SUMMARY set ADDR_VAL_STATUS = 'COMPLETED'

373: end if;
374: end loop;
375: end if;
376: --Bug No: 3546295
377: update HZ_IMP_BATCH_SUMMARY set ADDR_VAL_STATUS = 'COMPLETED'
378: where batch_id = l_batch_id;
379: --End of 3546295--------
380: -------------------------------------
381: ELSE

Line 431: update HZ_IMP_BATCH_SUMMARY set ADDR_VAL_STATUS = 'PROCESSING'

427: END IF;
428: CLOSE adapter_cur;
429: END IF;
430: --Set the address validation status of batch summary table before submit the chaild CP
431: update HZ_IMP_BATCH_SUMMARY set ADDR_VAL_STATUS = 'PROCESSING'
432: where batch_id = l_batch_id returning ORIGINAL_SYSTEM into l_orig_system;
433: IF l_adapter_id.COUNT >0 THEN --Bug no:3365035.To overcome numeric or value error
434: l_adapter_found := TRUE; --Bug No: 3535366
435: FOR i in l_adapter_id.first..l_adapter_id.last LOOP /*start of Adaptor loop */

Line 477: update HZ_IMP_BATCH_SUMMARY set ADDR_VAL_STATUS = 'ERROR'

473: l_counter, null,'HZ_IMPORT',l_batch_id,
474: l_default_replace_level(i),l_orig_system,l_adapter_id(i));
475: IF l_request_id = 0 THEN
476: --Error submitting request
477: update HZ_IMP_BATCH_SUMMARY set ADDR_VAL_STATUS = 'ERROR'
478: where batch_id = l_batch_id;
479: retcode :=2;
480: fnd_file.put_line(FND_FILE.LOG, 'Error submitting address_validation_child');
481: return;

Line 521: update HZ_IMP_BATCH_SUMMARY set ADDR_VAL_STATUS = 'ERROR'

517: IF l_adapter_id.count = 0 AND l_adapter_last_fetch THEN
518: FND_FILE.put_line(fnd_file.log,'No Valid Default Adapter found');
519: -----Bug No: 3535366----
520: IF NOT l_adapter_found THEN
521: update HZ_IMP_BATCH_SUMMARY set ADDR_VAL_STATUS = 'ERROR'
522: where batch_id = l_batch_id
523: returning ORIGINAL_SYSTEM into l_orig_system;
524: retcode := 2;
525: FND_FILE.put_line(fnd_file.log,'Error: No adapters found to process the records, Aborting Address Validation Main for this batch');

Line 561: UPDATE HZ_IMP_BATCH_SUMMARY set ADDR_VAL_STATUS = 'ERROR'

557: l_counter, null,'HZ_IMPORT',l_batch_id,
558: l_default_replace_level(i),l_orig_system,l_adapter_id(i));
559: IF l_request_id = 0 THEN
560: --Error submitting request
561: UPDATE HZ_IMP_BATCH_SUMMARY set ADDR_VAL_STATUS = 'ERROR'
562: WHERE batch_id = l_batch_id;
563: retcode :=2;
564: fnd_file.put_line(FND_FILE.LOG, 'Error submitting address_validation_child for Default Adapter');
565: