192: x_msg_count => l_msg_count,
193: x_msg_data => l_msg_data
194: );
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:
193: x_msg_data => l_msg_data
194: );
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
221: x_msg_count => l_msg_count,
222: x_msg_data => l_msg_data
223: );
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:
222: x_msg_data => l_msg_data
223: );
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
253: x_msg_count => l_msg_count,
254: x_msg_data => l_msg_data
255: );
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:
254: x_msg_data => l_msg_data
255: );
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
281: x_msg_count => l_msg_count,
282: x_msg_data => l_msg_data
283: );
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:
282: x_msg_data => l_msg_data
283: );
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
309: x_msg_count => l_msg_count,
310: x_msg_data => l_msg_data
311: );
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:
310: x_msg_data => l_msg_data
311: );
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
322: x_msg_count => l_msg_count,
323: x_msg_data => l_msg_data
324: );
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:
323: x_msg_data => l_msg_data
324: );
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
335: x_msg_count => l_msg_count,
336: x_msg_data => l_msg_data
337: );
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:
336: x_msg_data => l_msg_data
337: );
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
348: x_msg_count => l_msg_count,
349: x_msg_data => l_msg_data
350: );
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:
349: x_msg_data => l_msg_data
350: );
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
361: x_msg_count => l_msg_count,
362: x_msg_data => l_msg_data
363: );
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:
362: x_msg_data => l_msg_data
363: );
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
374: x_msg_count => l_msg_count,
375: x_msg_data => l_msg_data
376: );
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:
375: x_msg_data => l_msg_data
376: );
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:
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: