DBA Data[Home] [Help]

APPS.OE_OE_AVAILABILITY dependencies on FND_MESSAGE

Line 872: --FND_MESSAGE.SET_NAME('ONT','OE_SCH_NO_SOURCE');

868:
869: IF l_debug_level > 0 THEN
870: oe_debug_pub.add( 'SETTING THE MESSAGE FOR OE_SCH_NO_SOURCE' ) ;
871: END IF;
872: --FND_MESSAGE.SET_NAME('ONT','OE_SCH_NO_SOURCE');
873: IF in_global_orgs = 'N' then
874:
875: FND_MESSAGE.SET_NAME('ONT','ONT_AVAIL_NO_SOURCES');
876: OE_MSG_PUB.Add;

Line 875: FND_MESSAGE.SET_NAME('ONT','ONT_AVAIL_NO_SOURCES');

871: END IF;
872: --FND_MESSAGE.SET_NAME('ONT','OE_SCH_NO_SOURCE');
873: IF in_global_orgs = 'N' then
874:
875: FND_MESSAGE.SET_NAME('ONT','ONT_AVAIL_NO_SOURCES');
876: OE_MSG_PUB.Add;
877: ELSE
878: x_error_message := l_explanation;
879: END IF;

Line 920: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_AVA_NO_REQUESTED_QTY');

916: IF l_debug_level > 0 THEN
917: oe_debug_pub.add( 'ERROR CODE = 53' ) ;
918: END IF;
919:
920: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_AVA_NO_REQUESTED_QTY');
921: FND_MESSAGE.SET_TOKEN('PARTIAL_QUANTITY', p_atp_rec.requested_date_quantity(J));
922: FND_MESSAGE.SET_TOKEN('REQUEST_DATE', p_atp_rec.requested_ship_date(J));
923: FND_MESSAGE.SET_TOKEN('EARLIEST_DATE', p_atp_rec.ship_date(J));
924:

Line 921: FND_MESSAGE.SET_TOKEN('PARTIAL_QUANTITY', p_atp_rec.requested_date_quantity(J));

917: oe_debug_pub.add( 'ERROR CODE = 53' ) ;
918: END IF;
919:
920: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_AVA_NO_REQUESTED_QTY');
921: FND_MESSAGE.SET_TOKEN('PARTIAL_QUANTITY', p_atp_rec.requested_date_quantity(J));
922: FND_MESSAGE.SET_TOKEN('REQUEST_DATE', p_atp_rec.requested_ship_date(J));
923: FND_MESSAGE.SET_TOKEN('EARLIEST_DATE', p_atp_rec.ship_date(J));
924:
925: IF in_global_orgs = 'N' then

Line 922: FND_MESSAGE.SET_TOKEN('REQUEST_DATE', p_atp_rec.requested_ship_date(J));

918: END IF;
919:
920: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_AVA_NO_REQUESTED_QTY');
921: FND_MESSAGE.SET_TOKEN('PARTIAL_QUANTITY', p_atp_rec.requested_date_quantity(J));
922: FND_MESSAGE.SET_TOKEN('REQUEST_DATE', p_atp_rec.requested_ship_date(J));
923: FND_MESSAGE.SET_TOKEN('EARLIEST_DATE', p_atp_rec.ship_date(J));
924:
925: IF in_global_orgs = 'N' then
926: OE_MSG_PUB.Add;

Line 923: FND_MESSAGE.SET_TOKEN('EARLIEST_DATE', p_atp_rec.ship_date(J));

919:
920: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_AVA_NO_REQUESTED_QTY');
921: FND_MESSAGE.SET_TOKEN('PARTIAL_QUANTITY', p_atp_rec.requested_date_quantity(J));
922: FND_MESSAGE.SET_TOKEN('REQUEST_DATE', p_atp_rec.requested_ship_date(J));
923: FND_MESSAGE.SET_TOKEN('EARLIEST_DATE', p_atp_rec.ship_date(J));
924:
925: IF in_global_orgs = 'N' then
926: OE_MSG_PUB.Add;
927: ELSE

Line 928: x_error_message := fnd_message.get;

924:
925: IF in_global_orgs = 'N' then
926: OE_MSG_PUB.Add;
927: ELSE
928: x_error_message := fnd_message.get;
929: END IF;
930:
931: /* End of code added to fix the bug 3498932 */
932:

Line 945: --FND_MESSAGE.SET_NAME('ONT','OE_SCH_OE_ORDER_FAILED');

941: ELSE
942: IF l_debug_level > 0 THEN
943: oe_debug_pub.add( 'ADDING MESSAGE TO THE STACK' , 1 ) ;
944: END IF;
945: --FND_MESSAGE.SET_NAME('ONT','OE_SCH_OE_ORDER_FAILED');
946: --FND_MESSAGE.SET_TOKEN('EXPLANATION',l_explanation);
947:
948: IF in_global_orgs = 'N' then
949: FND_MESSAGE.SET_NAME('ONT','ONT_INLNE_CUSTOMER');

Line 946: --FND_MESSAGE.SET_TOKEN('EXPLANATION',l_explanation);

942: IF l_debug_level > 0 THEN
943: oe_debug_pub.add( 'ADDING MESSAGE TO THE STACK' , 1 ) ;
944: END IF;
945: --FND_MESSAGE.SET_NAME('ONT','OE_SCH_OE_ORDER_FAILED');
946: --FND_MESSAGE.SET_TOKEN('EXPLANATION',l_explanation);
947:
948: IF in_global_orgs = 'N' then
949: FND_MESSAGE.SET_NAME('ONT','ONT_INLNE_CUSTOMER');
950: FND_MESSAGE.SET_TOKEN('TEXT',l_explanation);

Line 949: FND_MESSAGE.SET_NAME('ONT','ONT_INLNE_CUSTOMER');

945: --FND_MESSAGE.SET_NAME('ONT','OE_SCH_OE_ORDER_FAILED');
946: --FND_MESSAGE.SET_TOKEN('EXPLANATION',l_explanation);
947:
948: IF in_global_orgs = 'N' then
949: FND_MESSAGE.SET_NAME('ONT','ONT_INLNE_CUSTOMER');
950: FND_MESSAGE.SET_TOKEN('TEXT',l_explanation);
951: OE_MSG_PUB.Add;
952: ELSE
953: x_error_message := l_explanation;

Line 950: FND_MESSAGE.SET_TOKEN('TEXT',l_explanation);

946: --FND_MESSAGE.SET_TOKEN('EXPLANATION',l_explanation);
947:
948: IF in_global_orgs = 'N' then
949: FND_MESSAGE.SET_NAME('ONT','ONT_INLNE_CUSTOMER');
950: FND_MESSAGE.SET_TOKEN('TEXT',l_explanation);
951: OE_MSG_PUB.Add;
952: ELSE
953: x_error_message := l_explanation;
954: END IF;

Line 1027: --FND_MESSAGE.SET_NAME('ONT','OE_SCH_NO_SOURCE');

1023: END IF; -- Main If;
1024:
1025: -- umcomment for testing the error handling
1026: --x_return_status := 'E';
1027: --FND_MESSAGE.SET_NAME('ONT','OE_SCH_NO_SOURCE');
1028: --OE_MSG_PUB.Add;
1029:
1030: IF x_return_status ='E' and in_global_orgs = 'N' then
1031: IF l_debug_level > 0 THEN

Line 2908: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497

2904: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2905: IF l_debug_level > 0 THEN
2906: oe_debug_pub.add( 'WRONG IN INSERT_LINES2'||L_RETURN_STATUS_TEXT , 1 ) ;
2907: END IF;
2908: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
2909: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_text);
2910: OE_MSG_PUB.Add;
2911: RAISE FND_API.G_EXC_ERROR;
2912: END IF;

Line 2909: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_text);

2905: IF l_debug_level > 0 THEN
2906: oe_debug_pub.add( 'WRONG IN INSERT_LINES2'||L_RETURN_STATUS_TEXT , 1 ) ;
2907: END IF;
2908: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
2909: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_text);
2910: OE_MSG_PUB.Add;
2911: RAISE FND_API.G_EXC_ERROR;
2912: END IF;
2913:

Line 2953: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497

2949: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2950: IF l_debug_level > 0 THEN
2951: oe_debug_pub.add( 'ERROR INSERTING INTO LINE ATTRS'||SQLERRM ) ;
2952: END IF;
2953: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
2954: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_text);
2955: OE_MSG_PUB.Add;
2956: raise fnd_api.g_exc_unexpected_error;
2957: END IF;

Line 2954: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_text);

