57: EXCEPTION
58:
59: WHEN OTHERS THEN
60:
61: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
62: THEN
63: FND_MSG_PUB.Add_Exc_Msg
64: ( G_PKG_NAME
65: , 'Update_Row'
59: WHEN OTHERS THEN
60:
61: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
62: THEN
63: FND_MSG_PUB.Add_Exc_Msg
64: ( G_PKG_NAME
65: , 'Update_Row'
66: );
67: END IF;
177:
178: EXCEPTION
179: WHEN DUP_VAL_ON_INDEX Then
180: --self correction on this error so that it would not happen again
181: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
182: THEN
183: FND_MSG_PUB.Add_Exc_Msg
184: ( G_PKG_NAME
185: , 'Insert_Row:'||SQLERRM
179: WHEN DUP_VAL_ON_INDEX Then
180: --self correction on this error so that it would not happen again
181: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
182: THEN
183: FND_MSG_PUB.Add_Exc_Msg
184: ( G_PKG_NAME
185: , 'Insert_Row:'||SQLERRM
186: );
187: END IF;
185: , 'Insert_Row:'||SQLERRM
186: );
187: END IF;
188:
189: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Insert_Row:'||SQLERRM);
190:
191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
192:
193: WHEN OTHERS THEN
193: WHEN OTHERS THEN
194: IF l_debug_level > 0 THEN
195: oe_debug_pub.add( G_PKG_NAME||':INSER_ROW:'||SQLERRM ) ;
196: END IF;
197: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
198: THEN
199: FND_MSG_PUB.Add_Exc_Msg
200: ( G_PKG_NAME
201: , 'Insert_Row:'||SQLERRM
195: oe_debug_pub.add( G_PKG_NAME||':INSER_ROW:'||SQLERRM ) ;
196: END IF;
197: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
198: THEN
199: FND_MSG_PUB.Add_Exc_Msg
200: ( G_PKG_NAME
201: , 'Insert_Row:'||SQLERRM
202: );
203: END IF;
201: , 'Insert_Row:'||SQLERRM
202: );
203: END IF;
204:
205: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Insert_Row:'||SQLERRM);
206:
207: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
208:
209: END Insert_Row;
244: WHEN OTHERS THEN
245: IF l_debug_level > 0 THEN
246: oe_debug_pub.add( G_PKG_NAME||':DELETE_ROW:'||SQLERRM ) ;
247: END IF;
248: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
249: THEN
250: FND_MSG_PUB.Add_Exc_Msg
251: ( G_PKG_NAME
252: , 'Delete_Row'
246: oe_debug_pub.add( G_PKG_NAME||':DELETE_ROW:'||SQLERRM ) ;
247: END IF;
248: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
249: THEN
250: FND_MSG_PUB.Add_Exc_Msg
251: ( G_PKG_NAME
252: , 'Delete_Row'
253: );
254: END IF;
403: (p_line_id IS NOT NULL
404: AND
405: p_line_id <> FND_API.G_MISS_NUM)
406: THEN
407: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
408: THEN
409: FND_MSG_PUB.Add_Exc_Msg
410: ( G_PKG_NAME
411: , 'Query Rows'
405: p_line_id <> FND_API.G_MISS_NUM)
406: THEN
407: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
408: THEN
409: FND_MSG_PUB.Add_Exc_Msg
410: ( G_PKG_NAME
411: , 'Query Rows'
412: , 'Keys are mutually exclusive: price_adjustment_id = '|| p_price_adjustment_id || ', line_id = '|| p_line_id
413: );
503: WHEN OTHERS THEN
504: IF l_debug_level > 0 THEN
505: oe_debug_pub.add( G_PKG_NAME||':QUERY_ROW:'||SQLERRM ) ;
506: END IF;
507: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
508: THEN
509: FND_MSG_PUB.Add_Exc_Msg
510: ( G_PKG_NAME
511: , 'Query_Rows'
505: oe_debug_pub.add( G_PKG_NAME||':QUERY_ROW:'||SQLERRM ) ;
506: END IF;
507: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
508: THEN
509: FND_MSG_PUB.Add_Exc_Msg
510: ( G_PKG_NAME
511: , 'Query_Rows'
512: );
513: END IF;