DBA Data[Home] [Help]

APPS.OE_PAYMENTS_UTIL dependencies on FND_MSG_PUB

Line 61: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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'

Line 63: FND_MSG_PUB.Add_Exc_Msg

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;

Line 181: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

Line 183: FND_MSG_PUB.Add_Exc_Msg

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;

Line 189: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Insert_Row:'||SQLERRM);

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

Line 197: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

Line 199: FND_MSG_PUB.Add_Exc_Msg

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;

Line 205: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Insert_Row:'||SQLERRM);

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;

Line 248: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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'

Line 250: FND_MSG_PUB.Add_Exc_Msg

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;

Line 407: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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'

Line 409: FND_MSG_PUB.Add_Exc_Msg

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

Line 507: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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'

Line 509: FND_MSG_PUB.Add_Exc_Msg

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;