64: END IF;
65:
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:
229: IF (c_conversion_type%ISOPEN) THEN
230: CLOSE c_conversion_type;
231: END IF;
232:
233: FND_MSG_PUB.Count_And_Get (p_count => X_msg_count,
234: p_data => X_msg_data);
235:
236: RETURN;
237:
243: X_return_status := FND_API.G_RET_STS_ERROR;
244: IF (c_conversion_type%ISOPEN) THEN
245: CLOSE c_conversion_type;
246: END IF;
247: FND_MSG_PUB.Count_And_Get (p_count => X_msg_count,
248: p_data => X_msg_data);
249:
250: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
251:
253: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
254: IF (c_conversion_type%ISOPEN) THEN
255: CLOSE c_conversion_type;
256: END IF;
257: FND_MSG_PUB.Count_And_Get (p_count => X_msg_count,
258: p_data => X_msg_data);
259:
260: WHEN OTHERS THEN
261:
264: IF (c_conversion_type%ISOPEN) THEN
265: CLOSE c_conversion_type;
266: END IF;
267:
268: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
269: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
270: l_api_name);
271: END if;
272:
265: CLOSE c_conversion_type;
266: END IF;
267:
268: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
269: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
270: l_api_name);
271: END if;
272:
273: FND_MSG_PUB.Count_And_Get (p_count => X_msg_count,
269: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
270: l_api_name);
271: END if;
272:
273: FND_MSG_PUB.Count_And_Get (p_count => X_msg_count,
274: p_data => X_msg_data);
275:
276: END get_rsobs_Headers;
277:
341: END IF;
342:
343:
344: IF FND_API.to_Boolean (p_init_msg_list ) THEN
345: FND_MSG_PUB.initialize;
346: END IF;
347:
348: X_return_status := FND_API.G_RET_STS_SUCCESS;
349:
562: IF (c_conversion_type%ISOPEN) THEN
563: CLOSE c_conversion_type;
564: END IF;
565:
566: FND_MSG_PUB.Count_And_Get (p_count => X_msg_count,
567: p_data => X_msg_data);
568:
569: RETURN;
570:
577: X_return_status := FND_API.G_RET_STS_ERROR;
578: IF (c_conversion_type%ISOPEN) THEN
579: CLOSE c_conversion_type;
580: END IF;
581: FND_MSG_PUB.Count_And_Get (p_count => X_msg_count,
582: p_data => X_msg_data);
583:
584: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
585:
587: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
588: IF (c_conversion_type%ISOPEN) THEN
589: CLOSE c_conversion_type;
590: END IF;
591: FND_MSG_PUB.Count_And_Get (p_count => X_msg_count,
592: p_data => X_msg_data);
593:
594: WHEN OTHERS THEN
595:
598: IF (c_conversion_type%ISOPEN) THEN
599: CLOSE c_conversion_type;
600: END IF;
601:
602: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
603: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
604: l_api_name);
605: END if;
606:
599: CLOSE c_conversion_type;
600: END IF;
601:
602: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
603: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
604: l_api_name);
605: END if;
606:
607: FND_MSG_PUB.Count_And_Get (p_count => X_msg_count,
603: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
604: l_api_name);
605: END if;
606:
607: FND_MSG_PUB.Count_And_Get (p_count => X_msg_count,
608: p_data => X_msg_data);
609:
610: END get_rsobs_Acct_Lines;
611:
674: END IF;
675:
676:
677: IF FND_API.to_Boolean (p_init_msg_list ) THEN
678: FND_MSG_PUB.initialize;
679: END IF;
680:
681: X_return_status := FND_API.G_RET_STS_SUCCESS;
682:
891: IF (c_conversion_type%ISOPEN) THEN
892: CLOSE c_conversion_type;
893: END IF;
894:
895: FND_MSG_PUB.Count_And_Get (p_count => X_msg_count,
896: p_data => X_msg_data);
897:
898: RETURN;
899:
905: X_return_status := FND_API.G_RET_STS_ERROR;
906: IF (c_conversion_type%ISOPEN) THEN
907: CLOSE c_conversion_type;
908: END IF;
909: FND_MSG_PUB.Count_And_Get (p_count => X_msg_count,
910: p_data => X_msg_data);
911:
912: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
913:
915: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
916: IF (c_conversion_type%ISOPEN) THEN
917: CLOSE c_conversion_type;
918: END IF;
919: FND_MSG_PUB.Count_And_Get (p_count => X_msg_count,
920: p_data => X_msg_data);
921:
922: WHEN OTHERS THEN
923:
926: IF (c_conversion_type%ISOPEN) THEN
927: CLOSE c_conversion_type;
928: END IF;
929:
930: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
931: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
932: l_api_name);
933: END if;
934:
927: CLOSE c_conversion_type;
928: END IF;
929:
930: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
931: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
932: l_api_name);
933: END if;
934:
935: FND_MSG_PUB.Count_And_Get (p_count => X_msg_count,
931: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
932: l_api_name);
933: END if;
934:
935: FND_MSG_PUB.Count_And_Get (p_count => X_msg_count,
936: p_data => X_msg_data);
937:
938: END get_rsobs_DET_PF;
939: