56: RETURN (l_id);
57:
58: EXCEPTION
59: WHEN OTHERS THEN
60: IF OE_MSG_PUB.Check_msg_level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
61: THEN
62: OE_MSG_PUB.Add_exc_msg(G_PKG_NAME,'get_party_id');
63: END IF;
64: RAISE;
58: EXCEPTION
59: WHEN OTHERS THEN
60: IF OE_MSG_PUB.Check_msg_level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
61: THEN
62: OE_MSG_PUB.Add_exc_msg(G_PKG_NAME,'get_party_id');
63: END IF;
64: RAISE;
65:
66: END get_party_id ;
150: OE_DEBUG_PUB.ADD('OEXCRSMB - OUT NOCOPY Insert row ');
151:
152: EXCEPTION
153: WHEN OTHERS THEN
154: IF OE_MSG_PUB.Check_msg_level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
155: THEN
156: OE_MSG_PUB.Add_exc_msg(G_PKG_NAME,'Insert_row');
157: END IF;
158: RAISE;
152: EXCEPTION
153: WHEN OTHERS THEN
154: IF OE_MSG_PUB.Check_msg_level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
155: THEN
156: OE_MSG_PUB.Add_exc_msg(G_PKG_NAME,'Insert_row');
157: END IF;
158: RAISE;
159: END Insert_row;
160:
200:
201:
202: EXCEPTION
203: WHEN OTHERS THEN
204: IF OE_MSG_PUB.Check_msg_level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
205: THEN
206: OE_MSG_PUB.Add_exc_msg(G_PKG_NAME,'Update_row');
207: END IF;
208: RAISE;
202: EXCEPTION
203: WHEN OTHERS THEN
204: IF OE_MSG_PUB.Check_msg_level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
205: THEN
206: OE_MSG_PUB.Add_exc_msg(G_PKG_NAME,'Update_row');
207: END IF;
208: RAISE;
209: END Update_Row;
210:
228: DELETE FROM oe_credit_summaries
229: WHERE ROWID = CHARTOROWID(p_row_id);
230: EXCEPTION
231: WHEN OTHERS THEN
232: IF OE_MSG_PUB.Check_msg_level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
233: THEN
234: OE_MSG_PUB.Add_exc_msg(G_PKG_NAME,'Update_row');
235: END IF;
236: RAISE;
230: EXCEPTION
231: WHEN OTHERS THEN
232: IF OE_MSG_PUB.Check_msg_level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
233: THEN
234: OE_MSG_PUB.Add_exc_msg(G_PKG_NAME,'Update_row');
235: END IF;
236: RAISE;
237: END Delete_Row;
238: