DBA Data[Home] [Help]

APPS.QP_PRICE_FORMULA_PUB dependencies on OE_MSG_PUB

Line 98: OE_MSG_PUB.Add;

94: IF l_qp_status = 'S' THEN -- Public API unavailable for Basic Pricing
95:
96: l_return_status := FND_API.G_RET_STS_ERROR;
97: FND_MESSAGE.SET_NAME('QP', 'QP_BASIC_PRICING_UNAVAILABLE');
98: OE_MSG_PUB.Add;
99: RAISE FND_API.G_EXC_ERROR;
100:
101: ELSIF l_qp_status = 'N' THEN
102:

Line 105: OE_MSG_PUB.Add;

101: ELSIF l_qp_status = 'N' THEN
102:
103: l_return_status := FND_API.G_RET_STS_ERROR;
104: FND_MESSAGE.SET_NAME('QP', 'QP_PRICING_NOT_INSTALLED');
105: OE_MSG_PUB.Add;
106: RAISE FND_API.G_EXC_ERROR;
107:
108: END IF;
109:

Line 184: OE_MSG_PUB.Count_And_Get

180: x_return_status := FND_API.G_RET_STS_ERROR;
181:
182: -- Get message count and data
183:
184: OE_MSG_PUB.Count_And_Get
185: ( p_count => x_msg_count
186: , p_data => x_msg_data
187: );
188: --Roll Back the transaction if the return status is not success and it is called from API, bug #5345652

Line 199: OE_MSG_PUB.Count_And_Get

195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
196:
197: -- Get message count and data
198:
199: OE_MSG_PUB.Count_And_Get
200: ( p_count => x_msg_count
201: , p_data => x_msg_data
202: );
203: --Roll Back the transaction if the return status is not success and it is called from API, bug #5345652

Line 212: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

208: WHEN OTHERS THEN
209:
210: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
211:
212: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
213: THEN
214: OE_MSG_PUB.Add_Exc_Msg
215: ( G_PKG_NAME
216: , 'Process_Price_Formula'

Line 214: OE_MSG_PUB.Add_Exc_Msg

210: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
211:
212: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
213: THEN
214: OE_MSG_PUB.Add_Exc_Msg
215: ( G_PKG_NAME
216: , 'Process_Price_Formula'
217: );
218: END IF;

Line 222: OE_MSG_PUB.Count_And_Get

218: END IF;
219:
220: -- Get message count and data
221:
222: OE_MSG_PUB.Count_And_Get
223: ( p_count => x_msg_count
224: , p_data => x_msg_data
225: );
226: --Roll Back the transaction if the return status is not success and it is called from API, bug #5345652

Line 355: OE_MSG_PUB.Count_And_Get

351: x_return_status := FND_API.G_RET_STS_ERROR;
352:
353: -- Get message count and data
354:
355: OE_MSG_PUB.Count_And_Get
356: ( p_count => x_msg_count
357: , p_data => x_msg_data
358: );
359:

Line 366: OE_MSG_PUB.Count_And_Get

362: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
363:
364: -- Get message count and data
365:
366: OE_MSG_PUB.Count_And_Get
367: ( p_count => x_msg_count
368: , p_data => x_msg_data
369: );
370:

Line 375: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

371: WHEN OTHERS THEN
372:
373: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
374:
375: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
376: THEN
377: OE_MSG_PUB.Add_Exc_Msg
378: ( G_PKG_NAME
379: , 'Lock_Price_Formula'

Line 377: OE_MSG_PUB.Add_Exc_Msg

373: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
374:
375: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
376: THEN
377: OE_MSG_PUB.Add_Exc_Msg
378: ( G_PKG_NAME
379: , 'Lock_Price_Formula'
380: );
381: END IF;

Line 385: OE_MSG_PUB.Count_And_Get

381: END IF;
382:
383: -- Get message count and data
384:
385: OE_MSG_PUB.Count_And_Get
386: ( p_count => x_msg_count
387: , p_data => x_msg_data
388: );
389:

Line 455: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

451: ELSIF p_price_formula_id <> FND_API.G_MISS_NUM THEN
452:
453: l_price_formula_id := p_price_formula_id;
454:
455: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
456: THEN
457:
458: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
459: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_formula');

Line 460: OE_MSG_PUB.Add;

456: THEN
457:
458: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
459: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_formula');
460: OE_MSG_PUB.Add;
461:
462: END IF;
463:
464: ELSE

Line 473: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

469: ( p_price_formula => p_price_formula
470: );
471:
472: IF l_price_formula_id = FND_API.G_MISS_NUM THEN
473: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
474: THEN
475:
476: FND_MESSAGE.SET_NAME('QP','Invalid Business Object Value');
477: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_formula');

Line 478: OE_MSG_PUB.Add;

474: THEN
475:
476: FND_MESSAGE.SET_NAME('QP','Invalid Business Object Value');
477: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_formula');
478: OE_MSG_PUB.Add;
479:
480: END IF;
481: END IF;
482:

Line 525: OE_MSG_PUB.Count_And_Get

521: x_return_status := FND_API.G_RET_STS_SUCCESS;
522:
523: -- Get message count and data
524:
525: OE_MSG_PUB.Count_And_Get
526: ( p_count => x_msg_count
527: , p_data => x_msg_data
528: );
529:

Line 539: OE_MSG_PUB.Count_And_Get

535: x_return_status := FND_API.G_RET_STS_ERROR;
536:
537: -- Get message count and data
538:
539: OE_MSG_PUB.Count_And_Get
540: ( p_count => x_msg_count
541: , p_data => x_msg_data
542: );
543:

Line 550: OE_MSG_PUB.Count_And_Get

546: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
547:
548: -- Get message count and data
549:
550: OE_MSG_PUB.Count_And_Get
551: ( p_count => x_msg_count
552: , p_data => x_msg_data
553: );
554:

Line 559: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

555: WHEN OTHERS THEN
556:
557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
558:
559: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
560: THEN
561: OE_MSG_PUB.Add_Exc_Msg
562: ( G_PKG_NAME
563: , 'Get_Price_Formula'

Line 561: OE_MSG_PUB.Add_Exc_Msg

557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
558:
559: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
560: THEN
561: OE_MSG_PUB.Add_Exc_Msg
562: ( G_PKG_NAME
563: , 'Get_Price_Formula'
564: );
565: END IF;

Line 569: OE_MSG_PUB.Count_And_Get

565: END IF;
566:
567: -- Get message count and data
568:
569: OE_MSG_PUB.Count_And_Get
570: ( p_count => x_msg_count
571: , p_data => x_msg_data
572: );
573:

Line 602: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

598: EXCEPTION
599:
600: WHEN OTHERS THEN
601:
602: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
603: THEN
604: OE_MSG_PUB.Add_Exc_Msg
605: ( G_PKG_NAME
606: , 'Id_To_Value'

Line 604: OE_MSG_PUB.Add_Exc_Msg

600: WHEN OTHERS THEN
601:
602: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
603: THEN
604: OE_MSG_PUB.Add_Exc_Msg
605: ( G_PKG_NAME
606: , 'Id_To_Value'
607: );
608: END IF;

Line 675: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

671: EXCEPTION
672:
673: WHEN OTHERS THEN
674:
675: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
676: THEN
677: OE_MSG_PUB.Add_Exc_Msg
678: ( G_PKG_NAME
679: , 'Value_To_Id'

Line 677: OE_MSG_PUB.Add_Exc_Msg

673: WHEN OTHERS THEN
674:
675: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
676: THEN
677: OE_MSG_PUB.Add_Exc_Msg
678: ( G_PKG_NAME
679: , 'Value_To_Id'
680: );
681: END IF;