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_IMP_LOAD_WRAPPER dependencies on FND_FILE

Line 3679: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Completed batch cannot be run again.');

3675: CLOSE c_wu;
3676:
3677: /* Exit if the batch is completed or is a duplicate run of a running request */
3678: IF P_RERUN_FLAG = 'C' THEN
3679: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Completed batch cannot be run again.');
3680: return;
3681: ELSIF P_RERUN_FLAG = 'D' THEN
3682: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Same batch cannot be run at the same time.');
3683: return;

Line 3682: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Same batch cannot be run at the same time.');

3678: IF P_RERUN_FLAG = 'C' THEN
3679: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Completed batch cannot be run again.');
3680: return;
3681: ELSIF P_RERUN_FLAG = 'D' THEN
3682: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Same batch cannot be run at the same time.');
3683: return;
3684: END IF;
3685:
3686: /*

Line 3895: FND_FILE.PUT_LINE(FND_FILE.LOG, 'log:' || l_error_message);

3891: IF l_hr_data_exists = 'Y' THEN
3892: FND_MESSAGE.SET_NAME('AR', 'HZ_IMP_NO_HR_DATALOAD');
3893: l_error_message := FND_MESSAGE.get;
3894:
3895: FND_FILE.PUT_LINE(FND_FILE.LOG, 'log:' || l_error_message);
3896: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_error_message);
3897: update_import_status(P_BATCH_ID, 'ERROR');
3898:
3899: errbuf := l_error_message;

Line 3896: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_error_message);

3892: FND_MESSAGE.SET_NAME('AR', 'HZ_IMP_NO_HR_DATALOAD');
3893: l_error_message := FND_MESSAGE.get;
3894:
3895: FND_FILE.PUT_LINE(FND_FILE.LOG, 'log:' || l_error_message);
3896: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_error_message);
3897: update_import_status(P_BATCH_ID, 'ERROR');
3898:
3899: errbuf := l_error_message;
3900: retcode := 2;

Line 3931: FND_FILE.PUT_LINE(FND_FILE.LOG, 'log:' || l_error_message);

3927: P_PROGRAM_APPLICATION_ID,l_return_status);
3928:
3929: IF l_return_status = 'E' THEN
3930: l_error_message := 'Invalid party_id(s) is found in hz_imp_parties_int that does not exist in hz_parties. Please correct the party_id and resubmit the batch for import. Please check error report for invalid party_id(s).';
3931: FND_FILE.PUT_LINE(FND_FILE.LOG, 'log:' || l_error_message);
3932: update_import_status(P_BATCH_ID, 'ERROR');
3933:
3934: errbuf := l_error_message;
3935: retcode := 2;

Line 3941: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Analyze all interface tables ' ||

3937: END IF;
3938:
3939: IF P_BATCH_MODE_FLAG = 'Y' AND P_RERUN_FLAG = 'N' THEN
3940: -- Analyze interface tables
3941: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Analyze all interface tables ' ||
3942: to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
3943:
3944: fnd_stats.gather_table_stats('AR', 'HZ_IMP_PARTIES_INT');
3945: fnd_stats.gather_table_stats('AR', 'HZ_IMP_ADDRESSES_INT');

Line 4026: FND_FILE.PUT_LINE(FND_FILE.LOG, '****** Finished processing stage 1 ');

4022: END IF;
4023:
4024:
4025: elsif (stage=2) then
4026: FND_FILE.PUT_LINE(FND_FILE.LOG, '****** Finished processing stage 1 ');
4027:
4028: /* Bug7374773 : Call cleanup_dup_osr for NO_VERSION profile also */
4029: CLEANUP_DUP_OSR(P_BATCH_ID,P_BATCH_MODE_FLAG,'PARTY',P_ORIG_SYSTEM);
4030:

Line 4035: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Analyze party staging table ' ||

4031:
4032: /* Matching of other entities, DQM, V+DML of Parties */
4033: IF P_BATCH_MODE_FLAG = 'Y' THEN
4034: -- Analyze parties staging after matching
4035: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Analyze party staging table ' ||
4036: to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
4037: fnd_stats.gather_table_stats('AR', 'HZ_IMP_PARTIES_SG', percent=>10, degree=>4);
4038: END IF;
4039:

Line 4041: FND_FILE.PUT_LINE(FND_FILE.LOG, '****** Finished processing stage 2 ');

4037: fnd_stats.gather_table_stats('AR', 'HZ_IMP_PARTIES_SG', percent=>10, degree=>4);
4038: END IF;
4039:
4040: elsif (stage=3) then
4041: FND_FILE.PUT_LINE(FND_FILE.LOG, '****** Finished processing stage 2 ');
4042: /* Bug7374773 : Call cleanup_dup_osr for NO_VERSION profile also */
4043: CLEANUP_DUP_OSR(P_BATCH_ID,P_BATCH_MODE_FLAG,'ADDRESS',P_ORIG_SYSTEM);
4044:
4045:

Line 4048: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Analyze other entity staging tables ' ||

4044:
4045:
4046: IF P_BATCH_MODE_FLAG = 'Y' THEN
4047: -- Analyze staging table after matching
4048: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Analyze other entity staging tables ' ||
4049: to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
4050: fnd_stats.gather_table_stats('AR', 'HZ_IMP_ADDRESSES_SG', percent=>5, degree=>4);
4051: fnd_stats.gather_table_stats('AR', 'HZ_IMP_ADDRESSUSES_SG', percent=>5, degree=>4);
4052: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CLASSIFICS_SG', percent=>5, degree=>4);

Line 4214: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Warning: No data is imported by the batch.');

4210: from hz_imp_batch_summary
4211: where batch_id = P_BATCH_ID;
4212:
4213: IF l_total_records_imported <= 0 THEN
4214: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Warning: No data is imported by the batch.');
4215: END IF;
4216: END IF;
4217:
4218: -- all stages have finished

Line 4228: FND_FILE.PUT_LINE(FND_FILE.LOG, '****** Submitted stage 1 for worker no. '||to_char(i));

4224: FOR i IN 1..P_NUM_OF_WORKERS LOOP
4225:
4226: -- submit request for each worker process
4227: IF (stage=1) THEN
4228: FND_FILE.PUT_LINE(FND_FILE.LOG, '****** Submitted stage 1 for worker no. '||to_char(i));
4229: l_request_id := FND_REQUEST.SUBMIT_REQUEST(
4230: 'AR', 'ARHLSG1W',
4231: 'Worker '||i,
4232: SYSDATE,

Line 4242: FND_FILE.PUT_LINE(FND_FILE.LOG, '****** Submitted stage 2 for worker no. '||to_char(i));

4238: );
4239:
4240:
4241: ELSIF (stage=2) THEN
4242: FND_FILE.PUT_LINE(FND_FILE.LOG, '****** Submitted stage 2 for worker no. '||to_char(i));
4243: l_request_id := FND_REQUEST.SUBMIT_REQUEST(
4244: 'AR', 'ARHLSG2W',
4245: 'Worker '||i,
4246: SYSDATE,

Line 4276: FND_FILE.PUT_LINE(FND_FILE.LOG, '****** Submitted stage 3 for worker no. '||to_char(i));

4272: );
4273:
4274:
4275: ELSIF (stage=3) THEN
4276: FND_FILE.PUT_LINE(FND_FILE.LOG, '****** Submitted stage 3 for worker no. '||to_char(i));
4277: l_request_id := FND_REQUEST.SUBMIT_REQUEST(
4278: 'AR', 'ARHLSG3W',
4279: 'Worker '||i,
4280: SYSDATE,

Line 4338: FND_FILE.PUT_LINE(FND_FILE.LOG, '******* Unexpected Error occured in stage '||to_char(stage)||' if worker submitted. Else it may have occured before submitting stage '||to_char(stage)||' in the main wrapper');

4334: END IF;
4335: l_error_message := FND_MESSAGE.get;
4336: errbuf := l_error_message;
4337: retcode := 2;
4338: FND_FILE.PUT_LINE(FND_FILE.LOG, '******* Unexpected Error occured in stage '||to_char(stage)||' if worker submitted. Else it may have occured before submitting stage '||to_char(stage)||' in the main wrapper');
4339: FND_FILE.PUT_LINE(FND_FILE.LOG, '******* Unexpected error: ' || SQLERRM);
4340: FND_FILE.PUT_LINE(FND_FILE.LOG, '******* Other errors: '|| l_error_message);
4341:
4342: IF stage>=2 AND

Line 4339: FND_FILE.PUT_LINE(FND_FILE.LOG, '******* Unexpected error: ' || SQLERRM);

4335: l_error_message := FND_MESSAGE.get;
4336: errbuf := l_error_message;
4337: retcode := 2;
4338: FND_FILE.PUT_LINE(FND_FILE.LOG, '******* Unexpected Error occured in stage '||to_char(stage)||' if worker submitted. Else it may have occured before submitting stage '||to_char(stage)||' in the main wrapper');
4339: FND_FILE.PUT_LINE(FND_FILE.LOG, '******* Unexpected error: ' || SQLERRM);
4340: FND_FILE.PUT_LINE(FND_FILE.LOG, '******* Other errors: '|| l_error_message);
4341:
4342: IF stage>=2 AND
4343: ( P_WHAT_IF_ANALYSIS is null

Line 4340: FND_FILE.PUT_LINE(FND_FILE.LOG, '******* Other errors: '|| l_error_message);

4336: errbuf := l_error_message;
4337: retcode := 2;
4338: FND_FILE.PUT_LINE(FND_FILE.LOG, '******* Unexpected Error occured in stage '||to_char(stage)||' if worker submitted. Else it may have occured before submitting stage '||to_char(stage)||' in the main wrapper');
4339: FND_FILE.PUT_LINE(FND_FILE.LOG, '******* Unexpected error: ' || SQLERRM);
4340: FND_FILE.PUT_LINE(FND_FILE.LOG, '******* Other errors: '|| l_error_message);
4341:
4342: IF stage>=2 AND
4343: ( P_WHAT_IF_ANALYSIS is null
4344: OR (P_WHAT_IF_ANALYSIS is not null AND P_WHAT_IF_ANALYSIS<>'A'))