2950: IF l_debug_level > 0 THEN
2951: oe_debug_pub.add( 'ERROR INSERTING INTO LINE ATTRS'||SQLERRM ) ;
2952: END IF;
2953: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
2954: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_text);
2955: OE_MSG_PUB.Add;
2956: raise fnd_api.g_exc_unexpected_error;
2957: END IF;
2958:

Line 3879: FND_MESSAGE.SET_NAME('ONT','ONT_AVAIL_GENERIC');

3875: oe_debug_pub.add( 'INVALID PRICE LIST'|| ' PRICE_LIST_ID='||G_panda_rec_table(1).p_PRICE_LIST_ID ) ;
3876: END IF;
3877: IF g_panda_rec_table(1).p_price_list_id is null then
3878:
3879: FND_MESSAGE.SET_NAME('ONT','ONT_AVAIL_GENERIC');
3880: FND_MESSAGE.SET_TOKEN('TEXT',in_status_text);
3881: IF l_debug_level > 0 THEN
3882: oe_debug_pub.add( 'INVALID PL ERR TXT='||IN_STATUS_TEXT ) ;
3883: END IF;

Line 3880: FND_MESSAGE.SET_TOKEN('TEXT',in_status_text);

3876: END IF;
3877: IF g_panda_rec_table(1).p_price_list_id is null then
3878:
3879: FND_MESSAGE.SET_NAME('ONT','ONT_AVAIL_GENERIC');
3880: FND_MESSAGE.SET_TOKEN('TEXT',in_status_text);
3881: IF l_debug_level > 0 THEN
3882: oe_debug_pub.add( 'INVALID PL ERR TXT='||IN_STATUS_TEXT ) ;
3883: END IF;
3884: OE_MSG_PUB.Add;

Line 3890: FND_MESSAGE.SET_NAME('ONT','OE_PRC_NO_LIST_PRICE');

3886: ELSE
3887: IF l_debug_level > 0 THEN
3888: oe_debug_pub.add( 'INVALID PRICE LIST' ) ;
3889: END IF;
3890: FND_MESSAGE.SET_NAME('ONT','OE_PRC_NO_LIST_PRICE');
3891: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
3892: FND_MESSAGE.SET_TOKEN('UNIT',in_uom);
3893: FND_MESSAGE.SET_TOKEN('PRICE_LIST',l_Price_List);
3894: OE_MSG_PUB.Add;

Line 3891: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);

3887: IF l_debug_level > 0 THEN
3888: oe_debug_pub.add( 'INVALID PRICE LIST' ) ;
3889: END IF;
3890: FND_MESSAGE.SET_NAME('ONT','OE_PRC_NO_LIST_PRICE');
3891: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
3892: FND_MESSAGE.SET_TOKEN('UNIT',in_uom);
3893: FND_MESSAGE.SET_TOKEN('PRICE_LIST',l_Price_List);
3894: OE_MSG_PUB.Add;
3895:

Line 3892: FND_MESSAGE.SET_TOKEN('UNIT',in_uom);

3888: oe_debug_pub.add( 'INVALID PRICE LIST' ) ;
3889: END IF;
3890: FND_MESSAGE.SET_NAME('ONT','OE_PRC_NO_LIST_PRICE');
3891: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
3892: FND_MESSAGE.SET_TOKEN('UNIT',in_uom);
3893: FND_MESSAGE.SET_TOKEN('PRICE_LIST',l_Price_List);
3894: OE_MSG_PUB.Add;
3895:
3896: END IF;

Line 3893: FND_MESSAGE.SET_TOKEN('PRICE_LIST',l_Price_List);

3889: END IF;
3890: FND_MESSAGE.SET_NAME('ONT','OE_PRC_NO_LIST_PRICE');
3891: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
3892: FND_MESSAGE.SET_TOKEN('UNIT',in_uom);
3893: FND_MESSAGE.SET_TOKEN('PRICE_LIST',l_Price_List);
3894: OE_MSG_PUB.Add;
3895:
3896: END IF;
3897:

Line 3900: FND_MESSAGE.SET_NAME('ONT','ONT_NO_PRICE_LIST_FOUND');

3896: END IF;
3897:
3898: ELSIF in_status_code = QP_PREQ_GRP.G_STS_LHS_NOT_FOUND Then
3899:
3900: FND_MESSAGE.SET_NAME('ONT','ONT_NO_PRICE_LIST_FOUND');
3901: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
3902: FND_MESSAGE.SET_TOKEN('UOM',in_uom);
3903: OE_MSG_PUB.Add;
3904:

