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

Line 50: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Stage 3 WORKER_PROCESS (+)');

46: l_pp_status VARCHAR2(30);
47:
48: BEGIN
49:
50: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Stage 3 WORKER_PROCESS (+)');
51:
52: -- construct DML_RECORD_TYPE l_dml_record
53: -- value for l_dml_record.RERUN will be decide later.
54:

Line 101: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_real_error_count =' || l_real_error_count);

97: FROM HZ_IMP_TMP_ERRORS
98: WHERE BATCH_ID = l_dml_record.BATCH_ID
99: AND REQUEST_ID = l_dml_record.REQUEST_ID;
100:
101: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_real_error_count =' || l_real_error_count);
102:
103: IF l_real_error_count >= l_dml_record.ERROR_LIMIT THEN
104:
105: -- error limit reached , decrease stage in HZ_IMP_WORK_UNITS table

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

119: -- Bug 4594407
120: HZ_IMP_LOAD_WRAPPER.RETRIEVE_WORK_UNIT(P_BATCH_ID, '3' , l_dml_record.OS, l_dml_record.FROM_OSR, l_dml_record.TO_OSR,
121: l_hwm_stage, l_pp_status);
122:
123: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Retrieved Work unit');
124: FND_FILE.PUT_LINE(FND_FILE.LOG, 'wu_os:' || l_dml_record.OS);
125: FND_FILE.PUT_LINE(FND_FILE.LOG, 'from_osr:' || l_dml_record.FROM_OSR);
126: FND_FILE.PUT_LINE(FND_FILE.LOG, 'to_osr:' || l_dml_record.TO_OSR);
127:

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

120: HZ_IMP_LOAD_WRAPPER.RETRIEVE_WORK_UNIT(P_BATCH_ID, '3' , l_dml_record.OS, l_dml_record.FROM_OSR, l_dml_record.TO_OSR,
121: l_hwm_stage, l_pp_status);
122:
123: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Retrieved Work unit');
124: FND_FILE.PUT_LINE(FND_FILE.LOG, 'wu_os:' || l_dml_record.OS);
125: FND_FILE.PUT_LINE(FND_FILE.LOG, 'from_osr:' || l_dml_record.FROM_OSR);
126: FND_FILE.PUT_LINE(FND_FILE.LOG, 'to_osr:' || l_dml_record.TO_OSR);
127:
128: IF (l_dml_record.OS IS NULL) Then

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

121: l_hwm_stage, l_pp_status);
122:
123: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Retrieved Work unit');
124: FND_FILE.PUT_LINE(FND_FILE.LOG, 'wu_os:' || l_dml_record.OS);
125: FND_FILE.PUT_LINE(FND_FILE.LOG, 'from_osr:' || l_dml_record.FROM_OSR);
126: FND_FILE.PUT_LINE(FND_FILE.LOG, 'to_osr:' || l_dml_record.TO_OSR);
127:
128: IF (l_dml_record.OS IS NULL) Then
129: EXIT;

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

122:
123: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Retrieved Work unit');
124: FND_FILE.PUT_LINE(FND_FILE.LOG, 'wu_os:' || l_dml_record.OS);
125: FND_FILE.PUT_LINE(FND_FILE.LOG, 'from_osr:' || l_dml_record.FROM_OSR);
126: FND_FILE.PUT_LINE(FND_FILE.LOG, 'to_osr:' || l_dml_record.TO_OSR);
127:
128: IF (l_dml_record.OS IS NULL) Then
129: EXIT;
130: END IF;

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

152: WHERE BATCH_ID = l_dml_record.BATCH_ID
153: AND FROM_ORIG_SYSTEM_REF = l_dml_record.FROM_OSR;
154: */
155:
156: FND_FILE.PUT_LINE(FND_FILE.LOG, 'debug: P_RERUN = ' || P_RERUN);
157:
158: -- set re-run flag
159: IF P_RERUN = 'E' THEN
160: l_dml_record.RERUN := 'Y';

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

180: ELSE
181: l_dml_record.RERUN := 'N';
182: END IF;
183:
184: FND_FILE.PUT_LINE(FND_FILE.LOG, 'debug: l_dml_record.RERUN = ' || l_dml_record.RERUN);
185:
186: -- Invoke concurrent program for 'V+DML' of all other Entities
187:
188: -- Load Relatioship

Line 199: FND_FILE.PUT_LINE(FND_FILE.LOG, 'debug: load_relationships completed ');

195:
196: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
197: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
198: END IF;
199: FND_FILE.PUT_LINE(FND_FILE.LOG, 'debug: load_relationships completed ');
200:
201: -- Bug 4594407
202: -- Populate staging table for unprocessed post-processing records from previous run
203: -- matching of relationships

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

210: l_dml_record.ACTUAL_CONTENT_SRC,
211: 'N',
212: l_dml_record.BATCH_MODE_FLAG
213: );
214: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MATCH_RELATIONSHIPS completed ');
215: END IF;
216:
217: -- Load Org Contact
218: HZ_IMP_LOAD_ORG_CONTACT_PKG.load_org_contacts (

Line 228: FND_FILE.PUT_LINE(FND_FILE.LOG, 'debug: load_org_contacts completed ');

224:
225: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
226: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
227: END IF;
228: FND_FILE.PUT_LINE(FND_FILE.LOG, 'debug: load_org_contacts completed ');
229:
230: -- Bug 4594407
231: -- Populate staging table for unprocessed post-processing records from previous run
232: -- matching of org contact

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

239: l_dml_record.ACTUAL_CONTENT_SRC,
240: 'N',
241: l_dml_record.BATCH_MODE_FLAG
242: );
243: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MATCH_CONTACTS completed ');
244: END IF;
245:
246: -- Load Addresses
247: HZ_IMP_LOAD_ADDRESSES_PKG.load_addresses (

Line 260: FND_FILE.PUT_LINE(FND_FILE.LOG, 'debug: load_addresses completed ');

256:
257: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
258: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
259: END IF;
260: FND_FILE.PUT_LINE(FND_FILE.LOG, 'debug: load_addresses completed ');
261:
262: -- Bug 4594407
263: -- Populate staging table for unprocessed post-processing records from previous run
264: -- matching of addresses

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

270: l_dml_record.TO_OSR,
271: 'N',
272: l_dml_record.BATCH_MODE_FLAG
273: );
274: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MATCH_ADDRESSES completed ');
275: END IF;
276:
277: -- Load Contact Point
278: HZ_IMP_LOAD_CPT_PKG.load_contactpoints (

Line 288: FND_FILE.PUT_LINE(FND_FILE.LOG, 'debug: load_contactpoints completed ');

284:
285: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
287: END IF;
288: FND_FILE.PUT_LINE(FND_FILE.LOG, 'debug: load_contactpoints completed ');
289:
290: -- Bug 4594407
291: -- Populate staging table for unprocessed post-processing records from previous run
292: -- matching of contact points

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

298: l_dml_record.TO_OSR,
299: 'N',
300: l_dml_record.BATCH_MODE_FLAG
301: );
302: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MATCH_CONTACT_POINTS completed ');
303: END IF;
304:
305: -- Load Party Site Use
306: HZ_IMP_LOAD_PARTY_SITE_USE_PKG.load_partysiteuses (

Line 316: FND_FILE.PUT_LINE(FND_FILE.LOG, 'debug: load_partysiteuses completed ');

312:
313: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
315: END IF;
316: FND_FILE.PUT_LINE(FND_FILE.LOG, 'debug: load_partysiteuses completed ');
317:
318: -- Load contact Role
319: HZ_IMP_LOAD_CONTACT_ROLE_PKG.load_contactroles (
320: P_DML_RECORD => l_dml_record,

Line 329: FND_FILE.PUT_LINE(FND_FILE.LOG, 'debug: load_contactroles completed ');

325:
326: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
327: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
328: END IF;
329: FND_FILE.PUT_LINE(FND_FILE.LOG, 'debug: load_contactroles completed ');
330:
331: -- Load Financial Reports
332: HZ_IMP_LOAD_FINREPORTS_PKG.load_finreports (
333: P_DML_RECORD => l_dml_record,

Line 342: FND_FILE.PUT_LINE(FND_FILE.LOG, 'debug: load_finreports completed ');

338:
339: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
341: END IF;
342: FND_FILE.PUT_LINE(FND_FILE.LOG, 'debug: load_finreports completed ');
343:
344: -- Load Financial Numbers
345: HZ_IMP_LOAD_FINNUMBERS_PKG.load_finnumbers (
346: P_DML_RECORD => l_dml_record,

Line 355: FND_FILE.PUT_LINE(FND_FILE.LOG, 'debug: load_finnumbers completed ');

351:
352: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
353: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
354: END IF;
355: FND_FILE.PUT_LINE(FND_FILE.LOG, 'debug: load_finnumbers completed ');
356:
357: -- Load Credit Ratings
358: HZ_IMP_LOAD_CREDITRATINGS_PKG.load_creditratings (
359: P_DML_RECORD => l_dml_record,

Line 368: FND_FILE.PUT_LINE(FND_FILE.LOG, 'debug: load_creditratings completed ');

364:
365: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
366: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
367: END IF;
368: FND_FILE.PUT_LINE(FND_FILE.LOG, 'debug: load_creditratings completed ');
369:
370: -- Load Code Assignments
371: HZ_IMP_LOAD_CODE_ASSIGNMENTS.load_code_assignments (
372: P_DML_RECORD => l_dml_record,

Line 381: FND_FILE.PUT_LINE(FND_FILE.LOG, 'debug: load_code_assignments completed ');

377:
378: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
379: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
380: END IF;
381: FND_FILE.PUT_LINE(FND_FILE.LOG, 'debug: load_code_assignments completed ');
382:
383:
384: UPDATE HZ_IMP_WORK_UNITS
385: SET STATUS = 'C'

Line 396: FND_FILE.PUT_LINE(FND_FILE.LOG, 'debug: Staging table cleaned up ');

392: /* comment out as this will be done in main wrapper
393:
394: -- Clean up Staging table
395: HZ_IMP_LOAD_WRAPPER.cleanup_staging(l_dml_record.BATCH_ID, l_dml_record.BATCH_MODE_FLAG);
396: FND_FILE.PUT_LINE(FND_FILE.LOG, 'debug: Staging table cleaned up ');
397:
398: -- Delete Work Unit
399: delete hz_imp_work_units where batch_id = P_BATCH_ID;
400: FND_FILE.PUT_LINE(FND_FILE.LOG, 'debug: work united deleted');

Line 400: FND_FILE.PUT_LINE(FND_FILE.LOG, 'debug: work united deleted');

396: FND_FILE.PUT_LINE(FND_FILE.LOG, 'debug: Staging table cleaned up ');
397:
398: -- Delete Work Unit
399: delete hz_imp_work_units where batch_id = P_BATCH_ID;
400: FND_FILE.PUT_LINE(FND_FILE.LOG, 'debug: work united deleted');
401:
402: -- Change status ton Summary table to 'COMPLELTE'
403: update hz_imp_batch_summary
404: set IMPORT_STATUS = 'COMPLETED'

Line 406: FND_FILE.PUT_LINE(FND_FILE.LOG, 'debug: Summary table updated');

402: -- Change status ton Summary table to 'COMPLELTE'
403: update hz_imp_batch_summary
404: set IMPORT_STATUS = 'COMPLETED'
405: where BATCH_ID = P_BATCH_ID;
406: FND_FILE.PUT_LINE(FND_FILE.LOG, 'debug: Summary table updated');
407: */
408: COMMIT;
409:
410: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Stage 3 WORKER_PROCESS (-)');

Line 410: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Stage 3 WORKER_PROCESS (-)');

406: FND_FILE.PUT_LINE(FND_FILE.LOG, 'debug: Summary table updated');
407: */
408: COMMIT;
409:
410: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Stage 3 WORKER_PROCESS (-)');
411:
412: RETURN;
413:
414: EXCEPTION

Line 436: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Stage 3 worker: SQLERRM: ' || SQLERRM);

432: WHERE batch_id = P_BATCH_ID);
433:
434: COMMIT;
435:
436: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Stage 3 worker: SQLERRM: ' || SQLERRM);
437: FND_FILE.PUT_LINE(FND_FILE.LOG, SubStr('l_msg_data = '||l_msg_data,1,255));
438: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
439: FND_FILE.PUT_LINE(FND_FILE.LOG, 'message[' ||I||']=');
440: FND_FILE.PUT_LINE(FND_FILE.LOG, Substr(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ),1,255));

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

433:
434: COMMIT;
435:
436: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Stage 3 worker: SQLERRM: ' || SQLERRM);
437: FND_FILE.PUT_LINE(FND_FILE.LOG, SubStr('l_msg_data = '||l_msg_data,1,255));
438: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
439: FND_FILE.PUT_LINE(FND_FILE.LOG, 'message[' ||I||']=');
440: FND_FILE.PUT_LINE(FND_FILE.LOG, Substr(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ),1,255));
441: END LOOP;

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

435:
436: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Stage 3 worker: SQLERRM: ' || SQLERRM);
437: FND_FILE.PUT_LINE(FND_FILE.LOG, SubStr('l_msg_data = '||l_msg_data,1,255));
438: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
439: FND_FILE.PUT_LINE(FND_FILE.LOG, 'message[' ||I||']=');
440: FND_FILE.PUT_LINE(FND_FILE.LOG, Substr(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ),1,255));
441: END LOOP;
442:
443: END WORKER_PROCESS;

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

436: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Stage 3 worker: SQLERRM: ' || SQLERRM);
437: FND_FILE.PUT_LINE(FND_FILE.LOG, SubStr('l_msg_data = '||l_msg_data,1,255));
438: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
439: FND_FILE.PUT_LINE(FND_FILE.LOG, 'message[' ||I||']=');
440: FND_FILE.PUT_LINE(FND_FILE.LOG, Substr(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ),1,255));
441: END LOOP;
442:
443: END WORKER_PROCESS;
444: