DBA Data[Home] [Help]

APPS.OE_RELATED_ITEMS_PVT dependencies on OE_MSG_PUB

Line 303: OE_MSG_PUB.Count_And_Get

299: x_return_status := FND_API.G_RET_STS_ERROR;
300:
301: -- Get message count and data
302:
303: OE_MSG_PUB.Count_And_Get
304: ( p_count => x_msg_count
305: , p_data => x_msg_data
306: );
307:

Line 314: OE_MSG_PUB.Count_And_Get

310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
311:
312: -- Get message count and data
313:
314: OE_MSG_PUB.Count_And_Get
315: ( p_count => x_msg_count
316: , p_data => x_msg_data
317: );
318:

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

319: WHEN OTHERS THEN
320:
321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
322:
323: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
324: THEN
325: OE_MSG_PUB.Add_Exc_Msg
326: ( G_PKG_NAME
327: , 'defaulting'

Line 325: OE_MSG_PUB.Add_Exc_Msg

321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
322:
323: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
324: THEN
325: OE_MSG_PUB.Add_Exc_Msg
326: ( G_PKG_NAME
327: , 'defaulting'
328: );
329: END IF;

Line 333: OE_MSG_PUB.Count_And_Get

329: END IF;
330:
331: -- Get message count and data
332:
333: OE_MSG_PUB.Count_And_Get
334: ( p_count => x_msg_count
335: , p_data => x_msg_data
336: );
337:

Line 562: OE_MSG_PUB.Count_And_Get

558: END IF;
559: x_return_status := 'E';
560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
561: -- Get message count and data
562: OE_MSG_PUB.Count_And_Get
563: ( p_count => x_msg_count
564: , p_data => x_msg_data
565: );
566:

Line 567: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

563: ( p_count => x_msg_count
564: , p_data => x_msg_data
565: );
566:
567: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
568: OE_MSG_PUB.Add_Exc_Msg
569: ( G_PKG_NAME,
570: 'Call_MRP_ATP');
571: END IF;

Line 568: OE_MSG_PUB.Add_Exc_Msg

564: , p_data => x_msg_data
565: );
566:
567: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
568: OE_MSG_PUB.Add_Exc_Msg
569: ( G_PKG_NAME,
570: 'Call_MRP_ATP');
571: END IF;
572:

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

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

Line 603: OE_MSG_PUB.Add_Exc_Msg

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

Line 664: OE_MSG_PUB.Add;

660: --FND_MESSAGE.SET_NAME('ONT','OE_SCH_NO_SOURCE');
661: IF p_global_orgs = 'N' then
662:
663: FND_MESSAGE.SET_NAME('ONT','ONT_AVAIL_NO_SOURCES');
664: OE_MSG_PUB.Add;
665: ELSE
666: x_error_message := l_explanation;
667: END IF;
668:

Line 716: OE_MSG_PUB.Add;

712:
713: IF p_global_orgs = 'N' then
714: FND_MESSAGE.SET_NAME('ONT','ONT_INLNE_CUSTOMER');
715: FND_MESSAGE.SET_TOKEN('TEXT',l_explanation);
716: OE_MSG_PUB.Add;
717: ELSE
718: x_error_message := l_explanation;
719: END IF;
720:

Line 775: OE_MSG_PUB.add_text(l_explanation);

771: END IF;
772: x_error_message := l_explanation;
773:
774: IF p_atp_rec.error_code(J) = 150 THEN
775: OE_MSG_PUB.add_text(l_explanation);
776: END IF;
777:
778: EXCEPTION
779: WHEN OTHERS THEN

Line 792: --OE_MSG_PUB.Add;

788:
789: -- umcomment for testing the error handling
790: --x_return_status := 'E';
791: --FND_MESSAGE.SET_NAME('ONT','OE_SCH_NO_SOURCE');
792: --OE_MSG_PUB.Add;
793:
794: IF x_return_status ='E' and p_global_orgs = 'N' then
795: IF l_debug_level > 0 THEN
796: oe_debug_pub.add( 'DOING COUNT_AND_GET' ) ;

Line 798: oe_msg_pub.count_and_get(p_encoded=>fnd_api.G_TRUE,

794: IF x_return_status ='E' and p_global_orgs = 'N' then
795: IF l_debug_level > 0 THEN
796: oe_debug_pub.add( 'DOING COUNT_AND_GET' ) ;
797: END IF;
798: oe_msg_pub.count_and_get(p_encoded=>fnd_api.G_TRUE,
799: p_count => x_msg_count,
800: p_data=>x_msg_data
801: );
802: IF l_debug_level > 0 THEN

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

809: END IF;
810:
811: EXCEPTION
812: WHEN OTHERS THEN
813: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
814: THEN
815: OE_MSG_PUB.Add_Exc_Msg
816: ( G_PKG_NAME
817: , 'Check_Results'

Line 815: OE_MSG_PUB.Add_Exc_Msg

811: EXCEPTION
812: WHEN OTHERS THEN
813: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
814: THEN
815: OE_MSG_PUB.Add_Exc_Msg
816: ( G_PKG_NAME
817: , 'Check_Results'
818: );
819: END IF;

Line 3124: OE_MSG_PUB.Add;

3120: FND_MESSAGE.SET_TOKEN('TEXT',in_status_text);
3121: IF l_debug_level > 0 THEN
3122: oe_debug_pub.add( 'INVALID PL ERR TXT='||IN_STATUS_TEXT ) ;
3123: END IF;
3124: OE_MSG_PUB.Add;
3125:
3126: ELSE
3127: IF l_debug_level > 0 THEN
3128: oe_debug_pub.add( 'INVALID PRICE LIST' ) ;

Line 3134: OE_MSG_PUB.Add;

3130: FND_MESSAGE.SET_NAME('ONT','OE_PRC_NO_LIST_PRICE');
3131: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
3132: FND_MESSAGE.SET_TOKEN('UNIT',in_uom);
3133: FND_MESSAGE.SET_TOKEN('PRICE_LIST',l_Price_List);
3134: OE_MSG_PUB.Add;
3135:
3136: END IF;
3137:
3138: ELSIF in_status_code = QP_PREQ_GRP.G_STS_LHS_NOT_FOUND Then

Line 3143: OE_MSG_PUB.Add;

3139:
3140: FND_MESSAGE.SET_NAME('ONT','ONT_NO_PRICE_LIST_FOUND');
3141: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
3142: FND_MESSAGE.SET_TOKEN('UOM',in_uom);
3143: OE_MSG_PUB.Add;
3144:
3145: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_FORMULA_ERROR then
3146: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_ERROR_IN_FORMULA');
3147: OE_MSG_PUB.Add;

Line 3147: OE_MSG_PUB.Add;

3143: OE_MSG_PUB.Add;
3144:
3145: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_FORMULA_ERROR then
3146: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_ERROR_IN_FORMULA');
3147: OE_MSG_PUB.Add;
3148:
3149: ELSIF in_status_code in
3150: ( QP_PREQ_GRP.G_STATUS_OTHER_ERRORS , FND_API.G_RET_STS_UNEXP_ERROR,
3151: FND_API.G_RET_STS_ERROR) then

Line 3154: OE_MSG_PUB.Add;

3150: ( QP_PREQ_GRP.G_STATUS_OTHER_ERRORS , FND_API.G_RET_STS_UNEXP_ERROR,
3151: FND_API.G_RET_STS_ERROR) then
3152: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS');
3153: FND_MESSAGE.SET_TOKEN('ERR_TEXT',in_status_text);
3154: OE_MSG_PUB.Add;
3155:
3156: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM then
3157: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM');
3158: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);

Line 3160: OE_MSG_PUB.Add;

3156: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM then
3157: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM');
3158: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
3159: FND_MESSAGE.SET_TOKEN('UOM',in_uom);
3160: OE_MSG_PUB.Add;
3161:
3162: ElSIF in_status_code = QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST then
3163: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_DUPLICATE_PRICE_LIST');
3164:

Line 3204: OE_MSG_PUB.Add;

3200: oe_debug_pub.add( 'PRICE LIST 2='||L_PRICE_LIST ) ;
3201: END IF;
3202:
3203: FND_MESSAGE.SET_TOKEN('PRICE_LIST2',l_price_list);
3204: OE_MSG_PUB.Add;
3205:
3206: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV then
3207: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM_CONVERSION');
3208: FND_MESSAGE.SET_TOKEN('UOM_TEXT','( '||in_Ordered_Item||' ) '||

Line 3210: OE_MSG_PUB.Add;

3206: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV then
3207: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM_CONVERSION');
3208: FND_MESSAGE.SET_TOKEN('UOM_TEXT','( '||in_Ordered_Item||' ) '||
3209: in_status_text);
3210: OE_MSG_PUB.Add;
3211:
3212: ElSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_INCOMP then
3213: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_INCOMP');
3214: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '||in_Ordered_Item||' ) '||

Line 3216: OE_MSG_PUB.Add;

3212: ElSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_INCOMP then
3213: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_INCOMP');
3214: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '||in_Ordered_Item||' ) '||
3215: in_status_text);
3216: OE_MSG_PUB.Add;
3217:
3218: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR then
3219: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_BEST_PRICE_ERROR');
3220: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);

Line 3222: OE_MSG_PUB.Add;

3218: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR then
3219: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_BEST_PRICE_ERROR');
3220: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
3221: FND_MESSAGE.SET_TOKEN('ERR_TEXT',in_status_text);
3222: OE_MSG_PUB.Add;
3223: END IF;
3224:
3225:
3226: /*elsif ( in_unit_price < 0 or in_Adjusted_unit_price < 0) and

Line 3234: OE_MSG_PUB.Add;

3230: FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_PRICE');
3231: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
3232: FND_MESSAGE.SET_TOKEN('LIST_PRICE',in_unit_price);
3233: FND_MESSAGE.SET_TOKEN('SELLING_PRICE',in_Adjusted_unit_price);
3234: OE_MSG_PUB.Add;
3235: --FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_MODIFIERS');
3236: --FND_MESSAGE.SET_TOKEN('LIST_LINE_NO',get_list_lines(g_line_id));
3237: --OE_MSG_PUB.Add;
3238: l_return_status := 'E';

Line 3237: --OE_MSG_PUB.Add;

3233: FND_MESSAGE.SET_TOKEN('SELLING_PRICE',in_Adjusted_unit_price);
3234: OE_MSG_PUB.Add;
3235: --FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_MODIFIERS');
3236: --FND_MESSAGE.SET_TOKEN('LIST_LINE_NO',get_list_lines(g_line_id));
3237: --OE_MSG_PUB.Add;
3238: l_return_status := 'E';
3239: --RAISE FND_API.G_EXC_ERROR;*/
3240:
3241: ELSIF in_line_Type_code ='LINE' and

Line 3249: OE_MSG_PUB.Add;

3245: oe_debug_pub.add( 'OE_PRICING_ERROR' ) ;
3246: END IF;
3247: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
3248: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '||in_Ordered_Item||' ) '||in_STATUS_TEXT);
3249: OE_MSG_PUB.Add;
3250:
3251: ELSIF in_line_Type_code ='LINE' and in_status_code in
3252: --( QP_PREQ_GRP.G_STATUS_UPDATED,
3253: (QP_PREQ_GRP.G_STATUS_GSA_VIOLATION) and

Line 3271: OE_MSG_PUB.Add;

3267: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
3268: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '||in_Ordered_Item||' ) '||in_STATUS_TEXT);
3269: --FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS');
3270: --FND_MESSAGE.SET_TOKEN('ERR_TEXT',in_status_text);
3271: OE_MSG_PUB.Add;
3272: END IF;
3273:
3274: -- we need to do this check in UPDATED code or do the gsa check through
3275: -- the control record of Pricing

Line 3307: OE_MSG_PUB.Add;

3303: oe_debug_pub.add('GSA warning or error 2 msg_Text='||l_msg_text);
3304: FND_MESSAGE.SET_NAME('ONT','OE_GSA_VIOLATION');
3305: l_msg_text := l_operand||' ( '||l_msg_text||' )';
3306: FND_MESSAGE.SET_TOKEN('GSA_PRICE',l_msg_text);
3307: OE_MSG_PUB.Add;
3308: END IF;
3309: END IF; */
3310:
3311:

Line 3344: oe_msg_pub.count_and_get(p_encoded=>fnd_api.G_TRUE,

3340: IF l_return_status ='E' then
3341: IF l_debug_level > 0 THEN
3342: oe_debug_pub.add( 'DOING COUNT_AND_GET' ) ;
3343: END IF;
3344: oe_msg_pub.count_and_get(p_encoded=>fnd_api.G_TRUE,
3345: p_count => l_msg_count,
3346: p_data=>l_msg_data
3347: );
3348: END IF;