DBA Data[Home] [Help]

APPS.BIS_PMV_PORTAL_UTIL_PVT dependencies on FND_API

Line 160: IF (l_return_status = FND_API.G_RET_STS_ERROR OR l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

156: x_msg_data => l_msg_data
157: ) ;
158: END IF;
159:
160: IF (l_return_status = FND_API.G_RET_STS_ERROR OR l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
161: x_return_status := l_return_status ;
162: x_msg_count := l_msg_count ;
163: x_msg_data := l_msg_data ;
164: RETURN;

Line 241: WHEN FND_API.G_EXC_ERROR THEN

237: END IF ; -- return_status is not error
238:
239:
240: EXCEPTION
241: WHEN FND_API.G_EXC_ERROR THEN
242: x_return_status := FND_API.G_RET_STS_ERROR;
243: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data) ;
244:
245: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 242: x_return_status := FND_API.G_RET_STS_ERROR;

238:
239:
240: EXCEPTION
241: WHEN FND_API.G_EXC_ERROR THEN
242: x_return_status := FND_API.G_RET_STS_ERROR;
243: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data) ;
244:
245: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 245: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

241: WHEN FND_API.G_EXC_ERROR THEN
242: x_return_status := FND_API.G_RET_STS_ERROR;
243: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data) ;
244:
245: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
247: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data) ;
248: WHEN OTHERS THEN
249: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

242: x_return_status := FND_API.G_RET_STS_ERROR;
243: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data) ;
244:
245: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
247: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data) ;
248: WHEN OTHERS THEN
249: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
250: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

Line 249: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

245: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
247: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data) ;
248: WHEN OTHERS THEN
249: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
250: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
251:
252: END clean_portlets ;
253:

Line 300: WHEN FND_API.G_EXC_ERROR THEN

296: return l_page_id ;
297:
298:
299: EXCEPTION
300: WHEN FND_API.G_EXC_ERROR THEN
301: x_return_status := FND_API.G_RET_STS_ERROR;
302: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data) ;
303:
304: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 301: x_return_status := FND_API.G_RET_STS_ERROR;

297:
298:
299: EXCEPTION
300: WHEN FND_API.G_EXC_ERROR THEN
301: x_return_status := FND_API.G_RET_STS_ERROR;
302: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data) ;
303:
304: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 304: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

300: WHEN FND_API.G_EXC_ERROR THEN
301: x_return_status := FND_API.G_RET_STS_ERROR;
302: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data) ;
303:
304: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
306: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data) ;
307: WHEN OTHERS THEN
308: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

301: x_return_status := FND_API.G_RET_STS_ERROR;
302: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data) ;
303:
304: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
306: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data) ;
307: WHEN OTHERS THEN
308: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
309: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

Line 308: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

304: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
306: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data) ;
307: WHEN OTHERS THEN
308: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
309: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
310:
311: END get_oa_page_id ;
312:

Line 437: WHEN FND_API.G_EXC_ERROR THEN

433:
434:
435:
436: EXCEPTION
437: WHEN FND_API.G_EXC_ERROR THEN
438: --jprabhud - 07/16/03- Make this a dynamic sql to remove portal dependency
439: if c_all_ref_paths%ISOPEN then
440: close c_all_ref_paths;
441: end if;

Line 442: x_return_status := FND_API.G_RET_STS_ERROR;

438: --jprabhud - 07/16/03- Make this a dynamic sql to remove portal dependency
439: if c_all_ref_paths%ISOPEN then
440: close c_all_ref_paths;
441: end if;
442: x_return_status := FND_API.G_RET_STS_ERROR;
443: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data) ;
444: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
445: --jprabhud - 07/16/03- Make this a dynamic sql to remove portal dependency
446: if c_all_ref_paths%ISOPEN then

Line 444: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

440: close c_all_ref_paths;
441: end if;
442: x_return_status := FND_API.G_RET_STS_ERROR;
443: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data) ;
444: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
445: --jprabhud - 07/16/03- Make this a dynamic sql to remove portal dependency
446: if c_all_ref_paths%ISOPEN then
447: close c_all_ref_paths;
448: end if;

Line 449: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

445: --jprabhud - 07/16/03- Make this a dynamic sql to remove portal dependency
446: if c_all_ref_paths%ISOPEN then
447: close c_all_ref_paths;
448: end if;
449: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
450: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data) ;
451: WHEN OTHERS THEN
452: --jprabhud - 07/16/03- Make this a dynamic sql to remove portal dependency
453: if c_all_ref_paths%ISOPEN then

Line 456: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

452: --jprabhud - 07/16/03- Make this a dynamic sql to remove portal dependency
453: if c_all_ref_paths%ISOPEN then
454: close c_all_ref_paths;
455: end if;
456: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
457: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
458: END get_reference_paths ;
459:
460:

Line 507: WHEN FND_API.G_EXC_ERROR THEN

503:
504:
505:
506: EXCEPTION
507: WHEN FND_API.G_EXC_ERROR THEN
508: x_return_status := FND_API.G_RET_STS_ERROR;
509: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data) ;
510: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
511: null ;

Line 508: x_return_status := FND_API.G_RET_STS_ERROR;

504:
505:
506: EXCEPTION
507: WHEN FND_API.G_EXC_ERROR THEN
508: x_return_status := FND_API.G_RET_STS_ERROR;
509: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data) ;
510: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
511: null ;
512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 510: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

506: EXCEPTION
507: WHEN FND_API.G_EXC_ERROR THEN
508: x_return_status := FND_API.G_RET_STS_ERROR;
509: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data) ;
510: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
511: null ;
512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
513: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data) ;
514: WHEN OTHERS THEN

Line 512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

508: x_return_status := FND_API.G_RET_STS_ERROR;
509: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data) ;
510: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
511: null ;
512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
513: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data) ;
514: WHEN OTHERS THEN
515: null ;
516: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 516: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
513: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data) ;
514: WHEN OTHERS THEN
515: null ;
516: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
517: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
518: END get_oa_reference_paths ;
519:
520: