689:
690: IF l_debug_level > 0 THEN
691: oe_debug_pub.add( 'SETTING THE MESSAGE FOR OE_SCH_NO_SOURCE' ) ;
692: END IF;
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;
692: END IF;
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;
739: ELSE
740: IF l_debug_level > 0 THEN
741: oe_debug_pub.add( 'ADDING MESSAGE TO THE STACK' , 1 ) ;
742: END IF;
743: --FND_MESSAGE.SET_NAME('ONT','OE_SCH_OE_ORDER_FAILED');
744: --FND_MESSAGE.SET_TOKEN('EXPLANATION',l_explanation);
745:
746: IF p_global_orgs = 'N' then
747: FND_MESSAGE.SET_NAME('ONT','ONT_INLNE_CUSTOMER');
740: IF l_debug_level > 0 THEN
741: oe_debug_pub.add( 'ADDING MESSAGE TO THE STACK' , 1 ) ;
742: END IF;
743: --FND_MESSAGE.SET_NAME('ONT','OE_SCH_OE_ORDER_FAILED');
744: --FND_MESSAGE.SET_TOKEN('EXPLANATION',l_explanation);
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);
743: --FND_MESSAGE.SET_NAME('ONT','OE_SCH_OE_ORDER_FAILED');
744: --FND_MESSAGE.SET_TOKEN('EXPLANATION',l_explanation);
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;
744: --FND_MESSAGE.SET_TOKEN('EXPLANATION',l_explanation);
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;
820: END IF; -- Main If;
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
3149: oe_debug_pub.add( 'INVALID PRICE LIST'|| ' PRICE_LIST_ID='||G_PRICE_LIST_ID ) ;
3150: END IF;
3151: IF g_price_list_id is null then
3152:
3153: FND_MESSAGE.SET_NAME('ONT','ONT_AVAIL_GENERIC');
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;
3150: END IF;
3151: IF g_price_list_id is null then
3152:
3153: FND_MESSAGE.SET_NAME('ONT','ONT_AVAIL_GENERIC');
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;
3160: ELSE
3161: IF l_debug_level > 0 THEN
3162: oe_debug_pub.add( 'INVALID PRICE LIST' ) ;
3163: END IF;
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;
3161: IF l_debug_level > 0 THEN
3162: oe_debug_pub.add( 'INVALID PRICE LIST' ) ;
3163: END IF;
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:
3162: oe_debug_pub.add( 'INVALID PRICE LIST' ) ;
3163: END IF;
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;
3163: END IF;
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:
3170: END IF;
3171:
3172: ELSIF in_status_code = QP_PREQ_GRP.G_STS_LHS_NOT_FOUND Then
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:
3171:
3172: ELSIF in_status_code = QP_PREQ_GRP.G_STS_LHS_NOT_FOUND Then
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
3172: ELSIF in_status_code = QP_PREQ_GRP.G_STS_LHS_NOT_FOUND Then
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');
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;
3182:
3183: ELSIF in_status_code in
3184: ( QP_PREQ_GRP.G_STATUS_OTHER_ERRORS , FND_API.G_RET_STS_UNEXP_ERROR,
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
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
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
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');
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);
3193: FND_MESSAGE.SET_TOKEN('UOM',in_uom);
3194: OE_MSG_PUB.Add;
3195:
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);
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
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);
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');
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:
3199: IF l_debug_level > 0 THEN
3200: oe_debug_pub.add( 'DUPLICATE PRICE LIST ERROR' ) ;
3201: END IF;
3215:
3216: IF l_debug_level > 0 THEN
3217: oe_debug_pub.add( 'PRICE LIST 1='||L_PRICE_LIST ) ;
3218: END IF;
3219: FND_MESSAGE.SET_TOKEN('PRICE_LIST1','( '||in_Ordered_Item||' ) '|| l_price_list);
3220: Begin
3221: Select name into l_price_list
3222: from qp_list_headers_vl a,qp_list_lines b where
3223: b.list_line_id = to_number(substr(in_status_text,
3233: IF l_debug_level > 0 THEN
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');
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||' ) '||
3243: in_status_text);
3244: OE_MSG_PUB.Add;
3245:
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||' ) '||
3243: in_status_text);
3244: OE_MSG_PUB.Add;
3245:
3246: ElSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_INCOMP then
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||' ) '||
3249: in_status_text);
3250: OE_MSG_PUB.Add;
3251:
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||' ) '||
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
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);
3255: FND_MESSAGE.SET_TOKEN('ERR_TEXT',in_status_text);
3256: OE_MSG_PUB.Add;
3257: END IF;
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);
3255: FND_MESSAGE.SET_TOKEN('ERR_TEXT',in_status_text);
3256: OE_MSG_PUB.Add;
3257: END IF;
3258:
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);
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
3261: l_allow_negative_price = 'N' then
3262:
3263: oe_debug_pub.add('Error as Negative Pricing is not Allowed');
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;
3261: l_allow_negative_price = 'N' then
3262:
3263: oe_debug_pub.add('Error as Negative Pricing is not Allowed');
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');
3262:
3263: oe_debug_pub.add('Error as Negative Pricing is not Allowed');
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));
3263: oe_debug_pub.add('Error as Negative Pricing is not Allowed');
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;
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';
3273: --RAISE FND_API.G_EXC_ERROR;*/
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';
3273: --RAISE FND_API.G_EXC_ERROR;*/
3274:
3277:
3278: IF l_debug_level > 0 THEN
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
3278: IF l_debug_level > 0 THEN
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,
3297: END IF;
3298:
3299: IF in_status_text is not null then
3300: l_return_status := 'E';
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;
3298:
3299: IF in_status_text is not null then
3300: l_return_status := 'E';
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;
3299: IF in_status_text is not null then
3300: l_return_status := 'E';
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:
3300: l_return_status := 'E';
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
3334: End;
3335:
3336: l_return_status := 'E';
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;
3336: l_return_status := 'E';
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: