DBA Data[Home] [Help]

APPS.OE_RELATED_ITEMS_PVT dependencies on OE_MSG_PUB

Line 305: OE_MSG_PUB.Count_And_Get

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

Line 316: OE_MSG_PUB.Count_And_Get

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

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

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

Line 327: OE_MSG_PUB.Add_Exc_Msg

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

Line 335: OE_MSG_PUB.Count_And_Get

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

Line 595: OE_MSG_PUB.Count_And_Get

591: END IF;
592: x_return_status := 'E';
593: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
594: -- Get message count and data
595: OE_MSG_PUB.Count_And_Get
596: ( p_count => x_msg_count
597: , p_data => x_msg_data
598: );
599:

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

596: ( p_count => x_msg_count
597: , p_data => x_msg_data
598: );
599:
600: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
601: OE_MSG_PUB.Add_Exc_Msg
602: ( G_PKG_NAME,
603: 'Call_MRP_ATP');
604: END IF;

Line 601: OE_MSG_PUB.Add_Exc_Msg

597: , p_data => x_msg_data
598: );
599:
600: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
601: OE_MSG_PUB.Add_Exc_Msg
602: ( G_PKG_NAME,
603: 'Call_MRP_ATP');
604: END IF;
605:

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

631: EXCEPTION
632:
633: WHEN OTHERS THEN
634:
635: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
636: OE_MSG_PUB.Add_Exc_Msg
637: ( G_PKG_NAME,
638: 'Initialize_mrp_record');
639: END IF;

Line 636: OE_MSG_PUB.Add_Exc_Msg

632:
633: WHEN OTHERS THEN
634:
635: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
636: OE_MSG_PUB.Add_Exc_Msg
637: ( G_PKG_NAME,
638: 'Initialize_mrp_record');
639: END IF;
640:

Line 697: OE_MSG_PUB.Add;

693: --FND_MESSAGE.SET_NAME('ONT','OE_SCH_NO_SOURCE');
694: IF p_global_orgs = 'N' then
695:
696: FND_MESSAGE.SET_NAME('ONT','ONT_AVAIL_NO_SOURCES');
697: OE_MSG_PUB.Add;
698: ELSE
699: x_error_message := l_explanation;
700: END IF;
701:

Line 749: OE_MSG_PUB.Add;

745:
746: IF p_global_orgs = 'N' then
747: FND_MESSAGE.SET_NAME('ONT','ONT_INLNE_CUSTOMER');
748: FND_MESSAGE.SET_TOKEN('TEXT',l_explanation);
749: OE_MSG_PUB.Add;
750: ELSE
751: x_error_message := l_explanation;
752: END IF;
753:

Line 808: OE_MSG_PUB.add_text(l_explanation);

804: END IF;
805: x_error_message := l_explanation;
806:
807: IF p_atp_rec.error_code(J) = 150 THEN
808: OE_MSG_PUB.add_text(l_explanation);
809: END IF;
810:
811: EXCEPTION
812: WHEN OTHERS THEN

Line 825: --OE_MSG_PUB.Add;

821:
822: -- umcomment for testing the error handling
823: --x_return_status := 'E';
824: --FND_MESSAGE.SET_NAME('ONT','OE_SCH_NO_SOURCE');
825: --OE_MSG_PUB.Add;
826:
827: IF x_return_status ='E' and p_global_orgs = 'N' then
828: IF l_debug_level > 0 THEN
829: oe_debug_pub.add( 'DOING COUNT_AND_GET' ) ;

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

827: IF x_return_status ='E' and p_global_orgs = 'N' then
828: IF l_debug_level > 0 THEN
829: oe_debug_pub.add( 'DOING COUNT_AND_GET' ) ;
830: END IF;
831: oe_msg_pub.count_and_get(p_encoded=>fnd_api.G_TRUE,
832: p_count => x_msg_count,
833: p_data=>x_msg_data
834: );
835: IF l_debug_level > 0 THEN

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

842: END IF;
843:
844: EXCEPTION
845: WHEN OTHERS THEN
846: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
847: THEN
848: OE_MSG_PUB.Add_Exc_Msg
849: ( G_PKG_NAME
850: , 'Check_Results'

Line 848: OE_MSG_PUB.Add_Exc_Msg

844: EXCEPTION
845: WHEN OTHERS THEN
846: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
847: THEN
848: OE_MSG_PUB.Add_Exc_Msg
849: ( G_PKG_NAME
850: , 'Check_Results'
851: );
852: END IF;

Line 3158: OE_MSG_PUB.Add;

3154: FND_MESSAGE.SET_TOKEN('TEXT',in_status_text);
3155: IF l_debug_level > 0 THEN
3156: oe_debug_pub.add( 'INVALID PL ERR TXT='||IN_STATUS_TEXT ) ;
3157: END IF;
3158: OE_MSG_PUB.Add;
3159:
3160: ELSE
3161: IF l_debug_level > 0 THEN
3162: oe_debug_pub.add( 'INVALID PRICE LIST' ) ;

Line 3168: OE_MSG_PUB.Add;

3164: FND_MESSAGE.SET_NAME('ONT','OE_PRC_NO_LIST_PRICE');
3165: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
3166: FND_MESSAGE.SET_TOKEN('UNIT',in_uom);
3167: FND_MESSAGE.SET_TOKEN('PRICE_LIST',l_Price_List);
3168: OE_MSG_PUB.Add;
3169:
3170: END IF;
3171:
3172: ELSIF in_status_code = QP_PREQ_GRP.G_STS_LHS_NOT_FOUND Then

Line 3177: OE_MSG_PUB.Add;

3173:
3174: FND_MESSAGE.SET_NAME('ONT','ONT_NO_PRICE_LIST_FOUND');
3175: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
3176: FND_MESSAGE.SET_TOKEN('UOM',in_uom);
3177: OE_MSG_PUB.Add;
3178:
3179: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_FORMULA_ERROR then
3180: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_ERROR_IN_FORMULA');
3181: OE_MSG_PUB.Add;

Line 3181: OE_MSG_PUB.Add;

3177: OE_MSG_PUB.Add;
3178:
3179: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_FORMULA_ERROR then
3180: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_ERROR_IN_FORMULA');
3181: OE_MSG_PUB.Add;
3182:
3183: ELSIF in_status_code in
3184: ( QP_PREQ_GRP.G_STATUS_OTHER_ERRORS , FND_API.G_RET_STS_UNEXP_ERROR,
3185: FND_API.G_RET_STS_ERROR) then

Line 3188: OE_MSG_PUB.Add;

3184: ( QP_PREQ_GRP.G_STATUS_OTHER_ERRORS , FND_API.G_RET_STS_UNEXP_ERROR,
3185: FND_API.G_RET_STS_ERROR) then
3186: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS');
3187: FND_MESSAGE.SET_TOKEN('ERR_TEXT',in_status_text);
3188: OE_MSG_PUB.Add;
3189:
3190: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM then
3191: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM');
3192: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);

Line 3194: OE_MSG_PUB.Add;

3190: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM then
3191: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM');
3192: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
3193: FND_MESSAGE.SET_TOKEN('UOM',in_uom);
3194: OE_MSG_PUB.Add;
3195:
3196: ElSIF in_status_code = QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST then
3197: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_DUPLICATE_PRICE_LIST');
3198:

Line 3238: OE_MSG_PUB.Add;

3234: oe_debug_pub.add( 'PRICE LIST 2='||L_PRICE_LIST ) ;
3235: END IF;
3236:
3237: FND_MESSAGE.SET_TOKEN('PRICE_LIST2',l_price_list);
3238: OE_MSG_PUB.Add;
3239:
3240: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV then
3241: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM_CONVERSION');
3242: FND_MESSAGE.SET_TOKEN('UOM_TEXT','( '||in_Ordered_Item||' ) '||

Line 3244: OE_MSG_PUB.Add;

3240: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV then
3241: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM_CONVERSION');
3242: FND_MESSAGE.SET_TOKEN('UOM_TEXT','( '||in_Ordered_Item||' ) '||
3243: in_status_text);
3244: OE_MSG_PUB.Add;
3245:
3246: ElSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_INCOMP then
3247: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_INCOMP');
3248: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '||in_Ordered_Item||' ) '||