Line 3901: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);

3897:
3898: ELSIF in_status_code = QP_PREQ_GRP.G_STS_LHS_NOT_FOUND Then
3899:
3900: FND_MESSAGE.SET_NAME('ONT','ONT_NO_PRICE_LIST_FOUND');
3901: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
3902: FND_MESSAGE.SET_TOKEN('UOM',in_uom);
3903: OE_MSG_PUB.Add;
3904:
3905: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_FORMULA_ERROR then

Line 3902: FND_MESSAGE.SET_TOKEN('UOM',in_uom);

3898: ELSIF in_status_code = QP_PREQ_GRP.G_STS_LHS_NOT_FOUND Then
3899:
3900: FND_MESSAGE.SET_NAME('ONT','ONT_NO_PRICE_LIST_FOUND');
3901: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
3902: FND_MESSAGE.SET_TOKEN('UOM',in_uom);
3903: OE_MSG_PUB.Add;
3904:
3905: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_FORMULA_ERROR then
3906: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_ERROR_IN_FORMULA');

Line 3906: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_ERROR_IN_FORMULA');

3902: FND_MESSAGE.SET_TOKEN('UOM',in_uom);
3903: OE_MSG_PUB.Add;
3904:
3905: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_FORMULA_ERROR then
3906: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_ERROR_IN_FORMULA');
3907: OE_MSG_PUB.Add;
3908:
3909: ELSIF in_status_code in
3910: ( QP_PREQ_GRP.G_STATUS_OTHER_ERRORS , FND_API.G_RET_STS_UNEXP_ERROR,

Line 3912: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497

3908:
3909: ELSIF in_status_code in
3910: ( QP_PREQ_GRP.G_STATUS_OTHER_ERRORS , FND_API.G_RET_STS_UNEXP_ERROR,
3911: FND_API.G_RET_STS_ERROR) then
3912: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
3913: FND_MESSAGE.SET_TOKEN('ERR_TEXT',in_status_text);
3914: OE_MSG_PUB.Add;
3915:
3916: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM then

Line 3913: FND_MESSAGE.SET_TOKEN('ERR_TEXT',in_status_text);

3909: ELSIF in_status_code in
3910: ( QP_PREQ_GRP.G_STATUS_OTHER_ERRORS , FND_API.G_RET_STS_UNEXP_ERROR,
3911: FND_API.G_RET_STS_ERROR) then
3912: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
3913: FND_MESSAGE.SET_TOKEN('ERR_TEXT',in_status_text);
3914: OE_MSG_PUB.Add;
3915:
3916: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM then
3917: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM');

Line 3917: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM');

3913: FND_MESSAGE.SET_TOKEN('ERR_TEXT',in_status_text);
3914: OE_MSG_PUB.Add;
3915:
3916: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM then
3917: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM');
3918: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
3919: FND_MESSAGE.SET_TOKEN('UOM',in_uom);
3920: OE_MSG_PUB.Add;
3921:

Line 3918: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);

3914: OE_MSG_PUB.Add;
3915:
3916: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM then
3917: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM');
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_DUP_PRICE_LIST then

Line 3919: FND_MESSAGE.SET_TOKEN('UOM',in_uom);

3915:
3916: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM then
3917: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM');
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_DUP_PRICE_LIST then
3923: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_DUPLICATE_PRICE_LIST');

Line 3923: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_DUPLICATE_PRICE_LIST');

3919: FND_MESSAGE.SET_TOKEN('UOM',in_uom);
3920: OE_MSG_PUB.Add;
3921:
3922: ElSIF in_status_code = QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST then
3923: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_DUPLICATE_PRICE_LIST');
3924:
3925: IF l_debug_level > 0 THEN
3926: oe_debug_pub.add( 'DUPLICATE PRICE LIST ERROR' ) ;
3927: END IF;

Line 3945: FND_MESSAGE.SET_TOKEN('PRICE_LIST1','( '||in_Ordered_Item||' ) '|| l_price_list);

3941:
3942: IF l_debug_level > 0 THEN
3943: oe_debug_pub.add( 'PRICE LIST 1='||L_PRICE_LIST ) ;
3944: END IF;
3945: FND_MESSAGE.SET_TOKEN('PRICE_LIST1','( '||in_Ordered_Item||' ) '|| l_price_list);
3946: Begin
3947: Select name into l_price_list
3948: from qp_list_headers_vl a,qp_list_lines b where
3949: b.list_line_id = to_number(substr(in_status_text,

Line 3963: FND_MESSAGE.SET_TOKEN('PRICE_LIST2',l_price_list);

3959: IF l_debug_level > 0 THEN
3960: oe_debug_pub.add( 'PRICE LIST 2='||L_PRICE_LIST ) ;
3961: END IF;
3962:
3963: FND_MESSAGE.SET_TOKEN('PRICE_LIST2',l_price_list);
3964: OE_MSG_PUB.Add;
3965:
3966: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV then
3967: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM_CONVERSION');

Line 3967: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM_CONVERSION');

3963: FND_MESSAGE.SET_TOKEN('PRICE_LIST2',l_price_list);
3964: OE_MSG_PUB.Add;
3965:
3966: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV then
3967: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM_CONVERSION');
3968: FND_MESSAGE.SET_TOKEN('UOM_TEXT','( '||in_Ordered_Item||' ) '||
3969: in_status_text);
3970: OE_MSG_PUB.Add;
3971:

Line 3968: FND_MESSAGE.SET_TOKEN('UOM_TEXT','( '||in_Ordered_Item||' ) '||

3964: OE_MSG_PUB.Add;
3965:
3966: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV then
3967: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM_CONVERSION');
3968: FND_MESSAGE.SET_TOKEN('UOM_TEXT','( '||in_Ordered_Item||' ) '||
3969: in_status_text);
3970: OE_MSG_PUB.Add;
3971:
3972: ElSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_INCOMP then

Line 3973: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_INCOMP');

3969: in_status_text);
3970: OE_MSG_PUB.Add;
3971:
3972: ElSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_INCOMP then
3973: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_INCOMP');
3974: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '||in_Ordered_Item||' ) '||
3975: in_status_text);
3976: OE_MSG_PUB.Add;
3977:

Line 3974: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '||in_Ordered_Item||' ) '||

3970: OE_MSG_PUB.Add;
3971:
3972: ElSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_INCOMP then
3973: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_INCOMP');
3974: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '||in_Ordered_Item||' ) '||
3975: in_status_text);
3976: OE_MSG_PUB.Add;
3977:
3978: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR then

Line 3979: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_BEST_PRICE_ERROR');

3975: in_status_text);
3976: OE_MSG_PUB.Add;
3977:
3978: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR then
3979: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_BEST_PRICE_ERROR');
3980: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
3981: FND_MESSAGE.SET_TOKEN('ERR_TEXT',in_status_text);
3982: OE_MSG_PUB.Add;
3983: END IF;

Line 3980: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);

3976: OE_MSG_PUB.Add;
3977:
3978: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR then
3979: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_BEST_PRICE_ERROR');
3980: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
3981: FND_MESSAGE.SET_TOKEN('ERR_TEXT',in_status_text);
3982: OE_MSG_PUB.Add;
3983: END IF;
3984:

Line 3981: FND_MESSAGE.SET_TOKEN('ERR_TEXT',in_status_text);

3977:
3978: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR then
3979: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_BEST_PRICE_ERROR');
3980: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
3981: FND_MESSAGE.SET_TOKEN('ERR_TEXT',in_status_text);
3982: OE_MSG_PUB.Add;
3983: END IF;
3984:
3985:

Line 3990: FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_PRICE');

3986: /*elsif ( in_unit_price < 0 or in_Adjusted_unit_price < 0) and
3987: l_allow_negative_price = 'N' then
3988:
3989: oe_debug_pub.add('Error as Negative Pricing is not Allowed');
3990: FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_PRICE');
3991: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
3992: FND_MESSAGE.SET_TOKEN('LIST_PRICE',in_unit_price);
3993: FND_MESSAGE.SET_TOKEN('SELLING_PRICE',in_Adjusted_unit_price);
3994: OE_MSG_PUB.Add;

Line 3991: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);

3987: l_allow_negative_price = 'N' then
3988:
3989: oe_debug_pub.add('Error as Negative Pricing is not Allowed');
3990: FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_PRICE');
3991: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
3992: FND_MESSAGE.SET_TOKEN('LIST_PRICE',in_unit_price);
3993: FND_MESSAGE.SET_TOKEN('SELLING_PRICE',in_Adjusted_unit_price);
3994: OE_MSG_PUB.Add;
3995: --FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_MODIFIERS');

Line 3992: FND_MESSAGE.SET_TOKEN('LIST_PRICE',in_unit_price);

3988:
3989: oe_debug_pub.add('Error as Negative Pricing is not Allowed');
3990: FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_PRICE');
3991: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
3992: FND_MESSAGE.SET_TOKEN('LIST_PRICE',in_unit_price);
3993: FND_MESSAGE.SET_TOKEN('SELLING_PRICE',in_Adjusted_unit_price);
3994: OE_MSG_PUB.Add;
3995: --FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_MODIFIERS');
3996: --FND_MESSAGE.SET_TOKEN('LIST_LINE_NO',get_list_lines(g_line_id));

Line 3993: FND_MESSAGE.SET_TOKEN('SELLING_PRICE',in_Adjusted_unit_price);

3989: oe_debug_pub.add('Error as Negative Pricing is not Allowed');
3990: FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_PRICE');
3991: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
3992: FND_MESSAGE.SET_TOKEN('LIST_PRICE',in_unit_price);
3993: FND_MESSAGE.SET_TOKEN('SELLING_PRICE',in_Adjusted_unit_price);
3994: OE_MSG_PUB.Add;
3995: --FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_MODIFIERS');
3996: --FND_MESSAGE.SET_TOKEN('LIST_LINE_NO',get_list_lines(g_line_id));
3997: --OE_MSG_PUB.Add;

Line 3995: --FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_MODIFIERS');

3991: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
3992: FND_MESSAGE.SET_TOKEN('LIST_PRICE',in_unit_price);
3993: FND_MESSAGE.SET_TOKEN('SELLING_PRICE',in_Adjusted_unit_price);
3994: OE_MSG_PUB.Add;
3995: --FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_MODIFIERS');
3996: --FND_MESSAGE.SET_TOKEN('LIST_LINE_NO',get_list_lines(g_line_id));
3997: --OE_MSG_PUB.Add;
3998: l_return_status := 'E';
3999: --RAISE FND_API.G_EXC_ERROR;*/

Line 3996: --FND_MESSAGE.SET_TOKEN('LIST_LINE_NO',get_list_lines(g_line_id));

3992: FND_MESSAGE.SET_TOKEN('LIST_PRICE',in_unit_price);
3993: FND_MESSAGE.SET_TOKEN('SELLING_PRICE',in_Adjusted_unit_price);
3994: OE_MSG_PUB.Add;
3995: --FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_MODIFIERS');
3996: --FND_MESSAGE.SET_TOKEN('LIST_LINE_NO',get_list_lines(g_line_id));
3997: --OE_MSG_PUB.Add;
3998: l_return_status := 'E';
3999: --RAISE FND_API.G_EXC_ERROR;*/
4000:

Line 4007: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');

4003:
4004: IF l_debug_level > 0 THEN
4005: oe_debug_pub.add( 'OE_PRICING_ERROR' ) ;
4006: END IF;
4007: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
4008: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '||in_Ordered_Item||' ) '||in_STATUS_TEXT);
4009: OE_MSG_PUB.Add;
4010:
4011: ELSIF in_line_Type_code ='LINE' and in_status_code in

Line 4008: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '||in_Ordered_Item||' ) '||in_STATUS_TEXT);

4004: IF l_debug_level > 0 THEN
4005: oe_debug_pub.add( 'OE_PRICING_ERROR' ) ;
4006: END IF;
4007: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
4008: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '||in_Ordered_Item||' ) '||in_STATUS_TEXT);
4009: OE_MSG_PUB.Add;
4010:
4011: ELSIF in_line_Type_code ='LINE' and in_status_code in
4012: --( QP_PREQ_GRP.G_STATUS_UPDATED,

Line 4027: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497

4023: END IF;
4024:
4025: IF in_status_text is not null then
4026: l_return_status := 'E';
4027: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
4028: FND_MESSAGE.SET_TOKEN('ERR_TEXT',in_status_text);
4029: OE_MSG_PUB.Add;
4030: END IF;
4031:

Line 4028: FND_MESSAGE.SET_TOKEN('ERR_TEXT',in_status_text);

4024:
4025: IF in_status_text is not null then
4026: l_return_status := 'E';
4027: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
4028: FND_MESSAGE.SET_TOKEN('ERR_TEXT',in_status_text);
4029: OE_MSG_PUB.Add;
4030: END IF;
4031:
4032: -- we need to do this check in UPDATED code or do the gsa check through

Line 4062: FND_MESSAGE.SET_NAME('ONT','OE_GSA_VIOLATION');

4058: End;
4059:
4060: l_return_status := 'E';
4061: oe_debug_pub.add('GSA warning or error 2 msg_Text='||l_msg_text);
4062: FND_MESSAGE.SET_NAME('ONT','OE_GSA_VIOLATION');
4063: l_msg_text := l_operand||' ( '||l_msg_text||' )';
4064: FND_MESSAGE.SET_TOKEN('GSA_PRICE',l_msg_text);
4065: OE_MSG_PUB.Add;
4066: END IF;

Line 4064: FND_MESSAGE.SET_TOKEN('GSA_PRICE',l_msg_text);

4060: l_return_status := 'E';
4061: oe_debug_pub.add('GSA warning or error 2 msg_Text='||l_msg_text);
4062: FND_MESSAGE.SET_NAME('ONT','OE_GSA_VIOLATION');
4063: l_msg_text := l_operand||' ( '||l_msg_text||' )';
4064: FND_MESSAGE.SET_TOKEN('GSA_PRICE',l_msg_text);
4065: OE_MSG_PUB.Add;
4066: END IF;
4067: END IF; */
4068:

Line 4826: FND_MESSAGE.SET_NAME('ONT','ONT_AVAIL_GENERIC');

4822: IF l_debug_level > 0 THEN
4823: oe_debug_pub.add( 'MSG DATA IS NOT NULL' ) ;
4824: END IF;
4825: x_return_status := 'E';
4826: FND_MESSAGE.SET_NAME('ONT','ONT_AVAIL_GENERIC');
4827: IF l_debug_level > 0 THEN
4828: oe_debug_pub.add( 'MSG DATA IS NOT NULL 2' ) ;
4829: END IF;
4830: FND_MESSAGE.SET_TOKEN('TEXT',x_msg_data);

Line 4830: FND_MESSAGE.SET_TOKEN('TEXT',x_msg_data);

4826: FND_MESSAGE.SET_NAME('ONT','ONT_AVAIL_GENERIC');
4827: IF l_debug_level > 0 THEN
4828: oe_debug_pub.add( 'MSG DATA IS NOT NULL 2' ) ;
4829: END IF;
4830: FND_MESSAGE.SET_TOKEN('TEXT',x_msg_data);
4831: OE_MSG_PUB.Add;
4832:
4833: END IF;
4834:

Line 4901: fnd_message.set_name('MSC', 'MSC_NO_PLANS_DEFINED');

4897: using l_instance_id,in_inventory_item_id,l_org_id;
4898:
4899:
4900: IF x_plan_id is null then
4901: fnd_message.set_name('MSC', 'MSC_NO_PLANS_DEFINED');
4902: oe_msg_pub.add;
4903: x_return_status := 'E';
4904: oe_debug_pub.add('Plan Id NOT FOUND');
4905: END IF;

Line 4980: fnd_message.set_name('MSC', x_err_mesg);

4976: IF nvl(x_return_status,'S') <> 'S' THEN
4977: IF l_debug_level > 0 THEN
4978: oe_debug_pub.add( ' ERROR IN CALL TO get_supply_sources_local');
4979: END IF;
4980: fnd_message.set_name('MSC', x_err_mesg);
4981: oe_msg_pub.add;
4982:
4983: ELSE
4984:

Line 5038: FND_MESSAGE.SET_NAME('MSC','MRP_ATP_NO_SOURCES');

5034: oe_debug_pub.add( ' THERE ARE NO SOURCES TO BE DISPLAYED ' ) ;
5035: END IF;
5036: x_return_status := 'E';
5037: x_error_mesg := 'MRP_ATP_NO_SOURCES';
5038: FND_MESSAGE.SET_NAME('MSC','MRP_ATP_NO_SOURCES');
5039: OE_MSG_PUB.Add;
5040: x_return_status := 'E';
5041:
5042: END IF; -- IF x_sources.organization_id.COUNT > 0