871:
872: IF l_debug_level > 0 THEN
873: oe_debug_pub.add( 'SETTING THE MESSAGE FOR OE_SCH_NO_SOURCE' ) ;
874: END IF;
875: --FND_MESSAGE.SET_NAME('ONT','OE_SCH_NO_SOURCE');
876: IF in_global_orgs = 'N' then
877:
878: FND_MESSAGE.SET_NAME('ONT','ONT_AVAIL_NO_SOURCES');
879: OE_MSG_PUB.Add;
874: END IF;
875: --FND_MESSAGE.SET_NAME('ONT','OE_SCH_NO_SOURCE');
876: IF in_global_orgs = 'N' then
877:
878: FND_MESSAGE.SET_NAME('ONT','ONT_AVAIL_NO_SOURCES');
879: OE_MSG_PUB.Add;
880: ELSE
881: x_error_message := l_explanation;
882: END IF;
919: IF l_debug_level > 0 THEN
920: oe_debug_pub.add( 'ERROR CODE = 53' ) ;
921: END IF;
922:
923: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_AVA_NO_REQUESTED_QTY');
924: FND_MESSAGE.SET_TOKEN('PARTIAL_QUANTITY', p_atp_rec.requested_date_quantity(J));
925: FND_MESSAGE.SET_TOKEN('REQUEST_DATE', p_atp_rec.requested_ship_date(J));
926: FND_MESSAGE.SET_TOKEN('EARLIEST_DATE', p_atp_rec.ship_date(J));
927:
920: oe_debug_pub.add( 'ERROR CODE = 53' ) ;
921: END IF;
922:
923: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_AVA_NO_REQUESTED_QTY');
924: FND_MESSAGE.SET_TOKEN('PARTIAL_QUANTITY', p_atp_rec.requested_date_quantity(J));
925: FND_MESSAGE.SET_TOKEN('REQUEST_DATE', p_atp_rec.requested_ship_date(J));
926: FND_MESSAGE.SET_TOKEN('EARLIEST_DATE', p_atp_rec.ship_date(J));
927:
928: IF in_global_orgs = 'N' then
921: END IF;
922:
923: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_AVA_NO_REQUESTED_QTY');
924: FND_MESSAGE.SET_TOKEN('PARTIAL_QUANTITY', p_atp_rec.requested_date_quantity(J));
925: FND_MESSAGE.SET_TOKEN('REQUEST_DATE', p_atp_rec.requested_ship_date(J));
926: FND_MESSAGE.SET_TOKEN('EARLIEST_DATE', p_atp_rec.ship_date(J));
927:
928: IF in_global_orgs = 'N' then
929: OE_MSG_PUB.Add;
922:
923: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_AVA_NO_REQUESTED_QTY');
924: FND_MESSAGE.SET_TOKEN('PARTIAL_QUANTITY', p_atp_rec.requested_date_quantity(J));
925: FND_MESSAGE.SET_TOKEN('REQUEST_DATE', p_atp_rec.requested_ship_date(J));
926: FND_MESSAGE.SET_TOKEN('EARLIEST_DATE', p_atp_rec.ship_date(J));
927:
928: IF in_global_orgs = 'N' then
929: OE_MSG_PUB.Add;
930: ELSE
927:
928: IF in_global_orgs = 'N' then
929: OE_MSG_PUB.Add;
930: ELSE
931: x_error_message := fnd_message.get;
932: END IF;
933:
934: /* End of code added to fix the bug 3498932 */
935:
944: ELSE
945: IF l_debug_level > 0 THEN
946: oe_debug_pub.add( 'ADDING MESSAGE TO THE STACK' , 1 ) ;
947: END IF;
948: --FND_MESSAGE.SET_NAME('ONT','OE_SCH_OE_ORDER_FAILED');
949: --FND_MESSAGE.SET_TOKEN('EXPLANATION',l_explanation);
950:
951: IF in_global_orgs = 'N' then
952: FND_MESSAGE.SET_NAME('ONT','ONT_INLNE_CUSTOMER');
945: IF l_debug_level > 0 THEN
946: oe_debug_pub.add( 'ADDING MESSAGE TO THE STACK' , 1 ) ;
947: END IF;
948: --FND_MESSAGE.SET_NAME('ONT','OE_SCH_OE_ORDER_FAILED');
949: --FND_MESSAGE.SET_TOKEN('EXPLANATION',l_explanation);
950:
951: IF in_global_orgs = 'N' then
952: FND_MESSAGE.SET_NAME('ONT','ONT_INLNE_CUSTOMER');
953: FND_MESSAGE.SET_TOKEN('TEXT',l_explanation);
948: --FND_MESSAGE.SET_NAME('ONT','OE_SCH_OE_ORDER_FAILED');
949: --FND_MESSAGE.SET_TOKEN('EXPLANATION',l_explanation);
950:
951: IF in_global_orgs = 'N' then
952: FND_MESSAGE.SET_NAME('ONT','ONT_INLNE_CUSTOMER');
953: FND_MESSAGE.SET_TOKEN('TEXT',l_explanation);
954: OE_MSG_PUB.Add;
955: ELSE
956: x_error_message := l_explanation;
949: --FND_MESSAGE.SET_TOKEN('EXPLANATION',l_explanation);
950:
951: IF in_global_orgs = 'N' then
952: FND_MESSAGE.SET_NAME('ONT','ONT_INLNE_CUSTOMER');
953: FND_MESSAGE.SET_TOKEN('TEXT',l_explanation);
954: OE_MSG_PUB.Add;
955: ELSE
956: x_error_message := l_explanation;
957: END IF;
1026: END IF; -- Main If;
1027:
1028: -- umcomment for testing the error handling
1029: --x_return_status := 'E';
1030: --FND_MESSAGE.SET_NAME('ONT','OE_SCH_NO_SOURCE');
1031: --OE_MSG_PUB.Add;
1032:
1033: IF x_return_status ='E' and in_global_orgs = 'N' then
1034: IF l_debug_level > 0 THEN
2909: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2910: IF l_debug_level > 0 THEN
2911: oe_debug_pub.add( 'WRONG IN INSERT_LINES2'||L_RETURN_STATUS_TEXT , 1 ) ;
2912: END IF;
2913: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
2914: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_text);
2915: OE_MSG_PUB.Add;
2916: RAISE FND_API.G_EXC_ERROR;
2917: END IF;
2910: IF l_debug_level > 0 THEN
2911: oe_debug_pub.add( 'WRONG IN INSERT_LINES2'||L_RETURN_STATUS_TEXT , 1 ) ;
2912: END IF;
2913: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
2914: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_text);
2915: OE_MSG_PUB.Add;
2916: RAISE FND_API.G_EXC_ERROR;
2917: END IF;
2918:
2954: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2955: IF l_debug_level > 0 THEN
2956: oe_debug_pub.add( 'ERROR INSERTING INTO LINE ATTRS'||SQLERRM ) ;
2957: END IF;
2958: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
2959: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_text);
2960: OE_MSG_PUB.Add;
2961: raise fnd_api.g_exc_unexpected_error;
2962: END IF;
2955: IF l_debug_level > 0 THEN
2956: oe_debug_pub.add( 'ERROR INSERTING INTO LINE ATTRS'||SQLERRM ) ;
2957: END IF;
2958: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
2959: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_text);
2960: OE_MSG_PUB.Add;
2961: raise fnd_api.g_exc_unexpected_error;
2962: END IF;
2963:
3892: oe_debug_pub.add( 'INVALID PRICE LIST'|| ' PRICE_LIST_ID='||G_panda_rec_table(1).p_PRICE_LIST_ID ) ;
3893: END IF;
3894: IF g_panda_rec_table(1).p_price_list_id is null then
3895:
3896: FND_MESSAGE.SET_NAME('ONT','ONT_AVAIL_GENERIC');
3897: FND_MESSAGE.SET_TOKEN('TEXT',in_status_text);
3898: IF l_debug_level > 0 THEN
3899: oe_debug_pub.add( 'INVALID PL ERR TXT='||IN_STATUS_TEXT ) ;
3900: END IF;
3893: END IF;
3894: IF g_panda_rec_table(1).p_price_list_id is null then
3895:
3896: FND_MESSAGE.SET_NAME('ONT','ONT_AVAIL_GENERIC');
3897: FND_MESSAGE.SET_TOKEN('TEXT',in_status_text);
3898: IF l_debug_level > 0 THEN
3899: oe_debug_pub.add( 'INVALID PL ERR TXT='||IN_STATUS_TEXT ) ;
3900: END IF;
3901: OE_MSG_PUB.Add;
3903: ELSE
3904: IF l_debug_level > 0 THEN
3905: oe_debug_pub.add( 'INVALID PRICE LIST' ) ;
3906: END IF;
3907: FND_MESSAGE.SET_NAME('ONT','OE_PRC_NO_LIST_PRICE');
3908: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
3909: FND_MESSAGE.SET_TOKEN('UNIT',in_uom);
3910: FND_MESSAGE.SET_TOKEN('PRICE_LIST',l_Price_List);
3911: OE_MSG_PUB.Add;
3904: IF l_debug_level > 0 THEN
3905: oe_debug_pub.add( 'INVALID PRICE LIST' ) ;
3906: END IF;
3907: FND_MESSAGE.SET_NAME('ONT','OE_PRC_NO_LIST_PRICE');
3908: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
3909: FND_MESSAGE.SET_TOKEN('UNIT',in_uom);
3910: FND_MESSAGE.SET_TOKEN('PRICE_LIST',l_Price_List);
3911: OE_MSG_PUB.Add;
3912:
3905: oe_debug_pub.add( 'INVALID PRICE LIST' ) ;
3906: END IF;
3907: FND_MESSAGE.SET_NAME('ONT','OE_PRC_NO_LIST_PRICE');
3908: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
3909: FND_MESSAGE.SET_TOKEN('UNIT',in_uom);
3910: FND_MESSAGE.SET_TOKEN('PRICE_LIST',l_Price_List);
3911: OE_MSG_PUB.Add;
3912:
3913: END IF;
3906: END IF;
3907: FND_MESSAGE.SET_NAME('ONT','OE_PRC_NO_LIST_PRICE');
3908: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
3909: FND_MESSAGE.SET_TOKEN('UNIT',in_uom);
3910: FND_MESSAGE.SET_TOKEN('PRICE_LIST',l_Price_List);
3911: OE_MSG_PUB.Add;
3912:
3913: END IF;
3914:
3913: END IF;
3914:
3915: ELSIF in_status_code = QP_PREQ_GRP.G_STS_LHS_NOT_FOUND Then
3916:
3917: FND_MESSAGE.SET_NAME('ONT','ONT_NO_PRICE_LIST_FOUND');
3918: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
3919: FND_MESSAGE.SET_TOKEN('UOM',in_uom);
3920: OE_MSG_PUB.Add;
3921:
3914:
3915: ELSIF in_status_code = QP_PREQ_GRP.G_STS_LHS_NOT_FOUND Then
3916:
3917: FND_MESSAGE.SET_NAME('ONT','ONT_NO_PRICE_LIST_FOUND');
3918: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
3919: FND_MESSAGE.SET_TOKEN('UOM',in_uom);
3920: OE_MSG_PUB.Add;
3921:
3922: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_FORMULA_ERROR then
3915: ELSIF in_status_code = QP_PREQ_GRP.G_STS_LHS_NOT_FOUND Then
3916:
3917: FND_MESSAGE.SET_NAME('ONT','ONT_NO_PRICE_LIST_FOUND');
3918: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
3919: FND_MESSAGE.SET_TOKEN('UOM',in_uom);
3920: OE_MSG_PUB.Add;
3921:
3922: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_FORMULA_ERROR then
3923: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_ERROR_IN_FORMULA');
3919: FND_MESSAGE.SET_TOKEN('UOM',in_uom);
3920: OE_MSG_PUB.Add;
3921:
3922: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_FORMULA_ERROR then
3923: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_ERROR_IN_FORMULA');
3924: OE_MSG_PUB.Add;
3925:
3926: ELSIF in_status_code in
3927: ( QP_PREQ_GRP.G_STATUS_OTHER_ERRORS , FND_API.G_RET_STS_UNEXP_ERROR,
3925:
3926: ELSIF in_status_code in
3927: ( QP_PREQ_GRP.G_STATUS_OTHER_ERRORS , FND_API.G_RET_STS_UNEXP_ERROR,
3928: FND_API.G_RET_STS_ERROR) then
3929: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
3930: FND_MESSAGE.SET_TOKEN('ERR_TEXT',in_status_text);
3931: OE_MSG_PUB.Add;
3932:
3933: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM then
3926: ELSIF in_status_code in
3927: ( QP_PREQ_GRP.G_STATUS_OTHER_ERRORS , FND_API.G_RET_STS_UNEXP_ERROR,
3928: FND_API.G_RET_STS_ERROR) then
3929: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
3930: FND_MESSAGE.SET_TOKEN('ERR_TEXT',in_status_text);
3931: OE_MSG_PUB.Add;
3932:
3933: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM then
3934: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM');
3930: FND_MESSAGE.SET_TOKEN('ERR_TEXT',in_status_text);
3931: OE_MSG_PUB.Add;
3932:
3933: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM then
3934: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM');
3935: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
3936: FND_MESSAGE.SET_TOKEN('UOM',in_uom);
3937: OE_MSG_PUB.Add;
3938:
3931: OE_MSG_PUB.Add;
3932:
3933: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM then
3934: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM');
3935: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
3936: FND_MESSAGE.SET_TOKEN('UOM',in_uom);
3937: OE_MSG_PUB.Add;
3938:
3939: ElSIF in_status_code = QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST then
3932:
3933: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM then
3934: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM');
3935: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
3936: FND_MESSAGE.SET_TOKEN('UOM',in_uom);
3937: OE_MSG_PUB.Add;
3938:
3939: ElSIF in_status_code = QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST then
3940: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_DUPLICATE_PRICE_LIST');
3936: FND_MESSAGE.SET_TOKEN('UOM',in_uom);
3937: OE_MSG_PUB.Add;
3938:
3939: ElSIF in_status_code = QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST then
3940: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_DUPLICATE_PRICE_LIST');
3941:
3942: IF l_debug_level > 0 THEN
3943: oe_debug_pub.add( 'DUPLICATE PRICE LIST ERROR' ) ;
3944: END IF;
3958:
3959: IF l_debug_level > 0 THEN
3960: oe_debug_pub.add( 'PRICE LIST 1='||L_PRICE_LIST ) ;
3961: END IF;
3962: FND_MESSAGE.SET_TOKEN('PRICE_LIST1','( '||in_Ordered_Item||' ) '|| l_price_list);
3963: Begin
3964: Select name into l_price_list
3965: from qp_list_headers_vl a,qp_list_lines b where
3966: b.list_line_id = to_number(substr(in_status_text,
3976: IF l_debug_level > 0 THEN
3977: oe_debug_pub.add( 'PRICE LIST 2='||L_PRICE_LIST ) ;
3978: END IF;
3979:
3980: FND_MESSAGE.SET_TOKEN('PRICE_LIST2',l_price_list);
3981: OE_MSG_PUB.Add;
3982:
3983: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV then
3984: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM_CONVERSION');
3980: FND_MESSAGE.SET_TOKEN('PRICE_LIST2',l_price_list);
3981: OE_MSG_PUB.Add;
3982:
3983: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV then
3984: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM_CONVERSION');
3985: FND_MESSAGE.SET_TOKEN('UOM_TEXT','( '||in_Ordered_Item||' ) '||
3986: in_status_text);
3987: OE_MSG_PUB.Add;
3988:
3981: OE_MSG_PUB.Add;
3982:
3983: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV then
3984: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM_CONVERSION');
3985: FND_MESSAGE.SET_TOKEN('UOM_TEXT','( '||in_Ordered_Item||' ) '||
3986: in_status_text);
3987: OE_MSG_PUB.Add;
3988:
3989: ElSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_INCOMP then
3986: in_status_text);
3987: OE_MSG_PUB.Add;
3988:
3989: ElSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_INCOMP then
3990: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_INCOMP');
3991: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '||in_Ordered_Item||' ) '||
3992: in_status_text);
3993: OE_MSG_PUB.Add;
3994:
3987: OE_MSG_PUB.Add;
3988:
3989: ElSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_INCOMP then
3990: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_INCOMP');
3991: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '||in_Ordered_Item||' ) '||
3992: in_status_text);
3993: OE_MSG_PUB.Add;
3994:
3995: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR then
3992: in_status_text);
3993: OE_MSG_PUB.Add;
3994:
3995: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR then
3996: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_BEST_PRICE_ERROR');
3997: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
3998: FND_MESSAGE.SET_TOKEN('ERR_TEXT',in_status_text);
3999: OE_MSG_PUB.Add;
4000: END IF;
3993: OE_MSG_PUB.Add;
3994:
3995: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR then
3996: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_BEST_PRICE_ERROR');
3997: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
3998: FND_MESSAGE.SET_TOKEN('ERR_TEXT',in_status_text);
3999: OE_MSG_PUB.Add;
4000: END IF;
4001:
3994:
3995: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR then
3996: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_BEST_PRICE_ERROR');
3997: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
3998: FND_MESSAGE.SET_TOKEN('ERR_TEXT',in_status_text);
3999: OE_MSG_PUB.Add;
4000: END IF;
4001:
4002:
4003: /*elsif ( in_unit_price < 0 or in_Adjusted_unit_price < 0) and
4004: l_allow_negative_price = 'N' then
4005:
4006: oe_debug_pub.add('Error as Negative Pricing is not Allowed');
4007: FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_PRICE');
4008: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
4009: FND_MESSAGE.SET_TOKEN('LIST_PRICE',in_unit_price);
4010: FND_MESSAGE.SET_TOKEN('SELLING_PRICE',in_Adjusted_unit_price);
4011: OE_MSG_PUB.Add;
4004: l_allow_negative_price = 'N' then
4005:
4006: oe_debug_pub.add('Error as Negative Pricing is not Allowed');
4007: FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_PRICE');
4008: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
4009: FND_MESSAGE.SET_TOKEN('LIST_PRICE',in_unit_price);
4010: FND_MESSAGE.SET_TOKEN('SELLING_PRICE',in_Adjusted_unit_price);
4011: OE_MSG_PUB.Add;
4012: --FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_MODIFIERS');
4005:
4006: oe_debug_pub.add('Error as Negative Pricing is not Allowed');
4007: FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_PRICE');
4008: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
4009: FND_MESSAGE.SET_TOKEN('LIST_PRICE',in_unit_price);
4010: FND_MESSAGE.SET_TOKEN('SELLING_PRICE',in_Adjusted_unit_price);
4011: OE_MSG_PUB.Add;
4012: --FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_MODIFIERS');
4013: --FND_MESSAGE.SET_TOKEN('LIST_LINE_NO',get_list_lines(g_line_id));
4006: oe_debug_pub.add('Error as Negative Pricing is not Allowed');
4007: FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_PRICE');
4008: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
4009: FND_MESSAGE.SET_TOKEN('LIST_PRICE',in_unit_price);
4010: FND_MESSAGE.SET_TOKEN('SELLING_PRICE',in_Adjusted_unit_price);
4011: OE_MSG_PUB.Add;
4012: --FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_MODIFIERS');
4013: --FND_MESSAGE.SET_TOKEN('LIST_LINE_NO',get_list_lines(g_line_id));
4014: --OE_MSG_PUB.Add;
4008: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
4009: FND_MESSAGE.SET_TOKEN('LIST_PRICE',in_unit_price);
4010: FND_MESSAGE.SET_TOKEN('SELLING_PRICE',in_Adjusted_unit_price);
4011: OE_MSG_PUB.Add;
4012: --FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_MODIFIERS');
4013: --FND_MESSAGE.SET_TOKEN('LIST_LINE_NO',get_list_lines(g_line_id));
4014: --OE_MSG_PUB.Add;
4015: l_return_status := 'E';
4016: --RAISE FND_API.G_EXC_ERROR;*/
4009: FND_MESSAGE.SET_TOKEN('LIST_PRICE',in_unit_price);
4010: FND_MESSAGE.SET_TOKEN('SELLING_PRICE',in_Adjusted_unit_price);
4011: OE_MSG_PUB.Add;
4012: --FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_MODIFIERS');
4013: --FND_MESSAGE.SET_TOKEN('LIST_LINE_NO',get_list_lines(g_line_id));
4014: --OE_MSG_PUB.Add;
4015: l_return_status := 'E';
4016: --RAISE FND_API.G_EXC_ERROR;*/
4017:
4020:
4021: IF l_debug_level > 0 THEN
4022: oe_debug_pub.add( 'OE_PRICING_ERROR' ) ;
4023: END IF;
4024: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
4025: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '||in_Ordered_Item||' ) '||in_STATUS_TEXT);
4026: OE_MSG_PUB.Add;
4027:
4028: ELSIF in_line_Type_code ='LINE' and in_status_code in
4021: IF l_debug_level > 0 THEN
4022: oe_debug_pub.add( 'OE_PRICING_ERROR' ) ;
4023: END IF;
4024: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
4025: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '||in_Ordered_Item||' ) '||in_STATUS_TEXT);
4026: OE_MSG_PUB.Add;
4027:
4028: ELSIF in_line_Type_code ='LINE' and in_status_code in
4029: --( QP_PREQ_GRP.G_STATUS_UPDATED,
4040: END IF;
4041:
4042: IF in_status_text is not null then
4043: l_return_status := 'E';
4044: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
4045: FND_MESSAGE.SET_TOKEN('ERR_TEXT',in_status_text);
4046: OE_MSG_PUB.Add;
4047: END IF;
4048:
4041:
4042: IF in_status_text is not null then
4043: l_return_status := 'E';
4044: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
4045: FND_MESSAGE.SET_TOKEN('ERR_TEXT',in_status_text);
4046: OE_MSG_PUB.Add;
4047: END IF;
4048:
4049: -- we need to do this check in UPDATED code or do the gsa check through
4075: End;
4076:
4077: l_return_status := 'E';
4078: oe_debug_pub.add('GSA warning or error 2 msg_Text='||l_msg_text);
4079: FND_MESSAGE.SET_NAME('ONT','OE_GSA_VIOLATION');
4080: l_msg_text := l_operand||' ( '||l_msg_text||' )';
4081: FND_MESSAGE.SET_TOKEN('GSA_PRICE',l_msg_text);
4082: OE_MSG_PUB.Add;
4083: END IF;
4077: l_return_status := 'E';
4078: oe_debug_pub.add('GSA warning or error 2 msg_Text='||l_msg_text);
4079: FND_MESSAGE.SET_NAME('ONT','OE_GSA_VIOLATION');
4080: l_msg_text := l_operand||' ( '||l_msg_text||' )';
4081: FND_MESSAGE.SET_TOKEN('GSA_PRICE',l_msg_text);
4082: OE_MSG_PUB.Add;
4083: END IF;
4084: END IF; */
4085:
4839: IF l_debug_level > 0 THEN
4840: oe_debug_pub.add( 'MSG DATA IS NOT NULL' ) ;
4841: END IF;
4842: x_return_status := 'E';
4843: FND_MESSAGE.SET_NAME('ONT','ONT_AVAIL_GENERIC');
4844: IF l_debug_level > 0 THEN
4845: oe_debug_pub.add( 'MSG DATA IS NOT NULL 2' ) ;
4846: END IF;
4847: FND_MESSAGE.SET_TOKEN('TEXT',x_msg_data);
4843: FND_MESSAGE.SET_NAME('ONT','ONT_AVAIL_GENERIC');
4844: IF l_debug_level > 0 THEN
4845: oe_debug_pub.add( 'MSG DATA IS NOT NULL 2' ) ;
4846: END IF;
4847: FND_MESSAGE.SET_TOKEN('TEXT',x_msg_data);
4848: OE_MSG_PUB.Add;
4849:
4850: END IF;
4851:
4914: using l_instance_id,in_inventory_item_id,l_org_id;
4915:
4916:
4917: IF x_plan_id is null then
4918: fnd_message.set_name('MSC', 'MSC_NO_PLANS_DEFINED');
4919: oe_msg_pub.add;
4920: x_return_status := 'E';
4921: oe_debug_pub.add('Plan Id NOT FOUND');
4922: END IF;
4993: IF nvl(x_return_status,'S') <> 'S' THEN
4994: IF l_debug_level > 0 THEN
4995: oe_debug_pub.add( ' ERROR IN CALL TO get_supply_sources_local');
4996: END IF;
4997: fnd_message.set_name('MSC', x_err_mesg);
4998: oe_msg_pub.add;
4999:
5000: ELSE
5001:
5051: oe_debug_pub.add( ' THERE ARE NO SOURCES TO BE DISPLAYED ' ) ;
5052: END IF;
5053: x_return_status := 'E';
5054: x_error_mesg := 'MRP_ATP_NO_SOURCES';
5055: FND_MESSAGE.SET_NAME('MSC','MRP_ATP_NO_SOURCES');
5056: OE_MSG_PUB.Add;
5057: x_return_status := 'E';
5058:
5059: END IF; -- IF x_sources.organization_id.COUNT > 0