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 752: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Calling Parallel Sync Index concurrent program');

748:
749: END IF; --NVL(l_reg_dedup,'N') = 'Y'
750:
751: -- Bug 4594407 : Call DQM Sync Index
752: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Calling Parallel Sync Index concurrent program');
753: 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 );
754: l_index_conc_program_req_id := FND_REQUEST.SUBMIT_REQUEST('AR',
755: 'ARHDQMPP',
756: 'DQM Parallel Sync Index Parent Program',

Line 753: 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 );

749: END IF; --NVL(l_reg_dedup,'N') = 'Y'
750:
751: -- Bug 4594407 : Call DQM Sync Index
752: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Calling Parallel Sync Index concurrent program');
753: 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 );
754: l_index_conc_program_req_id := FND_REQUEST.SUBMIT_REQUEST('AR',
755: 'ARHDQMPP',
756: 'DQM Parallel Sync Index Parent Program',
757: NULL,

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

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

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

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

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

764: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Request Id of Parallel Sync concurrent Program is : ' || l_index_conc_program_req_id );
765: END IF;
766:
767: -- call dataload post processing
768: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Invoking data load post process');
769: FOR i IN 1..l_num_of_workers LOOP
770: l_pp_sub_request := FND_REQUEST.SUBMIT_REQUEST(
771: 'AR',
772: 'ARHLPPLB',

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1475: END IF;
1476: END IF; --NVL(r_batch_info.registry_dedup_flag,'N') = 'Y'
1477:
1478: -- Bug 4594407 : Call DQM Sync Index
1479: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Calling Parallel Sync Index concurrent program');
1480: 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 );
1481: l_index_conc_program_req_id := FND_REQUEST.SUBMIT_REQUEST('AR',
1482: 'ARHDQMPP',
1483: 'DQM Parallel Sync Index Parent Program',

Line 1480: 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 );

1476: END IF; --NVL(r_batch_info.registry_dedup_flag,'N') = 'Y'
1477:
1478: -- Bug 4594407 : Call DQM Sync Index
1479: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Calling Parallel Sync Index concurrent program');
1480: 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 );
1481: l_index_conc_program_req_id := FND_REQUEST.SUBMIT_REQUEST('AR',
1482: 'ARHDQMPP',
1483: 'DQM Parallel Sync Index Parent Program',
1484: NULL,

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

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

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

1487: );
1488: IF l_index_conc_program_req_id = 0 THEN
1489: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Error submitting DQM Sync Index Program.');
1490: ELSE
1491: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Request Id of Parallel Sync concurrent Program is : ' || l_index_conc_program_req_id );
1492: END IF;
1493:
1494: -- call dataload post processing
1495: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Invoking data load post process');

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

1491: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Request Id of Parallel Sync concurrent Program is : ' || l_index_conc_program_req_id );
1492: END IF;
1493:
1494: -- call dataload post processing
1495: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Invoking data load post process');
1496: FOR i IN 1..l_num_of_workers LOOP
1497:
1498: l_pp_sub_request := FND_REQUEST.SUBMIT_REQUEST(
1499: 'AR',

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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');
1751: RETURN;
1752: ELSE
1753: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Submitted request for data load');
1754:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1842: END IF;
1843: END IF; --NVL(r_batch_info.r_batch_info.registry_dedup_flag,'N') = 'Y'
1844:
1845: -- Bug 4594407 : Call DQM Sync Index
1846: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Calling Parallel Sync Index concurrent program');
1847: 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: l_index_conc_program_req_id := FND_REQUEST.SUBMIT_REQUEST('AR',
1849: 'ARHDQMPP',
1850: 'DQM Parallel Sync Index Parent Program',

Line 1847: 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 );

1843: END IF; --NVL(r_batch_info.r_batch_info.registry_dedup_flag,'N') = 'Y'
1844:
1845: -- Bug 4594407 : Call DQM Sync Index
1846: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Calling Parallel Sync Index concurrent program');
1847: 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: l_index_conc_program_req_id := FND_REQUEST.SUBMIT_REQUEST('AR',
1849: 'ARHDQMPP',
1850: 'DQM Parallel Sync Index Parent Program',
1851: NULL,

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

1852: FALSE,
1853: fnd_global.conc_request_id
1854: );
1855: IF l_index_conc_program_req_id = 0 THEN
1856: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Error submitting DQM Sync Index Program.');
1857: ELSE
1858: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Request Id of Parallel Sync concurrent Program is : ' || l_index_conc_program_req_id );
1859: END IF;
1860:

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

1854: );
1855: IF l_index_conc_program_req_id = 0 THEN
1856: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Error submitting DQM Sync Index Program.');
1857: ELSE
1858: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Request Id of Parallel Sync concurrent Program is : ' || l_index_conc_program_req_id );
1859: END IF;
1860:
1861: -- call dataload post processing
1862: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Invoking data load post process');

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

1858: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Request Id of Parallel Sync concurrent Program is : ' || l_index_conc_program_req_id );
1859: END IF;
1860:
1861: -- call dataload post processing
1862: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Invoking data load post process');
1863: FOR i IN 1..l_num_of_workers LOOP
1864: l_pp_sub_request := FND_REQUEST.SUBMIT_REQUEST(
1865: 'AR',
1866: 'ARHLPPLB',

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

1874: p_generate_fuzzy_key
1875: );
1876:
1877: IF l_pp_sub_request = 0 THEN
1878: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Error submitting data load post processing ' || l_num_of_workers);
1879: ELSE
1880: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Submitted request for data load post processing ' || l_num_of_workers);
1881: END IF;
1882: END LOOP;

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

1876:
1877: IF l_pp_sub_request = 0 THEN
1878: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Error submitting data load post processing ' || l_num_of_workers);
1879: ELSE
1880: fnd_file.put_line(FND_FILE.LOG, 'UIC***** Submitted request for data load post processing ' || l_num_of_workers);
1881: END IF;
1882: END LOOP;
1883:
1884: -- wait for the conc program to finish

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

1899: CLEANUP_STAGING(p_batch_id, l_batch_mode_flag);
1900: END IF;
1901:
1902: -- program completed successfully
1903: FND_FILE.PUT_LINE (FND_FILE.LOG, 'UIC***** Program completed successfully');
1904:
1905: /* Delete Work Unit if not what-if */
1906: IF p_import_run_option <> 'WHAT_IF'
1907: and (r_batch_info.import_status='COMPLETED'