Line 3250: OE_MSG_PUB.Add;

3246: ElSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_INCOMP then
3247: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_INCOMP');
3248: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '||in_Ordered_Item||' ) '||
3249: in_status_text);
3250: OE_MSG_PUB.Add;
3251:
3252: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR then
3253: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_BEST_PRICE_ERROR');
3254: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);

Line 3256: OE_MSG_PUB.Add;

3252: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR then
3253: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_BEST_PRICE_ERROR');
3254: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
3255: FND_MESSAGE.SET_TOKEN('ERR_TEXT',in_status_text);
3256: OE_MSG_PUB.Add;
3257: END IF;
3258:
3259:
3260: /*elsif ( in_unit_price < 0 or in_Adjusted_unit_price < 0) and

Line 3268: OE_MSG_PUB.Add;

3264: FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_PRICE');
3265: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
3266: FND_MESSAGE.SET_TOKEN('LIST_PRICE',in_unit_price);
3267: FND_MESSAGE.SET_TOKEN('SELLING_PRICE',in_Adjusted_unit_price);
3268: OE_MSG_PUB.Add;
3269: --FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_MODIFIERS');
3270: --FND_MESSAGE.SET_TOKEN('LIST_LINE_NO',get_list_lines(g_line_id));
3271: --OE_MSG_PUB.Add;
3272: l_return_status := 'E';

Line 3271: --OE_MSG_PUB.Add;

3267: FND_MESSAGE.SET_TOKEN('SELLING_PRICE',in_Adjusted_unit_price);
3268: OE_MSG_PUB.Add;
3269: --FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_MODIFIERS');
3270: --FND_MESSAGE.SET_TOKEN('LIST_LINE_NO',get_list_lines(g_line_id));
3271: --OE_MSG_PUB.Add;
3272: l_return_status := 'E';
3273: --RAISE FND_API.G_EXC_ERROR;*/
3274:
3275: ELSIF in_line_Type_code ='LINE' and

Line 3283: OE_MSG_PUB.Add;

3279: oe_debug_pub.add( 'OE_PRICING_ERROR' ) ;
3280: END IF;
3281: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
3282: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '||in_Ordered_Item||' ) '||in_STATUS_TEXT);
3283: OE_MSG_PUB.Add;
3284:
3285: ELSIF in_line_Type_code ='LINE' and in_status_code in
3286: --( QP_PREQ_GRP.G_STATUS_UPDATED,
3287: (QP_PREQ_GRP.G_STATUS_GSA_VIOLATION) and

Line 3305: OE_MSG_PUB.Add;

3301: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
3302: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '||in_Ordered_Item||' ) '||in_STATUS_TEXT);
3303: --FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS');
3304: --FND_MESSAGE.SET_TOKEN('ERR_TEXT',in_status_text);
3305: OE_MSG_PUB.Add;
3306: END IF;
3307:
3308: -- we need to do this check in UPDATED code or do the gsa check through
3309: -- the control record of Pricing

Line 3341: OE_MSG_PUB.Add;

3337: oe_debug_pub.add('GSA warning or error 2 msg_Text='||l_msg_text);
3338: FND_MESSAGE.SET_NAME('ONT','OE_GSA_VIOLATION');
3339: l_msg_text := l_operand||' ( '||l_msg_text||' )';
3340: FND_MESSAGE.SET_TOKEN('GSA_PRICE',l_msg_text);
3341: OE_MSG_PUB.Add;
3342: END IF;
3343: END IF; */
3344:
3345:

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

3374: IF l_return_status ='E' then
3375: IF l_debug_level > 0 THEN
3376: oe_debug_pub.add( 'DOING COUNT_AND_GET' ) ;
3377: END IF;
3378: oe_msg_pub.count_and_get(p_encoded=>fnd_api.G_TRUE,
3379: p_count => l_msg_count,
3380: p_data=>l_msg_data
3381: );
3382: END IF;