656:
657: IF l_debug_level > 0 THEN
658: oe_debug_pub.add( 'SETTING THE MESSAGE FOR OE_SCH_NO_SOURCE' ) ;
659: END IF;
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;
659: END IF;
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;
706: ELSE
707: IF l_debug_level > 0 THEN
708: oe_debug_pub.add( 'ADDING MESSAGE TO THE STACK' , 1 ) ;
709: END IF;
710: --FND_MESSAGE.SET_NAME('ONT','OE_SCH_OE_ORDER_FAILED');
711: --FND_MESSAGE.SET_TOKEN('EXPLANATION',l_explanation);
712:
713: IF p_global_orgs = 'N' then
714: FND_MESSAGE.SET_NAME('ONT','ONT_INLNE_CUSTOMER');
707: IF l_debug_level > 0 THEN
708: oe_debug_pub.add( 'ADDING MESSAGE TO THE STACK' , 1 ) ;
709: END IF;
710: --FND_MESSAGE.SET_NAME('ONT','OE_SCH_OE_ORDER_FAILED');
711: --FND_MESSAGE.SET_TOKEN('EXPLANATION',l_explanation);
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);
710: --FND_MESSAGE.SET_NAME('ONT','OE_SCH_OE_ORDER_FAILED');
711: --FND_MESSAGE.SET_TOKEN('EXPLANATION',l_explanation);
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;
711: --FND_MESSAGE.SET_TOKEN('EXPLANATION',l_explanation);
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;
787: END IF; -- Main If;
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
3115: oe_debug_pub.add( 'INVALID PRICE LIST'|| ' PRICE_LIST_ID='||G_PRICE_LIST_ID ) ;
3116: END IF;
3117: IF g_price_list_id is null then
3118:
3119: FND_MESSAGE.SET_NAME('ONT','ONT_AVAIL_GENERIC');
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;
3116: END IF;
3117: IF g_price_list_id is null then
3118:
3119: FND_MESSAGE.SET_NAME('ONT','ONT_AVAIL_GENERIC');
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;
3126: ELSE
3127: IF l_debug_level > 0 THEN
3128: oe_debug_pub.add( 'INVALID PRICE LIST' ) ;
3129: END IF;
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;
3127: IF l_debug_level > 0 THEN
3128: oe_debug_pub.add( 'INVALID PRICE LIST' ) ;
3129: END IF;
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:
3128: oe_debug_pub.add( 'INVALID PRICE LIST' ) ;
3129: END IF;
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;
3129: END IF;
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:
3136: END IF;
3137:
3138: ELSIF in_status_code = QP_PREQ_GRP.G_STS_LHS_NOT_FOUND Then
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:
3137:
3138: ELSIF in_status_code = QP_PREQ_GRP.G_STS_LHS_NOT_FOUND Then
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
3138: ELSIF in_status_code = QP_PREQ_GRP.G_STS_LHS_NOT_FOUND Then
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');
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;
3148:
3149: ELSIF in_status_code in
3150: ( QP_PREQ_GRP.G_STATUS_OTHER_ERRORS , FND_API.G_RET_STS_UNEXP_ERROR,
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
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
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
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');
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);
3159: FND_MESSAGE.SET_TOKEN('UOM',in_uom);
3160: OE_MSG_PUB.Add;
3161:
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);
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
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);
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');
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:
3165: IF l_debug_level > 0 THEN
3166: oe_debug_pub.add( 'DUPLICATE PRICE LIST ERROR' ) ;
3167: END IF;
3181:
3182: IF l_debug_level > 0 THEN
3183: oe_debug_pub.add( 'PRICE LIST 1='||L_PRICE_LIST ) ;
3184: END IF;
3185: FND_MESSAGE.SET_TOKEN('PRICE_LIST1','( '||in_Ordered_Item||' ) '|| l_price_list);
3186: Begin
3187: Select name into l_price_list
3188: from qp_list_headers_vl a,qp_list_lines b where
3189: b.list_line_id = to_number(substr(in_status_text,
3199: IF l_debug_level > 0 THEN
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');
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||' ) '||
3209: in_status_text);
3210: OE_MSG_PUB.Add;
3211:
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||' ) '||
3209: in_status_text);
3210: OE_MSG_PUB.Add;
3211:
3212: ElSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_INCOMP then
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||' ) '||
3215: in_status_text);
3216: OE_MSG_PUB.Add;
3217:
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||' ) '||
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
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);
3221: FND_MESSAGE.SET_TOKEN('ERR_TEXT',in_status_text);
3222: OE_MSG_PUB.Add;
3223: END IF;
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);
3221: FND_MESSAGE.SET_TOKEN('ERR_TEXT',in_status_text);
3222: OE_MSG_PUB.Add;
3223: END IF;
3224:
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);
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
3227: l_allow_negative_price = 'N' then
3228:
3229: oe_debug_pub.add('Error as Negative Pricing is not Allowed');
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;
3227: l_allow_negative_price = 'N' then
3228:
3229: oe_debug_pub.add('Error as Negative Pricing is not Allowed');
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');
3228:
3229: oe_debug_pub.add('Error as Negative Pricing is not Allowed');
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));
3229: oe_debug_pub.add('Error as Negative Pricing is not Allowed');
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;
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';
3239: --RAISE FND_API.G_EXC_ERROR;*/
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';
3239: --RAISE FND_API.G_EXC_ERROR;*/
3240:
3243:
3244: IF l_debug_level > 0 THEN
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
3244: IF l_debug_level > 0 THEN
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,
3263: END IF;
3264:
3265: IF in_status_text is not null then
3266: l_return_status := 'E';
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;
3264:
3265: IF in_status_text is not null then
3266: l_return_status := 'E';
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;
3265: IF in_status_text is not null then
3266: l_return_status := 'E';
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:
3266: l_return_status := 'E';
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
3300: End;
3301:
3302: l_return_status := 'E';
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;
3302: l_return_status := 'E';
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: