64: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
65: END IF;
66:
67: IF FND_API.to_Boolean (p_init_msg_list) THEN
68: FND_MSG_PUB.initialize;
69: END IF;
70:
71: X_return_status := FND_API.G_RET_STS_SUCCESS;
72:
184: IF (c_conversion_type%ISOPEN) THEN
185: CLOSE c_conversion_type;
186: END IF;
187:
188: FND_MSG_PUB.Count_And_Get (p_count => X_msg_count,
189: p_data => X_msg_data);
190:
191: RETURN;
192:
198: X_return_status := FND_API.G_RET_STS_ERROR;
199: IF (c_conversion_type%ISOPEN) THEN
200: CLOSE c_conversion_type;
201: END IF;
202: FND_MSG_PUB.Count_And_Get (p_count => X_msg_count,
203: p_data => X_msg_data);
204:
205: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
206:
208: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
209: IF (c_conversion_type%ISOPEN) THEN
210: CLOSE c_conversion_type;
211: END IF;
212: FND_MSG_PUB.Count_And_Get (p_count => X_msg_count,
213: p_data => X_msg_data);
214:
215: WHEN OTHERS THEN
216:
219: IF (c_conversion_type%ISOPEN) THEN
220: CLOSE c_conversion_type;
221: END IF;
222:
223: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
224: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
225: l_api_name);
226: END if;
227:
220: CLOSE c_conversion_type;
221: END IF;
222:
223: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
224: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
225: l_api_name);
226: END if;
227:
228: FND_MSG_PUB.Count_And_Get (p_count => X_msg_count,
224: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
225: l_api_name);
226: END if;
227:
228: FND_MSG_PUB.Count_And_Get (p_count => X_msg_count,
229: p_data => X_msg_data);
230:
231: END get_rsobs_Headers;
232:
298: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
299: END IF;
300:
301: IF FND_API.to_Boolean (p_init_msg_list) THEN
302: FND_MSG_PUB.initialize;
303: END IF;
304:
305: X_return_status := FND_API.G_RET_STS_SUCCESS;
306:
444: IF (c_conversion_type%ISOPEN) THEN
445: CLOSE c_conversion_type;
446: END IF;
447:
448: FND_MSG_PUB.Count_And_Get (p_count => X_msg_count,
449: p_data => X_msg_data);
450:
451: RETURN;
452:
458: X_return_status := FND_API.G_RET_STS_ERROR;
459: IF (c_conversion_type%ISOPEN) THEN
460: CLOSE c_conversion_type;
461: END IF;
462: FND_MSG_PUB.Count_And_Get (p_count => X_msg_count,
463: p_data => X_msg_data);
464:
465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
466:
468: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
469: IF (c_conversion_type%ISOPEN) THEN
470: CLOSE c_conversion_type;
471: END IF;
472: FND_MSG_PUB.Count_And_Get (p_count => X_msg_count,
473: p_data => X_msg_data);
474:
475: WHEN OTHERS THEN
476:
479: IF (c_conversion_type%ISOPEN) THEN
480: CLOSE c_conversion_type;
481: END IF;
482:
483: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
484: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
485: l_api_name);
486: END if;
487:
480: CLOSE c_conversion_type;
481: END IF;
482:
483: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
484: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
485: l_api_name);
486: END if;
487:
488: FND_MSG_PUB.Count_And_Get (p_count => X_msg_count,
484: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
485: l_api_name);
486: END if;
487:
488: FND_MSG_PUB.Count_And_Get (p_count => X_msg_count,
489: p_data => X_msg_data);
490:
491: END get_rsobs_Acct_Lines;
492:
554: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
555: END IF;
556:
557: IF FND_API.to_Boolean (p_init_msg_list) THEN
558: FND_MSG_PUB.initialize;
559: END IF;
560:
561: X_return_status := FND_API.G_RET_STS_SUCCESS;
562:
686: IF (c_conversion_type%ISOPEN) THEN
687: CLOSE c_conversion_type;
688: END IF;
689:
690: FND_MSG_PUB.Count_And_Get (p_count => X_msg_count,
691: p_data => X_msg_data);
692:
693: RETURN;
694:
699: X_return_status := FND_API.G_RET_STS_ERROR;
700: IF (c_conversion_type%ISOPEN) THEN
701: CLOSE c_conversion_type;
702: END IF;
703: FND_MSG_PUB.Count_And_Get (p_count => X_msg_count,
704: p_data => X_msg_data);
705:
706: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
707: ROLLBACK TO SAVEPOINT get_rsobs_DET_PF_PT;
708: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
709: IF (c_conversion_type%ISOPEN) THEN
710: CLOSE c_conversion_type;
711: END IF;
712: FND_MSG_PUB.Count_And_Get (p_count => X_msg_count,
713: p_data => X_msg_data);
714:
715: WHEN OTHERS THEN
716: ROLLBACK TO SAVEPOINT get_rsobs_DET_PF_PT;
718: IF (c_conversion_type%ISOPEN) THEN
719: CLOSE c_conversion_type;
720: END IF;
721:
722: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
723: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
724: l_api_name);
725: END if;
726:
719: CLOSE c_conversion_type;
720: END IF;
721:
722: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
723: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
724: l_api_name);
725: END if;
726:
727: FND_MSG_PUB.Count_And_Get (p_count => X_msg_count,
723: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
724: l_api_name);
725: END if;
726:
727: FND_MSG_PUB.Count_And_Get (p_count => X_msg_count,
728: p_data => X_msg_data);
729:
730: END get_rsobs_DET_PF;
731: