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;
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
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;
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;
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);
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:
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
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;
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;
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);
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:
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;
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
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;
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
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:
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 ;
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;
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
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;
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: