DBA Data[Home] [Help]

APPS.OE_PRICE_LIST_PVT dependencies on FND_MSG_PUB

Line 102: FND_MSG_PUB.initialize;

98: -- Initialize message list if p_init_msg_list is set to TRUE
99:
100: IF FND_API.to_Boolean(p_init_msg_list) THEN
101:
102: FND_MSG_PUB.initialize;
103:
104: END IF;
105:
106: -- Initialize p_return_status

Line 121: FND_MSG_PUB.Add;

117:
118: FND_MESSAGE.SET_NAME('OE','OE_PRC_LIST_INVALID_FETCH_ATTEMPTS');
119: FND_MESSAGE.SET_TOKEN('PASSED_FETCH_ATTEMPTS',p_fetch_attempts);
120: FND_MESSAGE.SET_TOKEN('MAX_FETCH_ATTEMPTS',G_PRC_LST_MAX_ATTEMPTS);
121: FND_MSG_PUB.Add;
122:
123: END IF;
124:
125: -- Validation that can be turned off through the use of

Line 189: FND_MSG_PUB.Add_Exc_Msg

185: IF p_pricing_attribute2 IS NULL THEN
186:
187: -- Debug info
188: /*
189: FND_MSG_PUB.Add_Exc_Msg
190: ( p_error_text => 'pricing_attribute2 is null' );
191: */
192: -- Fecth driving on item_id
193:

Line 325: FND_MSG_PUB.Add_Exc_Msg

321: ELSE
322:
323: -- Debug info
324: /*
325: FND_MSG_PUB.Add_Exc_Msg
326: ( p_error_text => 'list price is not null - '||
327: ' list_price = '||l_list_price||
328: ' l_prc_method_code = '||l_prc_method_code_out||
329: ' l_rounding_factor = '||l_rounding_factor

Line 370: IF FND_MSG_PUB.Check_Msg_Level (

366: ELSE
367:
368: -- Unexpected error, invalid pricing method
369:
370: IF FND_MSG_PUB.Check_Msg_Level (
371: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
372: THEN
373:
374: FND_MSG_PUB.Add_Exc_Msg

Line 371: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

367:
368: -- Unexpected error, invalid pricing method
369:
370: IF FND_MSG_PUB.Check_Msg_Level (
371: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
372: THEN
373:
374: FND_MSG_PUB.Add_Exc_Msg
375: ( G_PKG_NAME ,

Line 374: FND_MSG_PUB.Add_Exc_Msg

370: IF FND_MSG_PUB.Check_Msg_Level (
371: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
372: THEN
373:
374: FND_MSG_PUB.Add_Exc_Msg
375: ( G_PKG_NAME ,
376: l_api_name ,
377: 'Invalid pricing method ='||l_prc_method_code_out
378: );

Line 400: FND_MSG_PUB.Add_Exc_Msg

396: WHEN NO_DATA_FOUND THEN
397:
398: -- Debug info
399: /*
400: FND_MSG_PUB.Add_Exc_Msg
401: ( p_error_text => 'Primary fetch not successful' );
402: */
403: -- Check if the maximum number of attempts has been
404: -- exceeded. When l_fetch attempts is 1 this means there

Line 485: IF FND_MSG_PUB.Check_Msg_Level(

481: WHEN OTHERS THEN
482:
483: -- Unexpected error
484:
485: IF FND_MSG_PUB.Check_Msg_Level(
486: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
487: THEN
488:
489: FND_MSG_PUB.Add_Exc_Msg

Line 486: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

482:
483: -- Unexpected error
484:
485: IF FND_MSG_PUB.Check_Msg_Level(
486: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
487: THEN
488:
489: FND_MSG_PUB.Add_Exc_Msg
490: ( G_PKG_NAME ,

Line 489: FND_MSG_PUB.Add_Exc_Msg

485: IF FND_MSG_PUB.Check_Msg_Level(
486: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
487: THEN
488:
489: FND_MSG_PUB.Add_Exc_Msg
490: ( G_PKG_NAME ,
491: l_api_name
492: );
493:

Line 510: FND_MSG_PUB.Add_Exc_Msg

506: -- not found o the price list.
507:
508: -- Debug info
509: /*
510: FND_MSG_PUB.Add_Exc_Msg
511: ( p_error_text => 'End of Fetch_List_Price - '||
512: ' l_list_price = '||l_list_price||
513: ' G_Fetch_Level = '||G_Fetch_Level
514: );

Line 521: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)

517: IF l_list_price IS NULL AND
518: G_Fetch_Level = 1
519: THEN
520:
521: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
522: THEN
523:
524: FND_MESSAGE.SET_NAME('OE','OE_PRC_NO_LIST_PRICE');
525: FND_MESSAGE.SET_TOKEN('PRICE_LIST', Get_Price_List_Name

Line 530: FND_MSG_PUB.Add;

526: (p_price_list_id) );
527: FND_MESSAGE.SET_TOKEN('ITEM', Get_Item_Description
528: (p_inventory_item_id) );
529: FND_MESSAGE.SET_TOKEN('UNTI',Get_Unit_Name (p_unit_code ));
530: FND_MSG_PUB.Add;
531:
532: END IF;
533:
534: END IF;

Line 542: FND_MSG_PUB.Count_And_Get

538: G_Fetch_Level := G_Fetch_Level - 1;
539:
540: -- Get message count and if 1, return message data
541:
542: FND_MSG_PUB.Count_And_Get
543: ( p_count => p_msg_count ,
544: p_data => p_msg_data
545: );
546:

Line 556: FND_MSG_PUB.Count_And_Get

552: p_return_status := FND_API.G_RET_STS_ERROR;
553:
554: -- Get message count and if 1, return message data
555:
556: FND_MSG_PUB.Count_And_Get
557: (p_count => p_msg_count,
558: p_data => p_msg_data
559: );
560:

Line 571: FND_MSG_PUB.Count_And_Get

567: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
568:
569: -- Get message count and if 1, return message data
570:
571: FND_MSG_PUB.Count_And_Get
572: (p_count => p_msg_count,
573: p_data => p_msg_data
574: );
575:

Line 584: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

580: WHEN OTHERS THEN
581:
582: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
583:
584: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
585: FND_MSG_PUB.Add_Exc_Msg
586: ( G_PKG_NAME ,
587: l_api_name
588: );

Line 585: FND_MSG_PUB.Add_Exc_Msg

581:
582: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
583:
584: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
585: FND_MSG_PUB.Add_Exc_Msg
586: ( G_PKG_NAME ,
587: l_api_name
588: );
589: END IF;

Line 593: FND_MSG_PUB.Count_And_Get

589: END IF;
590:
591: -- Get message count and if 1, return message data
592:
593: FND_MSG_PUB.Count_And_Get
594: ( p_count => p_msg_count,
595: p_data => p_msg_data
596: );
597:

Line 628: FND_MSG_PUB.Add_Exc_Msg

624: EXCEPTION
625:
626: WHEN OTHERS THEN
627:
628: FND_MSG_PUB.Add_Exc_Msg
629: ( G_PKG_NAME ,
630: 'Get_Sec_Price_List - p_price_list_id = '||p_price_list_id
631: );
632:

Line 659: FND_MSG_PUB.Add_Exc_Msg

655: EXCEPTION
656:
657: WHEN OTHERS THEN
658:
659: FND_MSG_PUB.Add_Exc_Msg
660: ( G_PKG_NAME ,
661: 'Get_Price_List_Name - p_price_list_id = '||p_price_list_id
662: );
663:

Line 696: FND_MSG_PUB.Add_Exc_Msg

692: EXCEPTION
693:
694: WHEN OTHERS THEN
695:
696: FND_MSG_PUB.Add_Exc_Msg
697: ( G_PKG_NAME ,
698: 'Get_Item_Description - p_item_id = '||p_item_id||
699: ' org_id ='||l_org_id
700: );

Line 728: FND_MSG_PUB.Add_Exc_Msg

724: EXCEPTION
725:
726: WHEN OTHERS THEN
727:
728: FND_MSG_PUB.Add_Exc_Msg
729: ( G_PKG_NAME ,
730: 'Get_Unit_Name - p_unit_code = '||p_unit_code
731: );
732: