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

Line 10: FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR_LIMIT Reached, return to caller wrapper');

6: P_BATCH_MODE_FLAG IN VARCHAR2
7:
8: ) IS
9: BEGIN
10: FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR_LIMIT Reached, return to caller wrapper');
11:
12: commit;
13:
14: -- update batch summary table and detail table

Line 43: FND_FILE.PUT_LINE(FND_FILE.LOG,'WHAT_IF_ANALYSIS handling');

39: P_OS IN VARCHAR2
40: ) IS
41: BEGIN
42:
43: FND_FILE.PUT_LINE(FND_FILE.LOG,'WHAT_IF_ANALYSIS handling');
44:
45: -- update batch summary table and detail table
46: -- set statu as action required
47:

Line 156: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Stage 2 WORKER_PROCESS (+)');

152: -- Bug 4594407
153: l_pp_status VARCHAR2(30);
154:
155: BEGIN
156: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Stage 2 WORKER_PROCESS (+)');
157:
158: -- construct DML_RECORD_TYPE l_dml_record
159: -- value for l_dml_record.RERUN will be decide later.
160:

Line 192: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'debug: check for error limit');

188:
189: -- get the start error_id sequence number
190: -- if NO. of errors >= Error Limit, worker should not pick the next WU
191:
192: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'debug: check for error limit');
193: SELECT hz_imp_errors_s.CURRVAL INTO l_current_error_id FROM dual;
194:
195: -- if estimated error is greater than error limit
196: IF l_current_error_id - l_start_error_id >= l_dml_record.ERROR_LIMIT AND

Line 205: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Real error count =' || l_real_error_count);

201: FROM HZ_IMP_TMP_ERRORS
202: WHERE BATCH_ID = l_dml_record.BATCH_ID and
203: REQUEST_ID = l_dml_record.REQUEST_ID ;
204:
205: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Real error count =' || l_real_error_count);
206:
207: IF l_real_error_count >= l_dml_record.ERROR_LIMIT THEN
208:
209: /* bug 3401629 fix

Line 230: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Retrieved Work unit');

226: -- Bug 4594407
227: HZ_IMP_LOAD_WRAPPER.RETRIEVE_WORK_UNIT(P_BATCH_ID, '2' , l_dml_record.OS, l_dml_record.FROM_OSR, l_dml_record.TO_OSR,
228: l_hwm_stage, l_pp_status);
229:
230: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Retrieved Work unit');
231: FND_FILE.PUT_LINE(FND_FILE.LOG, 'wu_os:' || l_dml_record.OS);
232: FND_FILE.PUT_LINE(FND_FILE.LOG, 'from_osr:' || l_dml_record.FROM_OSR);
233: FND_FILE.PUT_LINE(FND_FILE.LOG, 'to_osr:' || l_dml_record.TO_OSR);
234:

Line 231: FND_FILE.PUT_LINE(FND_FILE.LOG, 'wu_os:' || l_dml_record.OS);

227: HZ_IMP_LOAD_WRAPPER.RETRIEVE_WORK_UNIT(P_BATCH_ID, '2' , l_dml_record.OS, l_dml_record.FROM_OSR, l_dml_record.TO_OSR,
228: l_hwm_stage, l_pp_status);
229:
230: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Retrieved Work unit');
231: FND_FILE.PUT_LINE(FND_FILE.LOG, 'wu_os:' || l_dml_record.OS);
232: FND_FILE.PUT_LINE(FND_FILE.LOG, 'from_osr:' || l_dml_record.FROM_OSR);
233: FND_FILE.PUT_LINE(FND_FILE.LOG, 'to_osr:' || l_dml_record.TO_OSR);
234:
235: IF (l_dml_record.OS IS NULL) Then

Line 232: FND_FILE.PUT_LINE(FND_FILE.LOG, 'from_osr:' || l_dml_record.FROM_OSR);

228: l_hwm_stage, l_pp_status);
229:
230: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Retrieved Work unit');
231: FND_FILE.PUT_LINE(FND_FILE.LOG, 'wu_os:' || l_dml_record.OS);
232: FND_FILE.PUT_LINE(FND_FILE.LOG, 'from_osr:' || l_dml_record.FROM_OSR);
233: FND_FILE.PUT_LINE(FND_FILE.LOG, 'to_osr:' || l_dml_record.TO_OSR);
234:
235: IF (l_dml_record.OS IS NULL) Then
236: EXIT;

Line 233: FND_FILE.PUT_LINE(FND_FILE.LOG, 'to_osr:' || l_dml_record.TO_OSR);

229:
230: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Retrieved Work unit');
231: FND_FILE.PUT_LINE(FND_FILE.LOG, 'wu_os:' || l_dml_record.OS);
232: FND_FILE.PUT_LINE(FND_FILE.LOG, 'from_osr:' || l_dml_record.FROM_OSR);
233: FND_FILE.PUT_LINE(FND_FILE.LOG, 'to_osr:' || l_dml_record.TO_OSR);
234:
235: IF (l_dml_record.OS IS NULL) Then
236: EXIT;
237: ELSE

Line 264: FND_FILE.PUT_LINE(FND_FILE.LOG, 'debug: P_RERUN = ' || P_RERUN);

260: WHERE BATCH_ID = l_dml_record.BATCH_ID
261: AND FROM_ORIG_SYSTEM_REF = l_dml_record.FROM_OSR;
262: */
263:
264: FND_FILE.PUT_LINE(FND_FILE.LOG, 'debug: P_RERUN = ' || P_RERUN);
265:
266: -- set re-run flag
267: IF P_RERUN = 'E' THEN
268: l_dml_record.RERUN := 'Y';

Line 292: FND_FILE.PUT_LINE(FND_FILE.LOG, 'debug: l_dml_record.RERUN = ' || l_dml_record.RERUN);

288: ELSE
289: l_dml_record.RERUN := 'N';
290: END IF;
291:
292: FND_FILE.PUT_LINE(FND_FILE.LOG, 'debug: l_dml_record.RERUN = ' || l_dml_record.RERUN);
293:
294: -- IF rerun flag is not 'R' or rerun flag is 'R' but no data in staging table
295: -- call matching and dqm
296:

Line 323: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MATCH_RELATIONSHIPS completed ');

319: l_dml_record.ACTUAL_CONTENT_SRC,
320: l_dml_record.RERUN,
321: l_dml_record.BATCH_MODE_FLAG
322: );
323: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MATCH_RELATIONSHIPS completed ');
324:
325: -- matching of org contacts
326: HZ_IMP_LOAD_SSM_MATCHING_PKG.MATCH_CONTACTS(
327: l_dml_record.BATCH_ID,

Line 335: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MATCH_CONTACTS completed ');

331: l_dml_record.ACTUAL_CONTENT_SRC,
332: l_dml_record.RERUN,
333: l_dml_record.BATCH_MODE_FLAG
334: );
335: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MATCH_CONTACTS completed ');
336:
337: -- matching of addresses
338: HZ_IMP_LOAD_SSM_MATCHING_PKG.MATCH_ADDRESSES(
339: l_dml_record.BATCH_ID,

Line 347: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MATCH_ADDRESSES completed ');

343: -- l_dml_record.ACTUAL_CONTENT_SRC,
344: l_dml_record.RERUN,
345: l_dml_record.BATCH_MODE_FLAG
346: );
347: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MATCH_ADDRESSES completed ');
348:
349: -- matching of contact points
350: HZ_IMP_LOAD_SSM_MATCHING_PKG.MATCH_CONTACT_POINTS(
351: l_dml_record.BATCH_ID,

Line 359: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MATCH_CONTACT_POINTS completed ');

355: -- l_dml_record.ACTUAL_CONTENT_SRC,
356: l_dml_record.RERUN,
357: l_dml_record.BATCH_MODE_FLAG
358: );
359: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MATCH_CONTACT_POINTS completed ');
360:
361: -- matching of party site use
362: HZ_IMP_LOAD_SSM_MATCHING_PKG.MATCH_ADDRUSES(
363: l_dml_record.BATCH_ID,

Line 371: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MATCH_ADDRUSES completed ');

367: l_dml_record.ACTUAL_CONTENT_SRC,
368: l_dml_record.RERUN,
369: l_dml_record.BATCH_MODE_FLAG
370: );
371: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MATCH_ADDRUSES completed ');
372:
373: -- matching of contact role
374: HZ_IMP_LOAD_SSM_MATCHING_PKG.MATCH_CONTACTROLES(
375: l_dml_record.BATCH_ID,

Line 383: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MATCH_CONTACTROLES completed ');

379: l_dml_record.ACTUAL_CONTENT_SRC,
380: l_dml_record.RERUN,
381: l_dml_record.BATCH_MODE_FLAG
382: );
383: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MATCH_CONTACTROLES completed ');
384:
385: -- matching of financial reports
386: HZ_IMP_LOAD_SSM_MATCHING_PKG.MATCH_FINANCIAL_REPORTS(
387: l_dml_record.BATCH_ID,

Line 395: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MATCH_FINANCIAL_REPORTS completed ');

391: l_dml_record.ACTUAL_CONTENT_SRC,
392: l_dml_record.RERUN,
393: l_dml_record.BATCH_MODE_FLAG
394: );
395: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MATCH_FINANCIAL_REPORTS completed ');
396:
397: -- matching of financial numbers
398: HZ_IMP_LOAD_SSM_MATCHING_PKG.MATCH_FINANCIAL_NUMBERS(
399: l_dml_record.BATCH_ID,

Line 407: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MATCH_FINANCIAL_NUMBERS completed ');

403: l_dml_record.ACTUAL_CONTENT_SRC,
404: l_dml_record.RERUN,
405: l_dml_record.BATCH_MODE_FLAG
406: );
407: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MATCH_FINANCIAL_NUMBERS completed ');
408:
409: -- matching of credit ratings
410: HZ_IMP_LOAD_SSM_MATCHING_PKG.MATCH_CREDIT_RATINGS(
411: l_dml_record.BATCH_ID,

Line 420: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MATCH_CREDIT_RATINGS completed ');

416: l_dml_record.ACTUAL_CONTENT_SRC,
417: l_dml_record.RERUN,
418: l_dml_record.BATCH_MODE_FLAG
419: );
420: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MATCH_CREDIT_RATINGS completed ');
421:
422: -- matching of code assignments
423: HZ_IMP_LOAD_SSM_MATCHING_PKG.MATCH_CODE_ASSIGNMENTS(
424: l_dml_record.BATCH_ID,

Line 432: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MATCH_CODE_ASSIGNMENTS completed ');

428: l_dml_record.ACTUAL_CONTENT_SRC,
429: l_dml_record.RERUN,
430: l_dml_record.BATCH_MODE_FLAG
431: );
432: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MATCH_CODE_ASSIGNMENTS completed ');
433:
434: IF P_REGISTRY_DEDUP = 'Y' THEN
435:
436: -- fetch record for DQM

Line 450: FND_FILE.PUT_LINE(FND_FILE.LOG, 'update dup party id ');

446: (P_RERUN = 'R' and l_what_if_sg_data_exists = 'Y') OR
447: (P_RERUN = 'U' AND l_hwm_stage >= 3)
448: THEN
449:
450: FND_FILE.PUT_LINE(FND_FILE.LOG, 'update dup party id ');
451:
452: -- update dup party id
453: UPDATE HZ_IMP_DUP_PARTIES idp
454: SET PARTY_ID =

Line 527: FND_FILE.PUT_LINE(FND_FILE.LOG, 'calling DQM ');

523: AND PARTY_ORIG_SYSTEM_REFERENCE BETWEEN l_dml_record.FROM_OSR AND l_dml_record.TO_OSR);
524:
525: ELSE
526:
527: FND_FILE.PUT_LINE(FND_FILE.LOG, 'calling DQM ');
528: HZ_DQM_DUP_ID_PKG.interface_tca_dup_id (
529: p_batch_id => l_dml_record.BATCH_ID,
530: p_match_rule_id => P_REGISTRY_DEDUP_MATCH_RULE_ID,
531: p_from_osr => l_dml_record.FROM_OSR,

Line 541: FND_FILE.PUT_LINE(FND_FILE.LOG, 'DQM return status ERROR');

537: x_msg_data => l_msg_data
538: );
539:
540: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
541: FND_FILE.PUT_LINE(FND_FILE.LOG, 'DQM return status ERROR');
542: FND_FILE.PUT_LINE(FND_FILE.LOG, SubStr('l_msg_data = '||l_msg_data,1,255));
543: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
544: FND_FILE.PUT_LINE(FND_FILE.LOG, 'message[' ||I||']=');
545: FND_FILE.PUT_LINE(FND_FILE.LOG, Substr(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ),1,255));

