DBA Data[Home] [Help]

APPS.HZ_IMP_LOAD_STAGE3 dependencies on FND_API

Line 196: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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:

Line 197: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

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

Line 225: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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:

Line 226: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

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

Line 257: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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:

Line 258: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

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

Line 285: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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:

Line 286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

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

Line 313: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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:

Line 314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

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

Line 326: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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:

Line 327: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

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

Line 339: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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:

Line 340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

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

Line 352: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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:

Line 353: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

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

Line 365: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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:

Line 366: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

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

Line 378: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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:

Line 379: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

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:

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: