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 247: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

243: WHEN OTHERS THEN
244: IF l_debug_level > 0 THEN
245: oe_debug_pub.add( G_PKG_NAME||':DELETE_ROW:'||SQLERRM ) ;
246: END IF;
247: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
248: THEN
249: FND_MSG_PUB.Add_Exc_Msg
250: ( G_PKG_NAME
251: , 'Delete_Row'

Line 249: FND_MSG_PUB.Add_Exc_Msg

245: oe_debug_pub.add( G_PKG_NAME||':DELETE_ROW:'||SQLERRM ) ;
246: END IF;
247: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
248: THEN
249: FND_MSG_PUB.Add_Exc_Msg
250: ( G_PKG_NAME
251: , 'Delete_Row'
252: );
253: END IF;

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

402: (p_line_id IS NOT NULL
403: AND
404: p_line_id <> FND_API.G_MISS_NUM)
405: THEN
406: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
407: THEN
408: FND_MSG_PUB.Add_Exc_Msg
409: ( G_PKG_NAME
410: , 'Query Rows'

Line 408: FND_MSG_PUB.Add_Exc_Msg

404: p_line_id <> FND_API.G_MISS_NUM)
405: THEN
406: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
407: THEN
408: FND_MSG_PUB.Add_Exc_Msg
409: ( G_PKG_NAME
410: , 'Query Rows'
411: , 'Keys are mutually exclusive: price_adjustment_id = '|| p_price_adjustment_id || ', line_id = '|| p_line_id
412: );

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

502: WHEN OTHERS THEN
503: IF l_debug_level > 0 THEN
504: oe_debug_pub.add( G_PKG_NAME||':QUERY_ROW:'||SQLERRM ) ;
505: END IF;
506: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
507: THEN
508: FND_MSG_PUB.Add_Exc_Msg
509: ( G_PKG_NAME
510: , 'Query_Rows'

Line 508: FND_MSG_PUB.Add_Exc_Msg

504: oe_debug_pub.add( G_PKG_NAME||':QUERY_ROW:'||SQLERRM ) ;
505: END IF;
506: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
507: THEN
508: FND_MSG_PUB.Add_Exc_Msg
509: ( G_PKG_NAME
510: , 'Query_Rows'
511: );
512: END IF;