Line 542: FND_FILE.PUT_LINE(FND_FILE.LOG, SubStr('l_msg_data = '||l_msg_data,1,255));

538: );
539:
540: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
541: FND_FILE.PUT_LINE(FND_FILE.LOG, 'DQM return status ERROR');
542: FND_FILE.PUT_LINE(FND_FILE.LOG, SubStr('l_msg_data = '||l_msg_data,1,255));
543: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
544: FND_FILE.PUT_LINE(FND_FILE.LOG, 'message[' ||I||']=');
545: FND_FILE.PUT_LINE(FND_FILE.LOG, Substr(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ),1,255));
546: END LOOP;

Line 544: FND_FILE.PUT_LINE(FND_FILE.LOG, 'message[' ||I||']=');

540: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
541: FND_FILE.PUT_LINE(FND_FILE.LOG, 'DQM return status ERROR');
542: FND_FILE.PUT_LINE(FND_FILE.LOG, SubStr('l_msg_data = '||l_msg_data,1,255));
543: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
544: FND_FILE.PUT_LINE(FND_FILE.LOG, 'message[' ||I||']=');
545: FND_FILE.PUT_LINE(FND_FILE.LOG, Substr(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ),1,255));
546: END LOOP;
547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
548: END IF;

Line 545: FND_FILE.PUT_LINE(FND_FILE.LOG, Substr(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ),1,255));

541: FND_FILE.PUT_LINE(FND_FILE.LOG, 'DQM return status ERROR');
542: FND_FILE.PUT_LINE(FND_FILE.LOG, SubStr('l_msg_data = '||l_msg_data,1,255));
543: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
544: FND_FILE.PUT_LINE(FND_FILE.LOG, 'message[' ||I||']=');
545: FND_FILE.PUT_LINE(FND_FILE.LOG, Substr(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ),1,255));
546: END LOOP;
547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
548: END IF;
549: FND_FILE.PUT_LINE(FND_FILE.LOG, 'DQM complete successfully ');

Line 549: FND_FILE.PUT_LINE(FND_FILE.LOG, 'DQM complete successfully ');

545: FND_FILE.PUT_LINE(FND_FILE.LOG, Substr(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ),1,255));
546: END LOOP;
547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
548: END IF;
549: FND_FILE.PUT_LINE(FND_FILE.LOG, 'DQM complete successfully ');
550:
551: END IF;
552:
553: END IF; -- end of IF P_REGISTRY_DEDUP = 'Y'

Line 561: FND_FILE.PUT_LINE(FND_FILE.LOG, 'LOAD_PARTIES ... ');

557: -- Call V+DML Of Parties when
558: -- WHAT-IF ANALYSIS parameter <> 'ANALYSIS'
559: IF P_WHAT_IF_ANALYSIS is null OR (P_WHAT_IF_ANALYSIS is not null AND P_WHAT_IF_ANALYSIS <> 'A') THEN
560:
561: FND_FILE.PUT_LINE(FND_FILE.LOG, 'LOAD_PARTIES ... ');
562:
563: HZ_IMP_LOAD_PARTIES_PKG.LOAD_PARTIES (
564: P_DML_RECORD => l_dml_record,
565: X_RETURN_STATUS => l_return_status,

Line 574: FND_FILE.PUT_LINE(FND_FILE.LOG, 'LOAD_PARTIES successfully ');

570: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
571: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
572: END IF;
573:
574: FND_FILE.PUT_LINE(FND_FILE.LOG, 'LOAD_PARTIES successfully ');
575:
576: -- Bug 4594407
577: -- Populate staging table for unprocessed post-processing records from previous run
578: -- matching of parties

Line 591: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MATCH_PARTIES completed ');

587: l_dml_record.ACTUAL_CONTENT_SRC,
588: 'N',
589: l_dml_record.BATCH_MODE_FLAG
590: );
591: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MATCH_PARTIES completed ');
592: END IF;
593:
594: END IF;
595:

Line 608: FND_FILE.PUT_LINE(FND_FILE.LOG, 'debug: ANALYSIS ');

604: END LOOP;
605:
606: -- What-If parameter = 'ANALYSIS'
607: IF P_WHAT_IF_ANALYSIS = 'A' THEN
608: FND_FILE.PUT_LINE(FND_FILE.LOG, 'debug: ANALYSIS ');
609: WHAT_IF_ANALYSIS(l_dml_record.BATCH_ID, l_os);
610: END IF;
611:
612: /* code is moved to the wrapper

Line 628: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Stage 2 WORKER_PROCESS (-)');

624: fnd_stats.gather_table_stats('AR', 'HZ_IMP_RELSHIPS_SG', percent=>5, degree=>4);
625: END IF;
626: */
627:
628: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Stage 2 WORKER_PROCESS (-)');
629:
630: RETURN;
631:
632: EXCEPTION

Line 654: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Stage 2 worker: SQLERRM: ' || SQLERRM);

650: WHERE batch_id = P_BATCH_ID);
651:
652: COMMIT;
653:
654: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Stage 2 worker: SQLERRM: ' || SQLERRM);
655: FND_FILE.PUT_LINE(FND_FILE.LOG, SubStr('l_msg_data = '||l_msg_data,1,255));
656: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
657: FND_FILE.PUT_LINE(FND_FILE.LOG, 'message[' ||I||']=');
658: FND_FILE.PUT_LINE(FND_FILE.LOG, Substr(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ),1,255));

Line 655: FND_FILE.PUT_LINE(FND_FILE.LOG, SubStr('l_msg_data = '||l_msg_data,1,255));

651:
652: COMMIT;
653:
654: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Stage 2 worker: SQLERRM: ' || SQLERRM);
655: FND_FILE.PUT_LINE(FND_FILE.LOG, SubStr('l_msg_data = '||l_msg_data,1,255));
656: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
657: FND_FILE.PUT_LINE(FND_FILE.LOG, 'message[' ||I||']=');
658: FND_FILE.PUT_LINE(FND_FILE.LOG, Substr(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ),1,255));
659: END LOOP;

Line 657: FND_FILE.PUT_LINE(FND_FILE.LOG, 'message[' ||I||']=');

653:
654: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Stage 2 worker: SQLERRM: ' || SQLERRM);
655: FND_FILE.PUT_LINE(FND_FILE.LOG, SubStr('l_msg_data = '||l_msg_data,1,255));
656: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
657: FND_FILE.PUT_LINE(FND_FILE.LOG, 'message[' ||I||']=');
658: FND_FILE.PUT_LINE(FND_FILE.LOG, Substr(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ),1,255));
659: END LOOP;
660:
661:

Line 658: FND_FILE.PUT_LINE(FND_FILE.LOG, Substr(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ),1,255));

654: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Stage 2 worker: SQLERRM: ' || SQLERRM);
655: FND_FILE.PUT_LINE(FND_FILE.LOG, SubStr('l_msg_data = '||l_msg_data,1,255));
656: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
657: FND_FILE.PUT_LINE(FND_FILE.LOG, 'message[' ||I||']=');
658: FND_FILE.PUT_LINE(FND_FILE.LOG, Substr(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ),1,255));
659: END LOOP;
660:
661:
662: END WORKER_PROCESS;