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 FND_FILE

Line 209: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** POST - Calling dqm_post_imp_cleanup');

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
209: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** POST - Calling dqm_post_imp_cleanup');
210: HZ_IMP_DQM_STAGE.dqm_post_imp_cleanup
211: (p_batch_id => p_batch_id,
212: x_return_status => x_return_status,
213: x_msg_count => x_msg_count,

Line 332: fnd_file.put_line(FND_FILE.LOG, 'l_what_if_sg_data_exists = ' || l_what_if_sg_data_exists);

328: OPEN c_what_if_sg_data(P_BATCH_ID, P_BATCH_MODE_FLAG);
329: FETCH c_what_if_sg_data INTO l_what_if_sg_data_exists;
330: CLOSE c_what_if_sg_data;
331:
332: fnd_file.put_line(FND_FILE.LOG, 'l_what_if_sg_data_exists = ' || l_what_if_sg_data_exists);
333: RETURN NVL(l_what_if_sg_data_exists, 'N');
334: END STAGING_DATA_EXISTS;
335:
336: /* Clean up staging. Delete for online, truncate for batch */

Line 362: fnd_file.put_line(FND_FILE.LOG, ' l_schema = ' || l_schema);

358: l_bool := fnd_installation.GET_APP_INFO('AR',l_status,l_tmp,l_schema);
359:
360: IF P_BATCH_MODE_FLAG = 'Y' THEN
361:
362: fnd_file.put_line(FND_FILE.LOG, ' l_schema = ' || l_schema);
363:
364: execute immediate 'ALTER TABLE ' || l_schema || '.HZ_IMP_PARTIES_SG TRUNCATE PARTITION batchpar DROP STORAGE';
365: execute immediate 'ALTER TABLE ' || l_schema || '.HZ_IMP_ADDRESSES_SG TRUNCATE PARTITION batchpar DROP STORAGE';
366: execute immediate 'ALTER TABLE ' || l_schema || '.HZ_IMP_CONTACTPTS_SG TRUNCATE PARTITION batchpar DROP STORAGE';

Line 548: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** FATAL ERROR: The feature is only available for Oracle 9iR2 or higher');

544: INTO l_ver
545: FROM v$instance;
546:
547: IF l_ver < 920 THEN
548: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** FATAL ERROR: The feature is only available for Oracle 9iR2 or higher');
549: RETURN;
550: END IF;
551:
552: l_req_data := fnd_conc_global.request_data;

Line 622: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Batch de-duplication program errored...exiting');

618: batch_status = 'ACTION_REQUIRED',
619: main_conc_status = 'COMPLETED'
620: WHERE batch_id = p_batch_id;
621:
622: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Batch de-duplication program errored...exiting');
623: retcode := 1;
624: errbuf := 'WARNING**** Unexpected error occured Batch de-duplication program.';
625: RETURN;
626: END IF;

Line 641: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Address validation program errored...exiting');

637: batch_status = 'ACTION_REQUIRED',
638: main_conc_status = 'COMPLETED'
639: WHERE batch_id = p_batch_id;
640:
641: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Address validation program errored...exiting');
642: retcode := 1;
643: errbuf := 'WARNING****** Unexpected error occured Address validation program.';
644: RETURN;
645: END IF;

Line 672: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Data load program errored...exiting');

668: SET import_status = 'ERROR'
669: WHERE batch_id = p_batch_id
670: AND run_number = l_current_run;
671:
672: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Data load program errored...exiting');
673: -- since the data load might have run partially, there is a need to perform the
674: -- post-processing here
675: -- final steps on import
676: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Performing the post processes');

Line 676: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Performing the post processes');

672: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Data load program errored...exiting');
673: -- since the data load might have run partially, there is a need to perform the
674: -- post-processing here
675: -- final steps on import
676: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Performing the post processes');
677:
678: IF p_import_run_option = 'COMPLETE' OR p_import_run_option = 'CONTINUE' THEN
679:
680: -- retrieve number of workers

Line 692: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Calling DQM post import cleanup');

688: END IF;
689:
690: -- call the DQM cleanup routine
691: IF r_batch_info.registry_dedup_flag = 'Y' OR r_batch_info.batch_dedup_flag = 'Y' THEN
692: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Calling DQM post import cleanup');
693: HZ_IMP_DQM_STAGE.dqm_post_imp_cleanup
694: (p_batch_id => p_batch_id,
695: x_return_status => l_return_status,
696: x_msg_count => l_msg_count,

Line 705: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Calling DQM interface tca sanitize report');

701: THEN
702: IF NVL(r_batch_info.registry_dedup_flag,'N') = 'Y' THEN
703:
704: -- call the report dupsets API
705: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Calling DQM interface tca sanitize report');
706: HZ_DQM_DUP_ID_PKG.interface_tca_sanitize_report
707: (p_batch_id => p_batch_id,
708: p_match_rule_id => p_registry_dedup_rule_id,
709: p_request_id => fnd_global.conc_request_id,

Line 730: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Invoking auto merge post process');

726: ------------------------------------------
727: -- if automerge flag, kick off the process
728: ------------------------------------------
729: IF p_run_automerge = 'Y' THEN
730: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Invoking auto merge post process');
731: l_am_sub_request := FND_REQUEST.SUBMIT_REQUEST(
732: 'AR',
733: 'ARHAMRGP',
734: '',

Line 742: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Error submitting auto merge post process');

738: to_char(l_num_of_workers)
739: );
740:
741: IF l_am_sub_request = 0 THEN
742: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Error submitting auto merge post process');
743: ELSE
744: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Submitted request for auto merge post process');
745: END IF;
746:

Line 744: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Submitted request for auto merge post process');

740:
741: IF l_am_sub_request = 0 THEN
742: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Error submitting auto merge post process');
743: ELSE
744: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Submitted request for auto merge post process');
745: END IF;
746:
747: END IF; --nvl(l_automerge_flag,'N') = 'Y'
748:

Line 753: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Calling Parallel Sync Index concurrent program');

749: END IF; --NVL(l_reg_dedup,'N') = 'Y'
750:
751: IF (Nvl(FND_PROFILE.VALUE('HZ_DQM_ENABLE_REALTIME_SYNC'),'Y') <> 'DISABLE') THEN --Bug 10435345
752: -- Bug 4594407 : Call DQM Sync Index
753: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Calling Parallel Sync Index concurrent program');
754: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Request Id of the program to be waited on, that is being passed to this : ' || fnd_global.conc_request_id );
755: l_index_conc_program_req_id := FND_REQUEST.SUBMIT_REQUEST('AR',
756: 'ARHDQMPP',
757: 'DQM Parallel Sync Index Parent Program',

Line 754: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Request Id of the program to be waited on, that is being passed to this : ' || fnd_global.conc_request_id );

750:
751: IF (Nvl(FND_PROFILE.VALUE('HZ_DQM_ENABLE_REALTIME_SYNC'),'Y') <> 'DISABLE') THEN --Bug 10435345
752: -- Bug 4594407 : Call DQM Sync Index
753: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Calling Parallel Sync Index concurrent program');
754: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Request Id of the program to be waited on, that is being passed to this : ' || fnd_global.conc_request_id );
755: l_index_conc_program_req_id := FND_REQUEST.SUBMIT_REQUEST('AR',
756: 'ARHDQMPP',
757: 'DQM Parallel Sync Index Parent Program',
758: NULL,

Line 763: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Error submitting DQM Sync Index Program.');

759: FALSE,
760: fnd_global.conc_request_id
761: );
762: IF l_index_conc_program_req_id = 0 THEN
763: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Error submitting DQM Sync Index Program.');
764: ELSE
765: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Request Id of Parallel Sync concurrent Program is : ' || l_index_conc_program_req_id );
766: END IF;
767: END IF;

Line 765: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Request Id of Parallel Sync concurrent Program is : ' || l_index_conc_program_req_id );

761: );
762: IF l_index_conc_program_req_id = 0 THEN
763: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Error submitting DQM Sync Index Program.');
764: ELSE
765: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Request Id of Parallel Sync concurrent Program is : ' || l_index_conc_program_req_id );
766: END IF;
767: END IF;
768:
769: -- call dataload post processing

Line 770: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Invoking data load post process');

766: END IF;
767: END IF;
768:
769: -- call dataload post processing
770: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Invoking data load post process');
771: FOR i IN 1..l_num_of_workers LOOP
772: l_pp_sub_request := FND_REQUEST.SUBMIT_REQUEST(
773: 'AR',
774: 'ARHLPPLB',

Line 786: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Error submitting data load post processing ' || l_num_of_workers);

782: p_generate_fuzzy_key
783: );
784:
785: IF l_pp_sub_request = 0 THEN
786: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Error submitting data load post processing ' || l_num_of_workers);
787: ELSE
788: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Submitted request for data load post processing ' || l_num_of_workers);
789: END IF;
790: END LOOP;

Line 788: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Submitted request for data load post processing ' || l_num_of_workers);

784:
785: IF l_pp_sub_request = 0 THEN
786: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Error submitting data load post processing ' || l_num_of_workers);
787: ELSE
788: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Submitted request for data load post processing ' || l_num_of_workers);
789: END IF;
790: END LOOP;
791:
792: -- wait for the conc program to finish

Line 824: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** '||FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE));

820:
821: END IF; -- p_import_run_option = 'COMPLETE'/'WHAT_IF'
822:
823: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
824: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** '||FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE));
825: RETURN;
826: END IF;
827:
828: RETURN;

Line 839: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Parameters passed');

835: IF l_req_data IS NULL THEN
836: ------------------------------
837: -- print the parameters passed
838: ------------------------------
839: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Parameters passed');
840: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** -----------------');
841: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Batch ID: '||p_batch_id);
842: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Import Run Option: '||p_import_run_option);
843: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Run Batch Dedup?: '||p_run_batch_dedup);

Line 840: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** -----------------');

836: ------------------------------
837: -- print the parameters passed
838: ------------------------------
839: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Parameters passed');
840: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** -----------------');
841: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Batch ID: '||p_batch_id);
842: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Import Run Option: '||p_import_run_option);
843: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Run Batch Dedup?: '||p_run_batch_dedup);
844: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Batch dedup rule id: '||p_batch_dedup_rule_id);

Line 841: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Batch ID: '||p_batch_id);

837: -- print the parameters passed
838: ------------------------------
839: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Parameters passed');
840: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** -----------------');
841: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Batch ID: '||p_batch_id);
842: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Import Run Option: '||p_import_run_option);
843: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Run Batch Dedup?: '||p_run_batch_dedup);
844: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Batch dedup rule id: '||p_batch_dedup_rule_id);
845: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Batch dedup action: '||p_batch_dedup_action);

Line 842: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Import Run Option: '||p_import_run_option);

838: ------------------------------
839: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Parameters passed');
840: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** -----------------');
841: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Batch ID: '||p_batch_id);
842: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Import Run Option: '||p_import_run_option);
843: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Run Batch Dedup?: '||p_run_batch_dedup);
844: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Batch dedup rule id: '||p_batch_dedup_rule_id);
845: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Batch dedup action: '||p_batch_dedup_action);
846: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Run addr val?: '||p_run_addr_val);

Line 843: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Run Batch Dedup?: '||p_run_batch_dedup);

839: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Parameters passed');
840: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** -----------------');
841: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Batch ID: '||p_batch_id);
842: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Import Run Option: '||p_import_run_option);
843: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Run Batch Dedup?: '||p_run_batch_dedup);
844: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Batch dedup rule id: '||p_batch_dedup_rule_id);
845: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Batch dedup action: '||p_batch_dedup_action);
846: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Run addr val?: '||p_run_addr_val);
847: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Run registry dedup?: '||p_run_registry_dedup);

Line 844: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Batch dedup rule id: '||p_batch_dedup_rule_id);

840: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** -----------------');
841: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Batch ID: '||p_batch_id);
842: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Import Run Option: '||p_import_run_option);
843: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Run Batch Dedup?: '||p_run_batch_dedup);
844: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Batch dedup rule id: '||p_batch_dedup_rule_id);
845: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Batch dedup action: '||p_batch_dedup_action);
846: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Run addr val?: '||p_run_addr_val);
847: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Run registry dedup?: '||p_run_registry_dedup);
848: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Registry dedup rule id?: '||p_registry_dedup_rule_id);

Line 845: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Batch dedup action: '||p_batch_dedup_action);

841: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Batch ID: '||p_batch_id);
842: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Import Run Option: '||p_import_run_option);
843: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Run Batch Dedup?: '||p_run_batch_dedup);
844: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Batch dedup rule id: '||p_batch_dedup_rule_id);
845: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Batch dedup action: '||p_batch_dedup_action);
846: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Run addr val?: '||p_run_addr_val);
847: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Run registry dedup?: '||p_run_registry_dedup);
848: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Registry dedup rule id?: '||p_registry_dedup_rule_id);
849: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Run Automerge?: '||p_run_automerge);

Line 846: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Run addr val?: '||p_run_addr_val);

842: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Import Run Option: '||p_import_run_option);
843: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Run Batch Dedup?: '||p_run_batch_dedup);
844: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Batch dedup rule id: '||p_batch_dedup_rule_id);
845: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Batch dedup action: '||p_batch_dedup_action);
846: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Run addr val?: '||p_run_addr_val);
847: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Run registry dedup?: '||p_run_registry_dedup);
848: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Registry dedup rule id?: '||p_registry_dedup_rule_id);
849: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Run Automerge?: '||p_run_automerge);
850: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** -----------------');

Line 847: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Run registry dedup?: '||p_run_registry_dedup);

843: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Run Batch Dedup?: '||p_run_batch_dedup);
844: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Batch dedup rule id: '||p_batch_dedup_rule_id);
845: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Batch dedup action: '||p_batch_dedup_action);
846: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Run addr val?: '||p_run_addr_val);
847: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Run registry dedup?: '||p_run_registry_dedup);
848: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Registry dedup rule id?: '||p_registry_dedup_rule_id);
849: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Run Automerge?: '||p_run_automerge);
850: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** -----------------');
851: FND_FILE.PUT_LINE (FND_FILE.LOG, '');

Line 848: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Registry dedup rule id?: '||p_registry_dedup_rule_id);

844: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Batch dedup rule id: '||p_batch_dedup_rule_id);
845: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Batch dedup action: '||p_batch_dedup_action);
846: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Run addr val?: '||p_run_addr_val);
847: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Run registry dedup?: '||p_run_registry_dedup);
848: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Registry dedup rule id?: '||p_registry_dedup_rule_id);
849: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Run Automerge?: '||p_run_automerge);
850: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** -----------------');
851: FND_FILE.PUT_LINE (FND_FILE.LOG, '');
852:

Line 849: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Run Automerge?: '||p_run_automerge);

845: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Batch dedup action: '||p_batch_dedup_action);
846: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Run addr val?: '||p_run_addr_val);
847: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Run registry dedup?: '||p_run_registry_dedup);
848: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Registry dedup rule id?: '||p_registry_dedup_rule_id);
849: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Run Automerge?: '||p_run_automerge);
850: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** -----------------');
851: FND_FILE.PUT_LINE (FND_FILE.LOG, '');
852:
853: ---------------------

Line 850: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** -----------------');

846: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Run addr val?: '||p_run_addr_val);
847: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Run registry dedup?: '||p_run_registry_dedup);
848: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Registry dedup rule id?: '||p_registry_dedup_rule_id);
849: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Run Automerge?: '||p_run_automerge);
850: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** -----------------');
851: FND_FILE.PUT_LINE (FND_FILE.LOG, '');
852:
853: ---------------------
854: -- validate the batch

Line 851: FND_FILE.PUT_LINE (FND_FILE.LOG, '');

847: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Run registry dedup?: '||p_run_registry_dedup);
848: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Registry dedup rule id?: '||p_registry_dedup_rule_id);
849: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Run Automerge?: '||p_run_automerge);
850: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** -----------------');
851: FND_FILE.PUT_LINE (FND_FILE.LOG, '');
852:
853: ---------------------
854: -- validate the batch
855: ---------------------

Line 857: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Validating the batch');

853: ---------------------
854: -- validate the batch
855: ---------------------
856:
857: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Validating the batch');
858:
859: -- Bug 4079902. Validated orig_system against HZ_ORIG_SYSTEMS_B instead of
860: -- the lookup.
861:

Line 885: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Error***** '||FND_MESSAGE.GET);

881: FND_MESSAGE.SET_TOKEN('COLUMN','orig_system');
882: FND_MESSAGE.SET_TOKEN('TABLE','HZ_ORIG_SYSTEMS_B');
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'

Line 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.');

908: IF l_automerge_flag is NULL
909: or l_automerge_flag='N'
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'

Line 937: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Pre-import has not been performed for this batch.');

933: IF p_import_run_option = 'CONTINUE' THEN
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;

Line 947: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** The batch has already been completed.');

943: END IF;
944:
945: -- validate that the batch is not already completed one
946: IF NVL(r_batch_info.import_status,'X') = 'COMPLETED' THEN
947: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** The batch has already been completed.');
948: RETURN;
949: END IF;
950:
951: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Completed validation');

Line 951: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Completed validation');

947: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** The batch has already been completed.');
948: RETURN;
949: END IF;
950:
951: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Completed validation');
952:
953: -- update batch summary table and create row in batch detail table
954: get_current_run(
955: p_batch_id => p_batch_id,

Line 992: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Created entry in batch details table');

988: HZ_UTILITY_V2PUB.last_update_date,
989: HZ_UTILITY_V2PUB.last_update_login,
990: fnd_global.conc_request_id);
991:
992: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Created entry in batch details table');
993:
994: END IF; -- l_last_run_imp_status <> 'PENDING'
995:
996: ELSE

Line 1022: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Created entry in batch details table');

1018: HZ_UTILITY_V2PUB.last_update_date,
1019: HZ_UTILITY_V2PUB.last_update_login,
1020: fnd_global.conc_request_id);
1021:
1022: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Created entry in batch details table');
1023:
1024: END IF;
1025:
1026: END IF; -- l_req_data IS NULL

Line 1065: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** FATAL ERROR: No match rule provided for batch dedup.');

1061: -- otherwise error out
1062: -- if no match rule has been provided, error out
1063: IF (p_run_batch_dedup = 'Y' and p_batch_dedup_rule_id IS NULL) THEN
1064: l_rule_id_missing := true;
1065: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** FATAL ERROR: No match rule provided for batch dedup.');
1066: END IF;
1067: IF (p_run_registry_dedup = 'Y' and p_registry_dedup_rule_id IS NULL) THEN
1068: l_rule_id_missing := true;
1069: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** FATAL ERROR: No match rule provided for registry dedup.');

Line 1069: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** FATAL ERROR: No match rule provided for registry dedup.');

1065: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** FATAL ERROR: No match rule provided for batch dedup.');
1066: END IF;
1067: IF (p_run_registry_dedup = 'Y' and p_registry_dedup_rule_id IS NULL) THEN
1068: l_rule_id_missing := true;
1069: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** FATAL ERROR: No match rule provided for registry dedup.');
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');

Line 1073: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Data Import cannot proceed, exit with error');

1069: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** FATAL ERROR: No match rule provided for registry dedup.');
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;

Line 1107: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Cleaning up batch de-duplication actions');

1103: -- cleanup the previous what-if results
1104: -- 1. call batch deduplication cleanup routine
1105: -- 2. call registry deduplication cleanup routine
1106: -- it is the same cleanup routine that does both the above.
1107: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Cleaning up batch de-duplication actions');
1108: HZ_BATCH_ACTION_PUB.clear_status(
1109: p_batch_id => p_batch_id,
1110: x_return_status => l_return_status);
1111:

Line 1113: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** '||FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE));

1109: p_batch_id => p_batch_id,
1110: x_return_status => l_return_status);
1111:
1112: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1113: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** '||FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE));
1114: RETURN;
1115: END IF;
1116:
1117: -- 3. cleanup address validation information

Line 1118: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Cleaning up address validation actions');

1114: RETURN;
1115: END IF;
1116:
1117: -- 3. cleanup address validation information
1118: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Cleaning up address validation actions');
1119: UPDATE hz_imp_addresses_int
1120: SET VALIDATION_SUBSET_ID = null,
1121: ACCEPT_STANDARDIZED_FLAG = null,
1122: ADAPTER_CONTENT_SOURCE = null,

Line 1137: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Calling DQM pre-import cleanup');

1133: POSTAL_CODE_STD = null
1134: WHERE batch_id = p_batch_id;
1135:
1136: -- 4. call dqm cleanup routine
1137: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Calling DQM pre-import cleanup');
1138: IF p_run_batch_dedup = 'Y' OR p_run_registry_dedup = 'Y' THEN
1139: HZ_IMP_DQM_STAGE.dqm_pre_imp_cleanup(
1140: p_batch_id => p_batch_id,
1141: x_return_status => l_return_status,

Line 1146: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** '||FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE));

1142: x_msg_count => l_msg_count,
1143: x_msg_data => l_msg_data);
1144:
1145: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1146: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** '||FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE));
1147: RETURN;
1148: END IF;
1149:
1150: END IF; -- p_run_batch_dedup = 'Y' OR p_run_registry_dedup = 'Y'

Line 1166: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Number of workers used : '||l_num_of_workers);

1162: l_num_of_workers := 1;
1163: END IF; --l_num_of_workers IS NULL
1164: END IF; --r_batch_info.load_type = 'CSV'
1165:
1166: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Number of workers used : '||l_num_of_workers);
1167:
1168: -- call the batch deduplication process if needed.
1169: IF NVL(p_run_batch_dedup,'N') = 'Y' AND l_req_data IS NULL THEN
1170: l_str := 'begin HZ_IMP_LOAD_WRAPPER.DATA_LOAD_PREPROCESSING(:1,:2,:3,:4); end;';

Line 1174: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Called data load wrapper to generate work units');

1170: l_str := 'begin HZ_IMP_LOAD_WRAPPER.DATA_LOAD_PREPROCESSING(:1,:2,:3,:4); end;';
1171: execute immediate l_str using p_batch_id, r_batch_info.original_system, l_what_if, OUT l_dataload_rerun;
1172: l_work_unit := 'Y';
1173:
1174: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Called data load wrapper to generate work units');
1175:
1176: -- submit batch dedup program
1177: l_bd_sub_request := FND_REQUEST.SUBMIT_REQUEST(
1178: 'AR',

Line 1193: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Error submitting batch de-duplication');

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');
1194: RETURN;
1195: ELSE
1196: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Submitted request for batch de-dupication');
1197:

Line 1196: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Submitted request for batch de-dupication');

1192: WHERE batch_id = p_batch_id;
1193: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Error submitting batch de-duplication');
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;

Line 1241: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** '||FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE));

1237: x_msg_count => l_msg_count
1238: );
1239:
1240: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1241: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** '||FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE));
1242: RETURN;
1243: END IF;
1244: END IF; /***p_import_run_option = 'COMPLETE' AND p_run_batch_dedup = 'Y' ***/
1245:

Line 1262: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Error submitting address validation');

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');
1263: RETURN;
1264: ELSE
1265: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Submitted request for addrress validation');
1266:

Line 1265: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Submitted request for addrress validation');

1261: WHERE batch_id = p_batch_id;
1262: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Error submitting address validation');
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;

Line 1297: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Calling DQM intermediate cleanup');

1293: END IF;
1294:
1295: -- DQM cleanup for staging reuse
1296: IF r_batch_info.registry_dedup_flag = 'Y' THEN
1297: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Calling DQM intermediate cleanup');
1298: HZ_IMP_DQM_STAGE.dqm_inter_imp_cleanup(
1299: p_batch_id => p_batch_id,
1300: x_return_status => l_return_status,
1301: x_msg_count => l_msg_count,

Line 1305: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** '||FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE));

1301: x_msg_count => l_msg_count,
1302: x_msg_data => l_msg_data);
1303:
1304: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1305: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** '||FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE));
1306: RETURN;
1307: END IF;
1308: END IF;
1309:

Line 1311: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Calling data load preprocessing for work unit calculation');

1307: END IF;
1308: END IF;
1309:
1310: IF l_work_unit <> 'Y' THEN
1311: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Calling data load preprocessing for work unit calculation');
1312: l_str := 'begin HZ_IMP_LOAD_WRAPPER.DATA_LOAD_PREPROCESSING(:1,:2,:3,:4); end;';
1313: execute immediate l_str using p_batch_id, r_batch_info.original_system, l_what_if, OUT l_dataload_rerun;
1314: END IF;
1315:

Line 1318: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Calling ARHLWRPO - Online Data Load');

1314: END IF;
1315:
1316: -- submit data load program
1317: IF r_batch_info.load_type = 'CSV' THEN
1318: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Calling ARHLWRPO - Online Data Load');
1319: l_dl_sub_request := FND_REQUEST.SUBMIT_REQUEST(
1320: 'AR',
1321: 'ARHLWRPO',
1322: '',

Line 1352: FND_FILE.PUT_LINE(FND_FILE.LOG, 'UIC***** Calculated number of workers : '||l_num_of_workers);

1348: l_num_of_workers := 1;
1349: END IF;
1350: --END IF;
1351:
1352: FND_FILE.PUT_LINE(FND_FILE.LOG, 'UIC***** Calculated number of workers : '||l_num_of_workers);
1353: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Calling ARHLWRPB - Batch Data Load');
1354:
1355: l_dl_sub_request := FND_REQUEST.SUBMIT_REQUEST(
1356: 'AR',

Line 1353: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Calling ARHLWRPB - Batch Data Load');

1349: END IF;
1350: --END IF;
1351:
1352: FND_FILE.PUT_LINE(FND_FILE.LOG, 'UIC***** Calculated number of workers : '||l_num_of_workers);
1353: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Calling ARHLWRPB - Batch Data Load');
1354:
1355: l_dl_sub_request := FND_REQUEST.SUBMIT_REQUEST(
1356: 'AR',
1357: 'ARHLWRPB',

Line 1382: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Error submitting data load');

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');
1383: RETURN;
1384: ELSE
1385: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Submitted request for data load');
1386:

Line 1385: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Submitted request for data load');

1381: WHERE batch_id = p_batch_id;
1382: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Error submitting data load');
1383: RETURN;
1384: ELSE
1385: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Submitted request for data load');
1386:
1387: -- update batch summary table and create row in batch detail table
1388: get_current_run(
1389: p_batch_id => p_batch_id,

Line 1407: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Performing the post processes');

1403: END IF; -- p_run_addr_val = 'Y' AND l_req_data = 'BACTH_DEDUP'
1404:
1405: IF l_req_data = 'DATA_LOAD' THEN
1406: -- final steps on import
1407: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Performing the post processes');
1408:
1409: IF p_import_run_option = 'COMPLETE' THEN
1410:
1411: -- generate number of workers

Line 1423: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Calling DQM post import cleanup');

1419: END IF;
1420:
1421: -- call the DQM cleanup routine
1422: IF r_batch_info.registry_dedup_flag = 'Y' OR r_batch_info.batch_dedup_flag = 'Y' THEN
1423: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Calling DQM post import cleanup');
1424: HZ_IMP_DQM_STAGE.dqm_post_imp_cleanup
1425: (p_batch_id => p_batch_id,
1426: x_return_status => l_return_status,
1427: x_msg_count => l_msg_count,

Line 1440: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Calling DQM interface tca sanitize report');

1436: */
1437: IF NVL(r_batch_info.registry_dedup_flag,'N') = 'Y' THEN
1438:
1439: -- call the report dupsets API
1440: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Calling DQM interface tca sanitize report');
1441: HZ_DQM_DUP_ID_PKG.interface_tca_sanitize_report
1442: (p_batch_id => p_batch_id,
1443: p_match_rule_id => p_registry_dedup_rule_id,
1444: p_request_id => fnd_global.conc_request_id,

Line 1460: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Invoking auto merge post process');

1456: WHERE batch_id = p_batch_id
1457: AND run_number = l_current_run;
1458:
1459: IF p_run_automerge = 'Y' THEN
1460: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Invoking auto merge post process');
1461: l_am_sub_request := FND_REQUEST.SUBMIT_REQUEST(
1462: 'AR',
1463: 'ARHAMRGP',
1464: '',

Line 1472: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Error submitting auto merge post process');

1468: to_char(l_num_of_workers)
1469: );
1470:
1471: IF l_am_sub_request = 0 THEN
1472: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Error submitting auto merge post process');
1473: ELSE
1474: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Submitted request for auto merge post process');
1475: END IF;
1476:

Line 1474: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Submitted request for auto merge post process');

1470:
1471: IF l_am_sub_request = 0 THEN
1472: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Error submitting auto merge post process');
1473: ELSE
1474: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Submitted request for auto merge post process');
1475: END IF;
1476:
1477: END IF;
1478: END IF; --NVL(r_batch_info.registry_dedup_flag,'N') = 'Y'

Line 1482: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Calling Parallel Sync Index concurrent program');

1478: END IF; --NVL(r_batch_info.registry_dedup_flag,'N') = 'Y'
1479:
1480: IF (Nvl(FND_PROFILE.VALUE('HZ_DQM_ENABLE_REALTIME_SYNC'),'Y') <> 'DISABLE') THEN --Bug 10435345
1481: -- Bug 4594407 : Call DQM Sync Index
1482: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Calling Parallel Sync Index concurrent program');
1483: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Request Id of the program to be waited on, that is being passed to this : ' || fnd_global.conc_request_id );
1484: l_index_conc_program_req_id := FND_REQUEST.SUBMIT_REQUEST('AR',
1485: 'ARHDQMPP',
1486: 'DQM Parallel Sync Index Parent Program',

Line 1483: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Request Id of the program to be waited on, that is being passed to this : ' || fnd_global.conc_request_id );

1479:
1480: IF (Nvl(FND_PROFILE.VALUE('HZ_DQM_ENABLE_REALTIME_SYNC'),'Y') <> 'DISABLE') THEN --Bug 10435345
1481: -- Bug 4594407 : Call DQM Sync Index
1482: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Calling Parallel Sync Index concurrent program');
1483: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Request Id of the program to be waited on, that is being passed to this : ' || fnd_global.conc_request_id );
1484: l_index_conc_program_req_id := FND_REQUEST.SUBMIT_REQUEST('AR',
1485: 'ARHDQMPP',
1486: 'DQM Parallel Sync Index Parent Program',
1487: NULL,

Line 1492: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Error submitting DQM Sync Index Program.');

1488: FALSE,
1489: fnd_global.conc_request_id
1490: );
1491: IF l_index_conc_program_req_id = 0 THEN
1492: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Error submitting DQM Sync Index Program.');
1493: ELSE
1494: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Request Id of Parallel Sync concurrent Program is : ' || l_index_conc_program_req_id );
1495: END IF;
1496: END IF;

Line 1494: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Request Id of Parallel Sync concurrent Program is : ' || l_index_conc_program_req_id );

1490: );
1491: IF l_index_conc_program_req_id = 0 THEN
1492: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Error submitting DQM Sync Index Program.');
1493: ELSE
1494: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Request Id of Parallel Sync concurrent Program is : ' || l_index_conc_program_req_id );
1495: END IF;
1496: END IF;
1497:
1498: -- call dataload post processing

Line 1499: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Invoking data load post process');

1495: END IF;
1496: END IF;
1497:
1498: -- call dataload post processing
1499: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Invoking data load post process');
1500: FOR i IN 1..l_num_of_workers LOOP
1501:
1502: l_pp_sub_request := FND_REQUEST.SUBMIT_REQUEST(
1503: 'AR',

Line 1516: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Error submitting data load post processing ' || l_num_of_workers);

1512: p_generate_fuzzy_key
1513: );
1514:
1515: IF l_pp_sub_request = 0 THEN
1516: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Error submitting data load post processing ' || l_num_of_workers);
1517: ELSE
1518: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Submitted request for data load post processing ' || l_num_of_workers);
1519: END IF;
1520: END LOOP;

Line 1518: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Submitted request for data load post processing ' || l_num_of_workers);

1514:
1515: IF l_pp_sub_request = 0 THEN
1516: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Error submitting data load post processing ' || l_num_of_workers);
1517: ELSE
1518: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Submitted request for data load post processing ' || l_num_of_workers);
1519: END IF;
1520: END LOOP;
1521:
1522: -- wait for the conc program to finish

Line 1543: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** '||FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE));

1539:
1540: END IF; -- p_import_run_option = 'COMPLETE'/'WHAT_IF'
1541:
1542: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1543: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** '||FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE));
1544: RETURN;
1545: END IF;
1546:
1547: END IF; --l_req_data = 'DATA_LOAD'

Line 1586: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Calling the batch de-duplication actions API');

1582:
1583: -- call batch dedup actions api with the r_batch_info.bd_action_on* parameters
1584: IF r_batch_info.import_status = 'ACTION_REQUIRED' THEN
1585:
1586: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Calling the batch de-duplication actions API');
1587: HZ_BATCH_ACTION_PUB.batch_dedup_action(
1588: p_batch_id => p_batch_id,
1589: p_action_on_parties => nvl(p_batch_dedup_action, r_batch_info.bd_action_on_parties),
1590: p_action_on_addresses => nvl(p_batch_dedup_action, r_batch_info.bd_action_on_addresses),

Line 1601: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** '||FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE));

1597:
1598: END IF; -- r_batch_info.import_status = 'ACTION_REQUIRED'
1599:
1600: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1601: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** '||FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE));
1602: RETURN;
1603: END IF;
1604:
1605: END IF; -- r_batch_info.batch_dedup_flag = 'Y'

Line 1647: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Calling the registry de-duplication actions API');

1643: r_batch_info.rd_action_new_finents IS NOT NULL
1644: OR
1645: r_batch_info.rd_action_existing_finents IS NOT NULL
1646: THEN
1647: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Calling the registry de-duplication actions API');
1648: HZ_BATCH_ACTION_PUB.registry_dedup_action(
1649: p_batch_id => p_batch_id,
1650: p_action_new_parties => r_batch_info.rd_action_new_parties,
1651: p_action_existing_parties => r_batch_info.rd_action_existing_parties,

Line 1674: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** '||FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE));

1670: );
1671: END IF;
1672:
1673: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1674: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** '||FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE));
1675: RETURN;
1676: END IF;
1677:
1678: END IF; -- r_batch_info.registry_dedup_flag = 'Y'

Line 1687: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Called data load wrapper to generate work units');

1683: -- call create work unit api (if not already called) and then call data load
1684: l_str := 'begin HZ_IMP_LOAD_WRAPPER.DATA_LOAD_PREPROCESSING(:1,:2,:3,:4); end;';
1685: execute immediate l_str using p_batch_id, r_batch_info.original_system, l_what_if, OUT l_dataload_rerun;
1686:
1687: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Called data load wrapper to generate work units');
1688:
1689: IF r_batch_info.load_type = 'CSV' THEN
1690:
1691: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Calling ARHLWRPO - Online Data Load');

Line 1691: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Calling ARHLWRPO - Online Data Load');

1687: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Called data load wrapper to generate work units');
1688:
1689: IF r_batch_info.load_type = 'CSV' THEN
1690:
1691: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Calling ARHLWRPO - Online Data Load');
1692:
1693: l_dl_sub_request := FND_REQUEST.SUBMIT_REQUEST(
1694: 'AR',
1695: 'ARHLWRPO',

Line 1724: FND_FILE.PUT_LINE(FND_FILE.LOG, 'UIC***** Calculated number of workers : '||l_num_of_workers);

1720: l_num_of_workers := 1;
1721: END IF;
1722: END IF;
1723:
1724: FND_FILE.PUT_LINE(FND_FILE.LOG, 'UIC***** Calculated number of workers : '||l_num_of_workers);
1725: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Calling ARHLWRPB - Batch Data Load');
1726:
1727: l_dl_sub_request := FND_REQUEST.SUBMIT_REQUEST(
1728: 'AR',

Line 1725: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Calling ARHLWRPB - Batch Data Load');

1721: END IF;
1722: END IF;
1723:
1724: FND_FILE.PUT_LINE(FND_FILE.LOG, 'UIC***** Calculated number of workers : '||l_num_of_workers);
1725: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Calling ARHLWRPB - Batch Data Load');
1726:
1727: l_dl_sub_request := FND_REQUEST.SUBMIT_REQUEST(
1728: 'AR',
1729: 'ARHLWRPB',

Line 1754: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Error submitting data load');

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');
1755: RETURN;
1756: ELSE
1757: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Submitted request for data load');
1758:

Line 1757: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Submitted request for data load');

1753: WHERE batch_id = p_batch_id;
1754: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Error submitting data load');
1755: RETURN;
1756: ELSE
1757: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Submitted request for data load');
1758:
1759: -- update batch summary table and create row in batch detail table
1760: get_current_run(
1761: p_batch_id => p_batch_id,

Line 1779: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Performing the post processes');

1775: END IF; -- l_req_data IS NULL
1776:
1777: IF l_req_data = 'DATA_LOAD' THEN
1778: -- final steps on import
1779: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Performing the post processes');
1780:
1781: -- generate number of workers
1782: IF r_batch_info.load_type = 'CSV' THEN
1783: l_num_of_workers := 1;

Line 1792: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Calling DQM post import cleanup');

1788: END IF;
1789: END IF;
1790:
1791: IF r_batch_info.registry_dedup_flag = 'Y' OR r_batch_info.batch_dedup_flag = 'Y' THEN
1792: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Calling DQM post import cleanup');
1793: HZ_IMP_DQM_STAGE.dqm_post_imp_cleanup
1794: (p_batch_id => p_batch_id,
1795: x_return_status => l_return_status,
1796: x_msg_count => l_msg_count,

Line 1809: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Calling DQM interface tca sanitize report');

1805: */
1806: IF NVL(r_batch_info.registry_dedup_flag,'N') = 'Y' THEN
1807:
1808: -- call the report dupsets API
1809: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Calling DQM interface tca sanitize report');
1810: HZ_DQM_DUP_ID_PKG.interface_tca_sanitize_report
1811: (p_batch_id => p_batch_id,
1812: p_match_rule_id => r_batch_info.registry_dedup_match_rule_id,
1813: p_request_id => fnd_global.conc_request_id,

Line 1829: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Invoking auto merge post process');

1825: WHERE batch_id = p_batch_id
1826: AND run_number = l_current_run;
1827:
1828: IF p_run_automerge = 'Y' THEN
1829: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Invoking auto merge post process');
1830: l_am_sub_request := FND_REQUEST.SUBMIT_REQUEST(
1831: 'AR',
1832: 'ARHAMRGP',
1833: '',

Line 1841: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Error submitting auto merge post process');

1837: to_char(l_num_of_workers)
1838: );
1839:
1840: IF l_am_sub_request = 0 THEN
1841: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Error submitting auto merge post process');
1842: ELSE
1843: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Submitted request for auto merge post process');
1844: END IF;
1845:

Line 1843: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Submitted request for auto merge post process');

1839:
1840: IF l_am_sub_request = 0 THEN
1841: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Error submitting auto merge post process');
1842: ELSE
1843: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Submitted request for auto merge post process');
1844: END IF;
1845:
1846: END IF;
1847: END IF; --NVL(r_batch_info.r_batch_info.registry_dedup_flag,'N') = 'Y'

Line 1851: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Calling Parallel Sync Index concurrent program');

1847: END IF; --NVL(r_batch_info.r_batch_info.registry_dedup_flag,'N') = 'Y'
1848:
1849: IF (Nvl(FND_PROFILE.VALUE('HZ_DQM_ENABLE_REALTIME_SYNC'),'Y') <> 'DISABLE') THEN --Bug 10435345
1850: -- Bug 4594407 : Call DQM Sync Index
1851: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Calling Parallel Sync Index concurrent program');
1852: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Request Id of the program to be waited on, that is being passed to this : ' || fnd_global.conc_request_id );
1853: l_index_conc_program_req_id := FND_REQUEST.SUBMIT_REQUEST('AR',
1854: 'ARHDQMPP',
1855: 'DQM Parallel Sync Index Parent Program',

Line 1852: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Request Id of the program to be waited on, that is being passed to this : ' || fnd_global.conc_request_id );

1848:
1849: IF (Nvl(FND_PROFILE.VALUE('HZ_DQM_ENABLE_REALTIME_SYNC'),'Y') <> 'DISABLE') THEN --Bug 10435345
1850: -- Bug 4594407 : Call DQM Sync Index
1851: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Calling Parallel Sync Index concurrent program');
1852: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Request Id of the program to be waited on, that is being passed to this : ' || fnd_global.conc_request_id );
1853: l_index_conc_program_req_id := FND_REQUEST.SUBMIT_REQUEST('AR',
1854: 'ARHDQMPP',
1855: 'DQM Parallel Sync Index Parent Program',
1856: NULL,

Line 1861: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Error submitting DQM Sync Index Program.');

1857: FALSE,
1858: fnd_global.conc_request_id
1859: );
1860: IF l_index_conc_program_req_id = 0 THEN
1861: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Error submitting DQM Sync Index Program.');
1862: ELSE
1863: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Request Id of Parallel Sync concurrent Program is : ' || l_index_conc_program_req_id );
1864: END IF;
1865: END IF;

Line 1863: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Request Id of Parallel Sync concurrent Program is : ' || l_index_conc_program_req_id );

1859: );
1860: IF l_index_conc_program_req_id = 0 THEN
1861: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Error submitting DQM Sync Index Program.');
1862: ELSE
1863: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Request Id of Parallel Sync concurrent Program is : ' || l_index_conc_program_req_id );
1864: END IF;
1865: END IF;
1866:
1867: -- call dataload post processing

Line 1868: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Invoking data load post process');

1864: END IF;
1865: END IF;
1866:
1867: -- call dataload post processing
1868: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Invoking data load post process');
1869: FOR i IN 1..l_num_of_workers LOOP
1870: l_pp_sub_request := FND_REQUEST.SUBMIT_REQUEST(
1871: 'AR',
1872: 'ARHLPPLB',

Line 1884: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Error submitting data load post processing ' || l_num_of_workers);

1880: p_generate_fuzzy_key
1881: );
1882:
1883: IF l_pp_sub_request = 0 THEN
1884: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Error submitting data load post processing ' || l_num_of_workers);
1885: ELSE
1886: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Submitted request for data load post processing ' || l_num_of_workers);
1887: END IF;
1888: END LOOP;

Line 1886: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Submitted request for data load post processing ' || l_num_of_workers);

1882:
1883: IF l_pp_sub_request = 0 THEN
1884: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Error submitting data load post processing ' || l_num_of_workers);
1885: ELSE
1886: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Submitted request for data load post processing ' || l_num_of_workers);
1887: END IF;
1888: END LOOP;
1889:
1890: -- wait for the conc program to finish

Line 1909: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Program completed successfully');

1905: CLEANUP_STAGING(p_batch_id, l_batch_mode_flag);
1906: END IF;
1907:
1908: -- program completed successfully
1909: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Program completed successfully');
1910:
1911: /* Delete Work Unit if not what-if */
1912: IF p_import_run_option <> 'WHAT_IF'
1913: and (r_batch_info.import_status='COMPLETED'